How to Convert your MS Excel into Dynamic Nifty Heat Map

Simply Intelligent Technical Analysis and Trading Strategies

4 February 2010 866 views 6 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

Written by: Rajandran R

(1 votes, average: 5.00 out of 5)

Loading ...

sriganeshh said:
Thanks a lot lot lot lot…rajandran.Pl consider exploring fibo trader database setup also whenever time permits…best to usri

# 4 February 2010 at 4:56 pm
Rajandran Rajarathinam said:
oh sure man

# 4 February 2010 at 5:17 pm
GANESH said:
Thanks rajandran…its very useful one ..keep it up your good work….Ganesh.

# 5 February 2010 at 2:52 am
Doctor Universe said:
Dear RajandranIts really wonderful. Could I share it with my group ISG clearly mentioning your source.

# 6 February 2010 at 1:32 am
atul puri said:
great job sir…..
thnx for ur contribution keep up the good job……………

# 15 February 2010 at 11:09 pm
Vishnu said:
Dear Rajndrn,

Very useful as small file and update is also very fast. easy to know which are moving and which are dragging… tnx vy much.

# 16 February 2010 at 9:36 pm