Realtime data NOW,ODIN,TradeTiger,Google,Yahoo > AmiBroker, Fcharts, Qtstalker

Status
Not open for further replies.
Thanks Sikandar,

I do not see any field equivalent to 'Volume Traded Today' that holds cumulative volume for the day, in Arbitrage. Please confirm if it is there. If not, I will have to revert the code to earlier version.
hi josh1
I checked, it is just volume.And not as 'Volume Traded Today' that holds cumulative volume for the day, in Arbitrage.I think it is just volume for the snap.
kind regards
:)
 
Dear Josh,

I am not able to get data from Arbitrage.xls (from ODIN) to RTNow.xls. The data in arbitrage .xls is getting changed as per ODIN but same is not reflected in RTNow.xls. RTNow.xls just shows value as 0. Can you pls help me? I am using windows Vista and MSOfffice 2007.
Is there any separate file for ODIN apart from RTNow?

Thanks & Regards,

Pravin
 

josh1

Well-Known Member
Dear Josh,

I am not able to get data from Arbitrage.xls (from ODIN) to RTNow.xls. The data in arbitrage .xls is getting changed as per ODIN but same is not reflected in RTNow.xls. RTNow.xls just shows value as 0. Can you pls help me? I am using windows Vista and MSOfffice 2007.
Is there any separate file for ODIN apart from RTNow?

Thanks & Regards,

Pravin
You have to manually type formula '=[Arbitrage.xls]Sheet1!L6' in each cell of RTNOW, of course without quotes and replace cell reference (L6) with which ever cell you want. In my case, L6 contains price. Separate file is there but It contains linking formula for start. It may not work out of the box on your PC.
 
You have to manually type formula '=[Arbitrage.xls]Sheet1!L6' in each cell of RTNOW, of course without quotes and replace cell reference (L6) with which ever cell you want. In my case, L6 contains price. Separate file is there but It contains linking formula for start. It may not work out of the box on your PC.
I missed to mention that the formula '=[Arbitrage.xls]Sheet1!L6' works in other new xls sheet, it shows dynamic values as per arbitrage, but when I type this formula in RTNow, it shows value as 0. I tried with different cell in other sheets of RTNow but it doesn't show any value. It looks like something is wrong with the file I have downloaded.
Do you want me to try with some other file? If so could you pls share other file to me. My email id is [email protected]. Thanks!
 
hi

I did all the setup as per the instructions in the video but still it's not working for me. The RT data is not being copied into the excel.Can you please suggest what could be the issue. I'm using zerodha trader and excel 2007.
 

josh1

Well-Known Member
hi

I did all the setup as per the instructions in the video but still it's not working for me. The RT data is not being copied into the excel.Can you please suggest what could be the issue. I'm using zerodha trader and excel 2007.
You cannot copy data. You have to click on 'Link to excel' and then paste in excel
 
Hi All,

Been using RT3 utility of Josh1 for past few months.(Thank you very much Josh.)It is working perfectly.No issues there.

Now trying to use the RTG3 by using Google data.But data not coming on to excel sheet.

I have followed all the instructions like:putting RTG3 in a trusted location. RTG3 format file in Amibroker format folder.Appropriate date and time format.Logging in to Google Finance.I am missing some thing.

Pl help.

thanks
:thanx:
PKJ
 

josh1

Well-Known Member
Hi All,

Been using RT3 utility of Josh1 for past few months.(Thank you very much Josh.)It is working perfectly.No issues there.

Now trying to use the RTG3 by using Google data.But data not coming on to excel sheet.

I have followed all the instructions like:putting RTG3 in a trusted location. RTG3 format file in Amibroker format folder.Appropriate date and time format.Logging in to Google Finance.I am missing some thing.

Pl help.

thanks
:thanx:
PKJ
PKJ

Use new RTGoogle instead. I have made some changes to it. I shall upload it tonioght. Download from link in my signature tomorrow and give feedback after using.
 
Last edited:
Dear Josh,

The issue of Amibroker db is resolved now and I am able to get data in Amibroker from RTOdin.xls.
Now another question - how can I backfill data from past few days? Is it possible from ODIN, if yes then could you pls share the procedure?
I tried to dig in this thread, somewhere it is mentioned to refer to RohitB's thread but I could not get meaningful info from that thread.

Also I find that ODIN provides only half an hour data in Market Movement menu for current day.

I would appreciate if anyone else using ODIN to backfill data to Amibroker. Thanks all for your help.

regards,

Pravin
 
Status
Not open for further replies.

Similar threads