Menu
  • Option Hydra
  • Training
  • Premium
  • Courses
  • Library

Marketcalls

Simply Intelligent Technical Analysis and Trading Strategies

  • Software
    • Amibroker
    • NinjaTrader 7
    • Ninjatrader 8
    • Option Action
    • Market Analyst
    • Metatrader
    • Python
    • Datafeed
  • Market Profile
    • Orderflow
  • Markets
  • Commodities
  • Forex
  • Economy
    • Banking
  • Webinars
  • Trading Lessons
    • Algo Trading
    • Infographic
    • Video
You are here: Home / Spreadsheet / How to Convert your MS Excel into Dynamic Nifty Heat Map

How to Convert your MS Excel into Dynamic Nifty Heat Map

February 4, 2010 by Rajandran 13 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
Source:
www.marketcalls.in

Related Readings and Observations

  • Merge Indices & Bhavcopy text files into One text fileMerge Indices & Bhavcopy text files into One text file Use the link given to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file. This is a temporary arrangement till the GetBhavCopy gets in order.
  • VBA Macro to Download BhavcopyVBA 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 MS Excel VBA macro copies the Getbhavcopy zip file […]
  • TA Lib Excel Addon installation in Ms Office 2003 & 2007TA Lib Excel Addon installation in Ms Office 2003 & 2007 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 help you in analyzing financial data,which you can be used […]
  • Technical Indicators in Excel Spreadsheet- Free AddonsTechnical Indicators in Excel Spreadsheet- Free Addons Looking for some free tools to help you in analyzing financial data,here is a addon which you can use it in excel spreadsheet to compute Basic technical indicators and it is available at free of cost.
  • Its Time for a Gold Perma Bull? – Long Term AnalysisIts Time for a Gold Perma Bull? – Long Term Analysis Thats Gold monthly timeframe showing consolidation in the band of 1050-1350 for the last 5 years. Monthly ADX is maintaining below 20 since the year 2017 that shows the dullness in the […]
  • About Spam Comments in WordPressAbout Spam Comments in WordPress As a wordpress blogger, iam using Aksimet Plugin to Auto Segregate Good Comments(Ham) from the SPAM. Akismet is the brainchild of Matt Mullenweg, the founder of WordPress. Interestingly […]

Filed Under: Spreadsheet Tagged With: Spreadsheets

About Rajandran

Rajandran is a Full time trader and founder of Marketcalls & Co-Founder of Traderscafe, trades mostly using discretionary Trading Concepts like Market Profile, Trading sentimental analysis, building timing models, algorithmic trading models. Instructs professional traders, full time traders & aspiring full time traders. Rajandran attended college in the Chennai where he earned a BE in Electronics and Communications. Rajandran has a broad understanding of trading softwares like Amibroker, Ninjatrader, Esignal, Metastock, Motivewave, Market Analyst(Optuma),Metatrader,Tradingivew,Python and understands individual needs of traders and investors utilizing a wide range of methodologies.

Comments

  1. sriganeshh says

    February 4, 2010 at 4:56 pm

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

    Reply
  2. Rajandran Rajarathinam says

    February 4, 2010 at 5:17 pm

    oh sure man

    Reply
  3. GANESH says

    February 5, 2010 at 2:52 am

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

    Reply
  4. Doctor Universe says

    February 6, 2010 at 1:32 am

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

    Reply
  5. atul puri says

    February 15, 2010 at 11:09 pm

    great job sir…..
    thnx for ur contribution keep up the good job……………

    Reply
  6. Vishnu says

    February 16, 2010 at 9:36 pm

    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.

    Reply
  7. Selva says

    May 31, 2010 at 12:59 am

    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

    Reply
  8. pramod says

    June 10, 2011 at 2:08 am

    plz send u ph no

    Reply
  9. Dr Raj Najat says

    August 25, 2012 at 10:39 am

    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)

    Reply
  10. sunil says

    March 5, 2013 at 9:29 am

    very good sir..

    Reply
  11. Saras says

    November 8, 2015 at 3:02 pm

    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

    Reply
  12. rahul says

    December 3, 2015 at 12:04 pm

    its not working raghav please update the link

    Reply
  13. Gopalakrishnan says

    January 22, 2019 at 1:38 pm

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

    Cheers
    GK

    Reply

Leave a Reply to GANESH Cancel reply

Your email address will not be published. Required fields are marked *

Email Newsletter

Sign up to receive email updates on latest trading strategies , analysis & financial market updates

We Respect Your Privacy

Premium Access

Username:
Password:
Remember Me
Lost your password?

Tools For Traders

  • Marketcalls Android App
  • MCX Signals
  • Intraday Signals
  • International Commodities
  • OI Tracker
  • Participation OI
  • Your Broker
  • Market Sentiment Analysis

Amibroker Updates

Code Snippet: ATM Call and ATM Put calculation from Spot Prices: Amibroker AFL

December 10, 2019 By Rajandran 2 Comments

Volatile Phases – Colorful ADX Amibroker AFL Code

November 16, 2019 By Rajandran 4 Comments

Amibroker Technical Analysis Workshop – Bangalore

November 1, 2019 By Rajandran 2 Comments

How to Send Alerts from Amibroker to Telegram Channel using Telgram API

June 12, 2019 By Rajandran 15 Comments

How to Estimate the VWAP based settlement Close like a Pro using Amibroker?

June 9, 2019 By Rajandran Leave a Comment

  • Facebook
  • Google+
  • LinkedIn
  • RSS
  • Twitter
  • YouTube

Metatrader Updates

MetaTrader 5 Demo Servers Now Available for BSE Currency Markets

March 20, 2018 By Rajandran 8 Comments

ChartIQ – WebTrader for MT4

December 4, 2017 By Rajandran 5 Comments

Metatrader 4 – Web Platform Overview

October 29, 2015 By Rajandran 9 Comments

William VIX FIX Indicator for Metatrader 4

May 16, 2015 By Rajandran 9 Comments

How to Install Custom MQL4 indicators in Metatrader

November 14, 2014 By Rajandran 7 Comments


About | Contact Us | Terms and Conditions | Privacy Policy | Support Policy | Privacy Policy | Refund Policy | Disclaimer


© Copyright 2018 Marketcalls Financial Services Pvt Ltd · All Rights Reserved · And Our Sitemap · All Logos & Trademark Belongs To Their Respective Owners·

Data and information is provided for informational purposes only, and is not intended for trading purposes. Neither marketcalls.in website nor any of its promoters shall be liable for any errors or delays in the content, or for any actions taken in reliance thereon.