Realtime prices into Excel from NOW, NEST or ODIN

Pritesh Excel

Introduction

In this article, we will look at how to get realtime price & other data into Excel. You can get realtime prices & other information from NSE, BSE & MCX.

This article is for NOW, NEST & ODIN trading platforms. These platform have an option to link Market Watch to Excel.

You can use live data for your analysis of stocks.

Demo Video

Realtime Data into Excel from NOW, NEST or ODIN

Prerequisite

You must have NOW, NEST or ODIN trading terminals. Please ask your broker to get these terminals.

Procedure

  1. Start your trading terminal (NOW, NEST or ODIN) as administrator (Run as administrator).
  2. Add all the stocks (scrips) which you need into your market watch.
  3. Right click on Market Watch header row to add/remove columns based on your needs
  4. Start Microsoft Excel (Run as administrator).
    1. Create a new excel & save it
    2. You can even open an existing excel, if you need data in your existing file
  5. Right click in your Market Watch -> Link to Excel -> All Items
    1. NOW & ODIN terminals also have similar options
  6. Right click on the first cell in excel (top – left) & click Paste.
  7. That’s it, you have live ticking data into excel.

Conclusion

A quick way to get live data into excel, which then can be used for analysis & trading.

Tags:

I have around 15 years of experience developing Financial Software. I took a break from my career to start my own algorithmic trading setup. This new journey started well and along with my own proprietary trading systems, I also started building automation systems for retail traders, fund managers and HNIs. I was employed with firms like Morgan Stanley, HSBC & SunGard. I work on various technologies, but my strengths are building server side cloud based algorithmic trading systems built primarily using Java programming language. Apart from all of this, I am a big fan of Formula 1 racing :-)

8 thoughts on “Realtime prices into Excel from NOW, NEST or ODIN”
  • Mahesh says:

    I have try, but not success. My Mo. No. 9881376151

    September 22, 2019 at 2:24 pm
    • Admin says:

      Send a mail to support explaining your difficulties.

      September 29, 2019 at 6:54 am
  • Ankit says:

    What are the maximum scrips we can link to excel?

    June 24, 2020 at 10:20 am
    • Pritesh says:

      That depends on your stock broker. They set maximum limit for a market watch.

      June 24, 2020 at 10:42 am
  • selvakumar Kaliaperumal says:

    Hello Brother , Good Work, Can you guide to place BO by using Excel to NEST

    July 24, 2020 at 9:10 pm
    • Pritesh says:

      BO is not supported on NEST. Which broker are you trading with? Check if it is supported on AutoTrader-Web.

      July 27, 2020 at 12:06 pm
  • sultan says:

    HI,
    Can you please know me when Master trust broker will work on your platform ?

    July 31, 2020 at 6:09 pm
    • Pritesh says:

      By the end of September 2020, this is a tentative date might move back or forward as well.

      August 1, 2020 at 7:26 am

Comments are closed.