Rajandran R FollowCreator of OpenAlgo - OpenSource Algo Trading framework for Indian Traders. Building GenAI Applications. Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Building Algo Platforms, Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in
How to Convert your MS Excel into Dynamic Nifty Heat Map
21 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
[wp_ad_camp_5]
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
Related
Rajandran R FollowCreator of OpenAlgo - OpenSource Algo Trading framework for Indian Traders. Building GenAI Applications. Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Building Algo Platforms, Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in
TA-Lib is a technical analysis library for financial market data, widely used by traders and analysts to build trading strategies and make investment decisions....
13 Replies to “How to Convert your MS Excel into Dynamic Nifty…”
Thanks a lot lot lot lot…rajandran.Pl consider exploring fibo trader database setup also whenever time permits…best to usri
oh sure man
Thanks rajandran…its very useful one ..keep it up your good work….Ganesh.
Dear RajandranIts really wonderful. Could I share it with my group ISG clearly mentioning your source.
great job sir…..
thnx for ur contribution keep up the good job……………
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.
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
plz send u ph no
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)
very good sir..
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
its not working raghav please update the link
Hello R, yet another great help from you. Strangely the link I believe is not working. Any update on this one mate.
Thanks a lot lot lot lot…rajandran.Pl consider exploring fibo trader database setup also whenever time permits…best to usri
oh sure man
Thanks rajandran…its very useful one ..keep it up your good work….Ganesh.
Dear RajandranIts really wonderful. Could I share it with my group ISG clearly mentioning your source.
great job sir…..
thnx for ur contribution keep up the good job……………
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.
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
plz send u ph no
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)
very good sir..
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
its not working raghav please update the link
Hello R, yet another great help from you. Strangely the link I believe is not working. Any update on this one mate.
Cheers
GK