RealTime_NOW_Excel_Amibroker

R

Raju

Well-Known Member
#1
#1
Friends,

Following is the process I have used to fetch Real-time quotes from NOW to Excel, and Excel to Amibroker using DDE.Similar process can be used to fetch RTD from Sharekhan TT 2.0 to Excel and Excel to Amibroker
________________________________________
Disadvantage I am using it for fetching only one Symbol quotes as I have found a problem while fetching quotes for multiple scrip. (Will update the problem later)
________________________________________


Changes required in NOW s/w
1.In market watch, right click reposition columns OR (Shift + R) and add the following
Symbol | Trading Symbol | Last Traded Price | Last Traded Quantity |Percentage Change

Changes required in Office 2007
  1. Open excel
  2. Click Office button
  3. Click Excel options
  4. Click Trust Center
  5. Click Trust Center Settings
  6. Click Trusted Locations
  7. Click add new location and provide C:\Program Files\NOW\ , Remember to check Subfolders of this are also trusted
  8. Click Ok and close Office

Create two empty excel sheet on "C:\" (One could be enough, but this is what I am successful at)
(Pl.Note - This process could be simplified I am sharing what I have done)

  1. Create empty file in C:\GetNOWData.xlsx
  2. Create empty file on C:\NSE.xlsx
 

We need to request Zerodha to activate linking to Excel feature for our account.


Transfer NOW to Excel (GetNOWData.xlsx)


  1. Open NSE NOW , Right Click Marketwatch and navigate to Link to Excel
  2. Click All Items
  3. Paste the data in GetNOWData.xlsx
  4. The file would have the following in excel
  5. Symbol | Trading Symbol | Last Traded Price | Last Traded Quantity | Percentage Change
 
R

Raju

Well-Known Member
#2
#2
Transfer Excel (GetNOWData.xlsx) to Excel (NSE.xlsx) (This step could be avoided by using single excel file, but I havent tried with single file)

  1. Open c:\NSE.xlsx
  2. Manually type MINIFTY11OCTFUT Column A1 ( Of NSE.xlsx file )
  3. Click Column B1 and enter the following in the B1cell
    =GetNOWData.xlsx!$c$2

Explanation of =GetNOWData.xlsx!$c$2
GetNOWData is the excel file in which we had pasted the data from NOW.
We are pulling the Last Traded Price from GetNOWData file to B1 column of NSE.xlsx file.

  1. Click Column C1 and enter the following in it C1 cell ( Of NSE.xlsx file )
=GetNOWData.xlsx!$D$2

Explanation of =GetNOWData.xlsx!$D$2
GetNOWData is the excel file in which we had pasted the data from NOW.
We are pulling the Last Traded Qty from GetNOWData file to C1 column of NSE.xlsx file.
 
R

Raju

Well-Known Member
#3
#3
Please find images describing how to name the cell of NSE xlsx file for further linking it to excel.
 
Last edited:
R

Raju

Well-Known Member
#4
#4
Final display of Name Manager when you select B1 or C1 and press Alt+I+N+D

I will share the actual excel files used by me, but all this is to troubleshoot in case of issues and further improvement.
 
Last edited:
R

Raju

Well-Known Member
#5
#5
Reserved ....Settings to be done in amibroker - Will be decribing here.
 
Last edited:
J

jagankris

Well-Known Member
#6
#6
What's the problem you are encountering ?


Raju said:
Friends,

Following is the process I have used to fetch Real-time quotes from NOW to Excel, and Excel to Amibroker using DDE.Similar process can be used to fetch RTD from Sharekhan TT 2.0 to Excel and Excel to Amibroker
________________________________________
Disadvantage I am using it for fetching only one Symbol quotes as I have found a problem while fetching quotes for multiple scrip. (Will update the problem later)
________________________________________


Changes required in NOW s/w
1.In market watch, right click reposition columns OR (Shift + R) and add the following
Symbol | Trading Symbol | Last Traded Price | Last Traded Quantity |Percentage Change

Changes required in Office 2007
  1. Open excel
  2. Click Office button
  3. Click Excel options
  4. Click Trust Center
  5. Click Trust Center Settings
  6. Click Trusted Locations
  7. Click add new location and provide C:\Program Files\NOW\ , Remember to check Subfolders of this are also trusted
  8. Click Ok and close Office

Create two empty excel sheet on "C:\" (One could be enough, but this is what I am successful at)
(Pl.Note - This process could be simplified I am sharing what I have done)

  1. Create empty file in C:\GetNOWData.xlsx
  2. Create empty file on C:\NSE.xlsx
 

We need to request Zerodha to activate linking to Excel feature for our account.


Transfer NOW to Excel (GetNOWData.xlsx)


  1. Open NSE NOW , Right Click Marketwatch and navigate to Link to Excel
  2. Click All Items
  3. Paste the data in GetNOWData.xlsx
  4. The file would have the following in excel
  5. Symbol | Trading Symbol | Last Traded Price | Last Traded Quantity | Percentage Change
Click to expand...
 
R

rpc

Active Member
#7
#7
Can someone pls tell if NOW can be used by individuals/non brokers or sub-brokers.Secondly is it free.thirdly from where it can be downloaded.
 
R

Raju

Well-Known Member
#8
#8
Hi jagankris ,

I am able to fetch quotes for multiple scrip.

At times quotes for BankNifty get appended to Nifty/Minifty.It depends upon which one is selected while opening of Amibroker.Banknifty is one example I have given.If u have selected Nifty while working on AM and then saved and closed AB.Next time it would create problem.I will explain further in detail . I beleive at least those who can want to use only for one scrip..then this method works fine ..free of cost..Realtime.

I am a bit lazy at documentation.Let me update the entire process first then maybe we can discuss in solving issues.And I trade nowadays only in minifty so did not bother much to reolve multi scrip issue.


I am in the process of creating EOD pivot excel ..which would download EOD quotes from NSE for futures/options/cash and show u pivot points for records.

Regards,
Raju
 
ocil

ocil

Well-Known Member
#9
#9
Raju said:
Hi jagankris ,

I am able to fetch quotes for multiple scrip.

At times quotes for BankNifty get appended to Nifty/Minifty.It depends upon which one is selected while opening of Amibroker.Banknifty is one example I have given.If u have selected Nifty while working on AM and then saved and closed AB.Next time it would create problem.I will explain further in detail . I beleive at least those who can want to use only for one scrip..then this method works fine ..free of cost..Realtime.

I am a bit lazy at documentation.Let me update the entire process first then maybe we can discuss in solving issues.And I trade nowadays only in minifty so did not bother much to reolve multi scrip issue.


I am in the process of creating EOD pivot excel ..which would download EOD quotes from NSE for futures/options/cash and show u pivot points for records.

Regards,
Raju
Click to expand...
It can be big help if you upload the excel file. thanks:clapping:
 
You must log in or register to reply here.