Spreadsheet

Merge Indices & Bhavcopy text files into One text file

Use the link given to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file....
rajib
34 sec read

VBA Macro to Download Bhavcopy

Here is a initiative from me to automate the NSE EOD data in ASCII format using simple VBA Scipts in MS...
Rajandran R
1 min read

TA Lib Excel Addon installation in MS Office 2003 & 2007

TA-Lib is a technical analysis library for financial market data, widely used by traders and analysts to build trading strategies and...
Rajandran R
38 sec read

Technical Indicators in Excel Spreadsheet- Free Addons

Looking for some free tools to help you in analyzing financial data,here is a addon which you can use it in...
Rajandran R
1 min read

How to Extract Data from Nseinda.com using Google Docs

Here is a short and very simple video tutorial about how to extract remote data from a webpage(nseindia.com) into your google...
Rajandran R
10 sec read

How to Convert your MS Excel into Dynamic Nifty Heat Map

Here is a simple Web Query Based Excel Spreadsheet, Which converts your MS Excel into Dynamic Nifty Heat Map with an...
Rajandran R
19 sec read

Complete Historical NSE EOD database – Amibroker Format

  Download Complete EOD database for Amibroker for the starting of NSE upto 01 OCT 2009 Steps to Setup the...
Rajandran R
18 sec read

Simple Financial SpreadSheets – Kids Stuff

Excel Web Query – What in the world is that? If you are like the other 99.9% of MS Excel users,...
Rajandran R
1 min read