Download Historical Stock Data into Excel using AlphaVantage API

Trading Excel Sheet

An accurate source of historical data is mandatory for the market analysis as well as backtesting. Most of the traders use Excel sheets for stock data analysis, and until Aug 2018 Google finance was the best source of free historical… Continue Reading

Options Strategy Payoff Calculator Excel Sheet

Options Trading Strategies

Options are one of the most fascinating and versatile financial instruments. While trading in stocks or commodities, you can bet on only one thing, i.e., the direction of the price. You simply buy when you are bullish and sell when… Continue Reading

Parabolic SAR Trading System: Intraday Live Signals and Excel Sheet

Trading Excel Sheet

The Parabolic SAR Time/Price System was developed by J. Welles Wilder and was first featured in his book New Concepts in Technical Trading Systems in 1978. The Parabolic Time/ Price system derives its name from the fact that when charted,… Continue Reading

Chaikin Money Flow Excel Sheet with Buy Sell Signals

Trading Excel Sheet

Chaikin Money Flow is one of the popular indicators used by majority of active traders especially technical analysts. It is the foundational building block of some very profitable algorithmic trading systems. In this post, we would go through a fully… Continue Reading

Supertrend Indicator Excel Sheet with Realtime Buy Sell Signals

Trading Excel Sheet

Supertrend is a popular trend following indicator which works particularly well in Intraday timeframe. As a technical analyst, you might have across this indicator quite often during your studies. It is known for its preciseness and accuracy in all the… Continue Reading

NSE BSE Arbitrage Trading: Live Signals and Excel Sheet

Trading Excel Sheet

Did you ever know that NSE BSE Arbitrage contributes to the major volume of trading in India? And this is true for other exchanges too in different countries. Well, arbitrage is so far considered as the safest trading strategy and… Continue Reading

A Profitable Swing Trading Strategy: Live Signals and Backtest Results

Trading Excel Sheet

Swing Trading is a popular short term trading method which is less riskier as compared to Intraday trading. In swing trading, positions are held for an average of 2 to 6 days, but in some cases can be extended beyond… Continue Reading