Use the link given to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file. This is a temporary arrangement till the GetBhavCopy gets in order.
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 Excel. The following MS Excel VBA macro copies the Getbhavcopy zip file corresponding to 02Nov2010 from NSE India portal into your local drive(c:\eoddata) and then extracts the Zip file and shows you the content in the csv file.
TA Lib Excel Addon installation in Ms Office 2003 & 2007
Here is a simple video that explains how to install TA Lib Excel Addon installation in Ms Office 2003.Ta-Lib is a free tools to help you in analyzing financial data,which you can be used in excel spreadsheet to compute Basic technical indicators and it is available at free of cost.
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 excel spreadsheet to compute Basic technical indicators and it is available at free of cost.
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 spreadsheet. It also describes how to share the Extracted table content to the external world.
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 auto update of every 1 minute from the source Buzzing Stocks Conditional Formatting is then applied to the resulting Web Query to Detect positive and negative stocks for the day and are highligted […]
How to Setup IEOD Amibroker Database
Power Point Slide to Demonstrate How to Build IEOD Amibroker database from Investbulls.com Download the Powerpoint Show Source: www.marketcalls.in
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 EOD database 1) Download the database from the above mentioned link 2)Extract the Zip file and Save it to the folder c:Program FilesAmibroker 3)Open Amibroker 4)Select Open Database from the Menu Bar 5)Select the Broker.Master […]
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, you probably have never heard of microsoft excel web queries Excel web queries are powerful! Web queries strips web pages of useless stuff and gives you access to the essential information. You can then […]