How to Convert your MS Excel into Dynamic Nifty Heat Map
[2/04/2010 07:33:00 PM | 4 comments ]

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


Now you can anonymously surf the Nifty50 Stock Prices without your knowledge of your Boss!
All you need is the internet connection

4 comments

sriganeshh said... @ February 4, 2010 at 9:56 PM

Thanks a lot lot lot lot...rajandran.
Pl consider exploring fibo trader database setup also whenever time permits...

best to u
sri

Rajandran said... @ February 4, 2010 at 10:17 PM

oh sure man

GANESH PL said... @ February 5, 2010 at 7:52 AM

Thanks rajandran...its very useful one ..keep it up your good work....

Ganesh.

Doctor Universe said... @ February 6, 2010 at 6:32 AM

Dear Rajandran

Its really wonderful. Could I share it with my group ISG clearly mentioning your source.

Post a Comment