Spreadsheet

How to Get Futures and Options Data and Commodities…

In this blog, we will explore how to use Algomojo to get futures and options data and commodities data into Google Spreadsheet, step by...
Rajandran R
4 min read

Algomojo Google Spreadsheet to Transmit Basket Orders, Larger Orders,…

Algomojo, the leading algorithmic trading platform, is proud to announce the launch of its latest feature - the Google Spreadsheet Module. The new module...
Rajandran R
1 min read

Merge Indices & Bhavcopy text files into One text…

Use the link given to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file. This is a...
rajib
36 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 Excel. The following...
Rajandran R
1 min read

TA Lib Excel Addon installation in MS Office 2003…

TA-Lib is a technical analysis library for financial market data, widely used by traders and analysts to build trading strategies and make investment decisions....
Rajandran R
40 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 excel spreadsheet to...
Rajandran R
2 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 spreadsheet. It also...
Rajandran R
11 sec read

How to Convert your MS Excel into Dynamic Nifty…

Here is a simple Web Query Based Excel Spreadsheet, Which converts your MS Excel into Dynamic Nifty Heat Map with an auto update of...
Rajandran R
20 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 EOD database 1)...
Rajandran R
19 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, you probably have...
Rajandran R
1 min read