Written and contributed by Rich Kaczmarek Managing Risk When Entering, Exiting, or Rolling Positions.Boost Trading Results Through Proper Back Testing.Advanced Personal and Position Management.Personal Coaching and Mentoring Sessions.Options Trading for Income Weekly Webinar.With Velocity, also using Excel’s ADD IN functionality to add forms, you would be able to also download Tick, 1, 5, 15, 60 min & EOD Historical Data. This application can help you analyse 200 – 500 NSEEquities, Indices, ETFs, Futures & Options in Real-time in Excel at the same time 0 is one such software which can provide you with NSE Stock Prices in Excel. Some older applications used DDE to import real-time data into Excel but this is now a thing of the past as we have the more powerful and versatile RTD function in Excel. The RTD function is an excellent way to retrieve real-time data from a program that supports COM automation. To be able to enable this ability and more, you will need to exploit the Excel’s RTD Function. Just simply tracking your portfolio in real time.Keeping track of complex options strategies where a number of options need to be tracked at the same time.

Can even help you with data mining and pattern exploration studies.

Tracking their open interest/price variations, while studying the put/call ratios & option Max Pain analysis

Very useful for tracking a large number of options simultaneously eg.

Build and backtest your strategies involving more than 1 scrip eg.

Create complex trading systems and conduct technical analysis calculations directly in your worksheets.With only a little knowledge of Excel, you can implement new strategies/ideas, back-test them and even paper trade these strategies before going live.Įxcel can sometimes do things which many technical analysis applications may not be able to.

Download stock quotes into excel 2007