How to Convert your MS Excel into Dynamic Nifty Heat Map

Simply Intelligent Technical Analysis and Trading Strategies

Home » Spreadsheet

How to Convert your MS Excel into Dynamic Nifty Heat Map

4 February 2010 2,869 views 7 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

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

Random Posts

Investor Or A Gambler ?
I read an article on this topic last winter, it definitely compelled me to look at my own investment styles and interests. At the end of it I could honestly say that I don't have a stock market/gambling addiction. Addictions seem to start out inno...
A Nifty Chart Speaks more than explaining about it
Source: www.marketcalls.in...
Download the New Rupee Symbol Font
Foridan Technologies had made the first font with support for Indian currency symbol .Download the rupee font, install it and enjoy it...
Test Streaming – Live Marketcalls TV
Watch live streaming video from marketcalls at livestream.comSwitch to Full Screen VideoStreaming Amibroker Realtime Data for Nifty(5 Minute NMA Charts) till 3:30P.MBroadcasting timings : 9:55A.M-3:30P.MFeed Will be Delayed upto 1-2 Minutes due...
TATA STEEL Struggling near GANN Supports
Tata Steel Struggling near GANN Supports near 420. Failure to hold 420 will target Rs 300 Source: www.marketcalls.in...

(2 votes, average: 5.00 out of 5)

Loading ...

7 Comments »

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

Selva said:

Hi,

Is there a way i can get Images in excel?
I usually keep yahoo TA charts which i would like to incorporate into the excel. I tried few but they arent keeping image but only text.

Selva

# 31 May 2010 at 12:59 am