I am new to the forum, and hope I am placing my question in the right area.
Please bear with me ... I am not a programmer, and must teach myself in small steps. I never mean to be critical. So please be patient, and do not assume I know something. I do try to check on resources first before asking. Amibroker is great in so many ways.........., AND THANK YOU TO ANYONE WHO MAY HELP!!!
I run the latest version 6.28 professional 64 bit (build 02.17.18) using DTNIQ on windows 8.1
I run 14 CENT custom range bars based on ticks for the leveraged ETF : TQQQ.
My database settings are : Local data storage : Enable AND Base Time Interval : Tick
I had a large database of tick data going back several weeks to allow testing of a few trading ideas over a greater time period. TQQQ had a 3 for 1 split effective start of 05.24.18. I tried to update and split the data under the "Symbol" drop down. The "Split parameter box" immediately displayed a 05.21.18 date with a 1:5 split ratio. According to the TQQQ Split History profile site on Google, this has never happened. The only recent splits were in 01.12.2017 (2:1) and 05.24.2018 (3:1).
I don't understand where the spurious 05.21.18 date came from.
[ Facts based on attempt on 05.29.18 during market hours]. I changed the date and ratio to 05.24.18 and 3:1, respectively. Sometimes it would properly split some of the recent data immediately prior to 05.24.18, but at 05.18.18 and earlier would return "nonsense" quotations such as $0.67 or $0.68, etc. I am not sure if this is because DTNIQ limits real time tick during market hours to a short period. Basically, I kept "banging" at this trial and error with force backfeeds and setting stock split parameters again like I did above, until I finally got a correct display for everything at least after end of 05.18.18. That was the best I could get. I am not even sure about the limits on downloading ticks. DTNiq says 8 days, I believe.....but in my Quote Editor, I see "nonsense" quotes of $0.63 etc all the way back to 05.08.18. I am really confused.
Why does the split occur properly for some dates, but not others? Also, if I download tick history beyond these 8 days (say after market hours for use in my testing) , does it get "overwritten and deleted" when I restart Amibroker during market hours. If so, is there a way around this
As a completely separate point: if anyone has any sample code of converting an OSAKA sort to matrix sort, I would appreciate it. I have a Goertzel DSP algorithm I wrote that uses OSAKA to extract top number of frequencies at each bar, and would like to see if it runs faster with matrix and VarGet functions. I am willing to share Goertzel code... Thank you so much