How to get RTD from ANY software to Amibroker - Free

#13
The problem with v 3.15 is, it works at its will.
Sometime it will work (RTD) without any problem, with manual backfill.
and sometime it wont work
 

OneThatGotAway

Well-Known Member
#15
ok since u already use shubhlala here is trick....
at exactly 9:14 and 30 sec start your nest client .

Moment your below screen is gone BE quick as cat and press start instantly in shubhlala
it will start amibroker .


if u are late even by 5 sec it wil say marketwtch not present give it 2-3 shot i am sure u will have success
video i am try to make on Thursday.. don;t have software ,my primary comp hdd broke so was today entire day
busy in that. And to make video now live market be on thursday :xD
 
#16
Hi every one,
There are various free and paid softwares out there that can get you RTD into Ami. The problem - most of them are custom made and wont work even if there is slightest difference in your system and creators system. Also they work only on intended platform. Like Nest2Ami, Josh1 's utility etc will only work with NEST 3.11 only. Also many of the creators have mistakenly left out the vital parts from their setup guide which are essential for tech novices. Like when I tried using Josh1 no readme or setup guide told me that the new Database that you gonna create must be prepopulated with symbols. I just couldn't get why my Ami is not showing all the ticks and charts. Guess what, I had no symbols in new database. And The user manual that came up with Josh's left that vital part apart. It tells us to create new database and put the link in excel sheet and your rtd will start. Fortunately I got some real support from @ocil. Although my problem with Josh is still unresolved, the supportive gesture was good enough for me to start searching once again.
Here is the best platform neutral way of getting RTD data into amibroker free of cost. - using DDE plugin

1. Requirements -
1. Any platform from any broker of any version with "link to excel" facility - Nest, Pi, Fyers One, Dartstock, etc etc
2. Functional Amibroker
3. MS office - any version, latest will be good

2. Here we will first get RTD from platform to excel sheet, then the data will be forwarded to Amibroker.

3. Setup:

1. Open up your software. Login. Open a market watch. Now if you have superfast internet which can handle all the data, there is no need to cherry pick columns that you wanna export to excel. In every platform there many be slightly different way of getting RTD to excel. For eg in Dartstock you get the button in MW toolbar which says "link to excel". Just search here and there and figure out the platform specific procedure.
But most important point is that while opening excel, it must be opened as admin.

Pi: In MW just right click on any scrip and click link to excel. It will automatically open the excel. Note the path where the file is saved while closing the excel. Now directly open excel as admin and from there open the excel that we just saved. Now you are getting the RT Data from Pi to Excel
Dartstck: Dartstock you get the button in MW toolbar which says "link to excel". Now directly open the excel as admin and paste in the first cell of the sheet. Save the excel sheet anywhere you want. From next time do not directly open this excel file but open excel directly and then open the sheet from within the main program.

There are already much on web for this for this first step. Just ask Google Baba. Just remember that once you have saved the respective excel sheet. NEVER open it directly. Open main excel program as admin and open the excel sheet of RTD from within file menu.


2. Now part 2 consists of dressing up the excel sheet and make it ready for DDE server.
For this part it is useful if at earlier stage you just linked Ticker, LTP and LTQ columns only. But DDE plugin has O, H, L, C, LTQ, Total Volumn, ASK price and size, Bid ask and size. SO you can have all these columns and get them into ami as well.

Now here is a step by step guide for what to do.
First decide code letters for each data point. eg P for price (ie LTP) and V for volume (ie LTQ). If you wanna import ask, bid data as well just assign them letters as well.
Now select the column LTP by clicking on header, right click and click insert. This will insert the whole column to the left side of the selected column.
Now type '_P' in first cell of this new column. Drag the cell till the end of the ticker list so as to duplicate _Pin whole column.
Now here I am assuming that the ticker column and this LTP column were side by side before you inserted this new column with _P in between them.
So earlier you excel sheet had - [ticker],[LTP],[LTQ]
But now it is - [ticker],[newly inserted '_P' column],[LTP],[LTQ]
If not then open another excel sheet and copy past the ticker list in its first column followed by _P column to its right. Now you must have tticker column and _P columns side by side. Just copy the two columns and paste in notepad.
In notepad use replace function to get replace all tabs. Now SBIN _P will be SBIN_P.
Copy the contents from notepad and paste in that earlier inserted column in first sheet. This will replace all _Ps with {ticker}_P.
So now - [ticker],[ticker_P],[LTP],[LTQ]

Now select two columns [ticker_P],[LTP] and go to formulas tab in ribbon. there in 'defined name' there is 'Create from selection' option. click and you get a window. tick only 'left column'.
Now I will put up a video for above process.


So does this work with 'snap to excel' feature with TradeTiger ?
 
#18
Your presentation was nice but, its failure. I followed your process, it didn't work.
My configuration is, Win7 32 Bit, MSOffice proffessional Plus 2016, Amibroker 6.0.0, broker =Fyers, Zerodha Pi.
But, Finally, I got the success on my Windows 2012 Server with Excel 2013 and fyer. Very easily.
 

McNish

Active Member
#19
Very Nice try my friend. Great Stuff!
I tried the method and succedded in that i was able to create the database, plugin, and Excel as well.

The Limitations are with Futures Data symbol convention, continues futures contract and Backfill. For the nifty 50 stock list, neither Yahoo nor Google was able to do the back fill as the error was "Server name or Address not resolved"

You have any workaround to these issues?
 

McNish

Active Member
#20
Hey, if finally got the plugin status to show as "Connected". But alas, a few minutes after market closed, as i was doing some error in the process and after a couple of attempts it was successful.

But my concerns still remain.
I was only able to get the cash segment mw. How about Backfill for the same?
And how do i connect the Futures MW cause the Ticker name for Cash and Future segment is the same?

The limitation with the Josh1 system is the limited # of scripts.
Same is the limitation for other data feeds even from the authorised vendors. One of them is able to provide for 200 scripts but the data updation into Ami is very delayed, say more than 1/2 minute.

Let me know of any workarounds for this.
Once again, a thumbs up for your attempt and for me too, LOL!

Cheers,
 

Similar threads