Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

How to Convert your MS Excel into Dynamic Nifty Heat Map

20 sec read

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
Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

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…

Here is a simple video that explains how to install TA Lib Excel Addon installation in Ms Office 2003.Ta-Lib is a free tools to...
Rajandran R
27 sec read

13 Replies to “How to Convert your MS Excel into Dynamic Nifty…”

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

  2. Dear RajandranIts really wonderful. Could I share it with my group ISG clearly mentioning your source.

  3. 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.

  4. 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

  5. Dear Rajandran,
    Please advise me which Indian Trading software gives actual RTD on Excel 2007 and with which broker ?
    ( I tried the ODIN link bur it works only on 2003)

  6. Rajendran sir can you provide an excel sheet which live all nse stocks in which I only want open price , high price, low price, prev closing price

  7. Hello R, yet another great help from you. Strangely the link I believe is not working. Any update on this one mate.

    Cheers
    GK

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More