Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts MS

Status
Not open for further replies.

gambler

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

It wasnt tested with NOW, maybe it needs code changes to work with it. The interface is same so i thought it might work.
The COM error code seems to state that the input is incorrect.

1. Just for reference, can you copy the link to excel line here. ( ie what you copy in excel for RTD )

2. I dont have any account with NOW so i cant test it.
If someone can provide me a login with RTD i can try to check.
Or you will have to wait untill i try out a broker that has NOW. Code is open - any one can try to fix it.
btw can we have Nest/ZT and NOW both installed together?
=RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Trading Symbol") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Trade Time") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Traded Price") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Volume Traded Today") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Open Interest") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Symbol") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Expiry Date") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Trade Qty") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Option Type") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Strike Price")
 

Snake.Head

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Anyone facing problem with getting feed from Excel to amibroker [RTgoogle]
I am getting quotes from google to excel,but not able to feed in charting program

I have amibroker installed in C:\Program Files [That should not problem as i given both software administrator Privilege amibroker and excel]
64 Bit Windows 7 But both office and amibroker is x86 version[32bit]

I checked following thing
1] Excel and amibroker both are running in Administrator.
2] *.format copied both file formats to format folder in amibroker.
3] Checked and confirmed Set up database properly in amibroker.
4] Add 'RTNOW' folder in trusted location.
Below is image from excel

And Database settings


Edit i got
I missed database part cell B1 and i mixed with ram disk path.
 
Last edited:

Snake.Head

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

I got above problem sort it out.
Symbol are not showing in amibroker.
I have re-installed amibroker and took fresh RTGoogle.xlsm
Still can't it right done.
Does RTGoogle.xlsm create .txt ?
 
Last edited:

TracerBullet

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

=RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Trading Symbol") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Trade Time") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Traded Price") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Volume Traded Today") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Open Interest") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Symbol") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Expiry Date") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Last Trade Qty") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Option Type") =RTD("NOW.ScripRTD",,"MktWatch","nse_cm|AXISBANK-EQ","Strike Price")
Ok, the problem is "MktWatch". In Nest we dont have it.

The text after "NOW.ScripRTD",, are called as topics. We have an array of topics for each field. In Nest we have two - Scrip ID and Field ID.
In NOW we have three - "MktWatch" , Scrip ID and Field ID.

To minimize work, for now i will do a quick dirty fix. If the server prog id is NOW.ScripRTD, i will add Topic 1 as "MktWatch" manually.

Later on if needed, we could make it more general by accepting generic topic array for each field. I didnt do it this way before to make settings.ini a little simpler without repetitions.
 

gambler

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

This output is not from new build i think. The error message was changed a bit.
Recheck that you running new exe
Hello TracerBullet,

Is it possible for you to check with team viewer? Thanks!

Id = 909994419
pass= 9900
 

TracerBullet

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

We can do it tomorrow,

But first, delete you old version, download new and test it.
https://www.dropbox.com/s/ob8e7g9zbk8re3j/NestRTD.0.1.2_test.7z

I say so, because i added some more data at the end of the error line that i dont see in you Screenshot.
I just tested it in a VM with xp (Nest) and the error message had the new parameter (after big -ve number).
 
Status
Not open for further replies.

Similar threads