RealTime_NOW_Excel_Amibroker

R

Raju

Well-Known Member
#41
#41
sikandar said:
hi
me too also wanted help
:)
Click to expand...
I would like to request you to try it yourself if not tried.As it is simple process.
As I mentioned earlier fetching single stock quote is working very well .But for multiple it has some issue which I am rectfying for quite a long time .

If U have problems while fetching for single stock quote I will surely help.

Regards,
Raju
 
tomjerry

tomjerry

Well-Known Member
#42
#42
Raju said:
.....
Regards,
Raju
Click to expand...
Hi Raju, I opened account with RKSV and today installed NOW on my Windows 7 64-bit laptop with Excel 2010 32-bit.

I followed your step by step instruction as mentioned in your Post#1 & 2 but I am not getting data in Excel File, instead I am getting cell value/result as "#N/A" which has this formula "=RTD("now.scriprtd",,"MktWatch","nse_fo|NIFTY12MAR5400CE","Symbol")".

Please note that:
[a] I have admin right on laptop but I am not able to create excel file on "C:/" since permission is denied and when i tried to give "full control" from security, it failed, so I created Excel file on "E:/".
If RKSV has to do anything in my account then please tell me that exactly what they have to do because they are new to use NOW and once i asked them at that time they said that they don't know about getting data from NOW to Excel!

thanks.
 
R

Raju

Well-Known Member
#43
#43
tomjerry,

U can keep the excel at any location.Please check if u have given permission via Excel options - trust center.
If NSE NOW is installed in "D:\program files\NOW" , then add this folder and subfolder in trusted location.

I had requested Zerodha to activate linking to Excel feature for my account.What Zerodha did from their end is not known to me.In fact U can call NSE NOW support staff and ask the procedure for backend .Your broker should call them.

I hope this helps.

Regards,
Raju
 
Last edited:
tomjerry

tomjerry

Well-Known Member
#44
#44
Raju,

Added NOW in Trust Center and permission given, NOW is located in C drive--These are ok since beginning.

To solve this problem, I think I have to ask Broker and NOW helpdesk since everything is ok from my side as per your opinion.

Thanks for quick reply :)
 
C

coriolis3

New Member
#45
#45
Raju said:
Coriolis3,

Have you tried the process yourself ?
I do not have OD client.Once you learn the steps U would be able to debug and improve.

For fetching multiple quotes in AB I am trying using scripting, so it would take time as I am not a Programmer.But for single quote fetching it works perfect.No issues at all.

If you need help for fetching single quote we can try.

In any client (ODI/TT/NEST/NOW) if linking is present then it is very much possible to pull quotes to AB.

Regards,
Raju
Click to expand...

Dear Sir,

Thank you for the help and guidance.

Will revert if any problem faced.

Thanks.
Coriolis3
coriolis3 at gmail dot com
 
K

kulkarni

New Member
#46
#46
hello,
i am using sharekhans trade tiger 2.2.0 which include snap to excel but i dont know how to connect it with amibroker. pls. help me
thank you
 
R

Raju

Well-Known Member
#47
#47
kulkarni said:
hello,
i am using sharekhans trade tiger 2.2.0 which include snap to excel but i dont know how to connect it with amibroker. pls. help me
thank you
Click to expand...
Hi,

It is possible to pull quotes from TT also.In case of Sharekhan TT first create the snap with required scrip and then do the configuration as mentioned in first few posts.And while opening first open TT,load the snap and then start AB.

U can do it with single xls file.

Just remember that if scrip name is "Slvr fut2012",then change the name to SLvrfut2012.Space in the name of the scrip did not work few days back.

I will try to create a separate document for TT - (Single/Simple document)



Regards,
Raju
 
M

meena07

Active Member
#48
#48
Rajuji
I am having Angel ODIN as described by 2 gentlemen above.
I am interested in NF only for time being.
A small doubt : Do this utility has ability to backfill data if net connection goes down OR suppose i did not open ODIN on any day. ?
 
R

Raju

Well-Known Member
#49
#49
meena07 said:
Rajuji
I am having Angel ODIN as described by 2 gentlemen above.
I am interested in NF only for time being.
A small doubt : Do this utility has ability to backfill data if net connection goes down OR suppose i did not open ODIN on any day. ?
Click to expand...
No "ji" please .I am very young (Only 80 yrs old :) )...

This is a simple process to fetch quotes from broker terminal to excel and then Amibroker would pull the same quotes from excel.

There is no backfill option.Backfill is manual process.(Saving quotes from TradeTiger to csv and importing it to AB.



Regards,
Raju
 
You must log in or register to reply here.