ODIN to Excel to AmiBroker, FCharts with backfill

#12
Thanks for the great utility! I am able to get data from odin to amib realtime but please help me in updating one minute data I saved from trade tiger in DDMMYYYY, HHMMSS, OHLC VOLUME format which I am unable to get updated into this data, for continuity.
 

josh1

Well-Known Member
#13
Thanks for the great utility! I am able to get data from odin to amib realtime but please help me in updating one minute data I saved from trade tiger in DDMMYYYY, HHMMSS, OHLC VOLUME format which I am unable to get updated into this data, for continuity.
Export data to text files. Then use Amibroker's import wizard to import it into any database.
 
#14
I m using TradeRacer frm ICICIdirect. it gives rt data in excel bt nt sure which type it is (nest. odin etc). bt by column structure, it seems like odin. here r snaps,
.
TradeRacerEQ.jpg .
Arbitrage.jpg
.

as market is clsd nw, sheets r clr n cant verify its working. (first tab Market Watch ODIN-RT is named by me as just a watch name, its not TradeRacer function)
> whn I opn rtodin.xlsm, it shows err fr diet tht source is missing, do I need this "diet" thing ?
> I linkd Arbitrage.xls to rtodin.xls also n it seems ok

.
RTOdin.JPG
.

.
wht do u feel, is this ok (due to market clsd, thr r no data yet in AB folder)?
does traderacer data look like odin ? :confused:
 
Last edited:

josh1

Well-Known Member
#15
I m using TradeRacer frm ICICIdirect. it gives rt data in excel bt nt sure which type it is (nest. odin etc). bt by column structure, it seems like odin. here r snaps,
.
View attachment 20549 .
View attachment 20550
.

as market is clsd nw, sheets r clr n cant verify its working. (first tab Market Watch ODIN-RT is named by me as just a watch name, its not TradeRacer function)
> whn I opn rtodin.xlsm, it shows err fr diet tht source is missing, do I need this "diet" thing ?
> I linkd Arbitrage.xls to rtodin.xls also n it seems ok

.
View attachment 20551
.

.
wht do u feel, is this ok (due to market clsd, thr r no data yet in AB folder)?
does traderacer data look like odin ? :confused:
If TradeRacer gives live prices in Excel, link them to the columns in RT-ODIN.xlsm. You will get live prices in RT-Odin. Thereafter, you have click on Start RTData. You will get those prices in Amibroker.

You do not need Arbitrage.xls. Save the excel file created by TradeRacer with whatever name it suggests so that it opens the same file next day so that you don't have to do the linking every day.
 
#16
thnx josh1.
i hope it wil wrk, wil c tmoro. btw, i undrstand as arbitrage.xls is nt reqd i dont need to worry abt diet, bt cn u explain wht is it ?

jst fr info, TradeRacer opens xls by two ways :

1) by right-clk in TradeRacer watch and choose "Open in Ms-Excel"
this opns trading sht wth bit bulky col layout, it also hav two col with BUY/SELL lnk with ech scrip rows whch u cn clk n directly go to TradeRacer BUY/SELL dlog bx

2) by selecting any scrip in watch n COPY then PASTE in any xls sht
this wil jst opn RT data in tht xls sht without BUY/SELL link, it hav clean layout too

RC
 

josh1

Well-Known Member
#17
thnx josh1.
i hope it wil wrk, wil c tmoro. btw, i undrstand as arbitrage.xls is nt reqd i dont need to worry abt diet, bt cn u explain wht is it ?

jst fr info, TradeRacer opens xls by two ways :

1) by right-clk in TradeRacer watch and choose "Open in Ms-Excel"
this opns trading sht wth bit bulky col layout, it also hav two col with BUY/SELL lnk with ech scrip rows whch u cn clk n directly go to TradeRacer BUY/SELL dlog bx

2) by selecting any scrip in watch n COPY then PASTE in any xls sht
this wil jst opn RT data in tht xls sht without BUY/SELL link, it hav clean layout too

RC
In that case, you can use method 2. It is creating link in both sheets.
Copy appripriate columns from there to appropriate column in RT-Odin and you should get live prices there. Thereafter, you have to click on StartRTData.

But copy paste every day is tedious. If it opens same sheet each time you can have permanent link.
 
#18
it opns SHEET1 evrytime bt file wil b new n name it doesnt care, like if i hav opnd 4 empty shts recently in excel thn excel will opn new file as book5 only. still in sheet1 i get Traderacer data.

also, TradeRacer allows only single watch to b opnd in excel, if i opn othr watch thn it doesnt opn n the prev one stops data updt, seems like intrfc-bug.

i m nt yt sure abt daily copy-pst, need to chk (btw i jst need to copy any single scrip frm watch, n paste in excel opns all scrips frm tht watch). its still gd if i cn rcv data (til i switch to othr brokerage...!)

RC
 
Last edited:
#19
josh1, methd2 sht only lists scrips of watch, nt updt. so its fail.

methd1 data i lnkd to rtodin.xls n clkd StartRTData, data is updtd bt AB dont show chart. chking problems. excel running as Admin.

one thing i frgot to tell u, i m in MidleEast presently. hav adjsted exch time in rtodin.xls as per local time, hope is ok.

also AB IntradaySettings are ShowDaySession, FiltrWeekend, ExchTime local ME time, time-compr ExchTime, mixedEOD signals n othr check bx also markd. i hope all this ok.
 

josh1

Well-Known Member
#20
josh1,
methd1 data i lnkd to rtodin.xls n clkd StartRTData, data is updtd bt AB dont show chart. chking problems. excel running as Admin.
Did you copy format files to Your\Amibroker\Formats folder?
Go thru troubleshooting in Setup instructions.