One more question.(sorry for asking so many)
2.Do you have solution for backfilling from TT?
Hi Manst,
For Backfill in Trade Tiger I did the following & suggest you try the same.
1.Double Click on scrip name of your choice in market watch (say SBIN) that is streamed into AmiBroker > SBIN chart opens.
2.On the SBIN chart bottom right you will find 2 little boxes > click on the one below (with Z symbol) this will open a pop-up. In pop-up click on 0 & then on custom. Change the date to max or your choice & then click on plot. A tick chart has now been plotted.
3.Now on the SBIN chart - Right Click > Show > Data Listing. This will open a Data Window showing the tick data. Save this Scrip as CSV with file name SBIN to a location of your choice.
4. Open the saved SBIN CSV file. Now you have to sort the complete SBIN data from Old (top of page ) to latest (bottom of page). To do this Click on Column A (this is the date column that you are selecting) then go and click on Sort & Filter > Sort Oldest to Newest (i.e A to Z). In the Pop-Up box select Expand the Selection > Sort. The complete data in all columns of the excel is now sorted chronologically.
5. Now again select Date column A in order to change date format to DD/MM/YYYY. To do this follow this short cut. After selecting Date Column A use keys Alt O > E (Pop-Up box opens). Under number tab select Date > in Type Box select 14/03/2001 & click OK. Date format has changed.
6. Next we need the following titles to feature in 1st Row of excel for the data listing
Ticker | Date | Time | Open | High | Low | Close | Volume|
And they should be as- Column A | Col B| Col C| Col D| Col E| Col F| Col G| Col H| -respectively.
So, insert a new column in place of Column A and type/add Ticker and then SBIN for the entire column (i.e from top to bottom of available data only).
Save this (it should be saved as same file ie SBIN .CSV) and close.
7. Next in AmiBroker > File > Import Wizard (pop-up box -opens) > Pick Files > (select SBIN) > Next > Define Fields.
In define fields 1st Check - Box - more columns then select the respective fields to match the fields in the saved SBIN excel file and for rest of the blank columns select Skip. (Note the date field in column 2 of AmbiBroker should be DMY to match excel date format).
Then, Click next > Finish. A error box may open - ignore this & close. Check your data in AmiBroker by Changing interval to tick & in Minutes of your choice. If you find new data your done.
Note: a). While trying the other Backfill method using NOWBackfill for TTiger I failed & hence tried this method. If you or anybody else finds a simple & or better method may kindly share.
b). Please try a couple or more times if you do not succeed on first attempt.
If you still dont pls post your issue.
Best Wishes
:thumb: