How to get RTD from ANY software to Amibroker - Free

msdtime

Active Member
#1
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.
 
Last edited:
#2
But bhai
using DDE plugin is not an easy way to do it.
If I remember correctly, there was a thread by rohitb, using this method. You may search and check that thread. But that was not easy to configure. I used that before Josh rtd utility.
This rtd problem occurs, because many new versions of NestPlus cropped up, missing one or the other important function and so we are facing this problem. Otherwise Josh RTD is the easiest and simplest way to get real time data.
 

LOVEENAJYOTHI

Well-Known Member
#4
@traderniftybull
Yes, josh is a legend. But my main concern is that the RTD should flow across platforms.
I have found a way to make this DDE shit a tad easy.
There r plenty of videos there, but the reason its not popular is it's inability to cope with high number of scrips, if ur MW scrips are limited to around 25 or less, wl perform well.
But anyways, that was my half hearted, half baked attempts talking, i really n desperately wish u to succeed.

Few things Noted while trying DDE:
1. In Excel, when copy/paste from a sheet wid hidden columns , it wl NOT ignore the hidden columns.
This is relevant when user tries to add his new scrip.

2. @josh1 has already developed an Excel Tool prior to RTD, u can find the Links in his Signature, works very well too, u can add any number of columns like bid ask etc, pretty fast too. Gotta keep Exel sheet open.

3. Then there is the BackFill issue , u wl need something similar to DataTable anyways.
Google/Amiquote givs data of only cash scrips.
All the Backfill solutions giv only 1mnt data.

4. If there is Anyway/Broker/Platform that provides "Tick data BakFill" + "write to Excel" , wl permanently move to DDE.

Glad that u r taking this initiative, wish u Success.
 
Last edited:

Krushna

Active Member
#7
Thanks for the video.
How to do the backfill?
You only mentioned use Amiquote to get backfill data from Google, but it would be better if you show how its done.
 

OneThatGotAway

Well-Known Member
#8
FOr first 5 min i was wondering wats dart then i figured it;s rksv new upstock software lol

instruction are good nice we technical user can do it . but what about normal user .
an easy method is required with back filling offcourse ..

wow i just saw video youtube msd has done very great job
shh fun fact that name appeared when he start ami is of mine lmao ......
time 11:38 lol

for some reason i think msd time is long lost brother of navin jain
hehe almost same attitude same voice pitch lol

It;s nice to see there is a forum memeber who has made video for welfare for all trader like us :xD
i am not alone aakal kar mara
 
Last edited:

Similar threads