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.

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 in red(negative) and green(Positive) color
Download Nifty Heat Map Excel Sheet
Now you can anonymously surf the Nifty50 Stock Prices without your knowledge of your Boss!
All you need is the internet connection
Source:
www.marketcalls.in

Power Point Slide to Demonstrate How to Build IEOD Amibroker database from Investbulls.com
Download the Powerpoint Show

Source:
www.marketcalls.in

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 Files\Amibroker\ 
3)Open Amibroker
4)Select Open Database from the Menu Bar
5)Select the Broker.Master File from the folder c:\Program Files\Amibroker\NSE EOD

Bingo you are done

One can further update the day to day EOD Database from http://livenifty.com/downloads-eod.html
Source:
www.marketcalls.in

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 use Excel formulas (like =A1/B2) to work directly with the data you’ve downloaded. Even one can build realtime data without prior knowledge of Programming.
Web queries can be used for importing stock quote data into Excel. For rapidly changing data …