Home › Forums › Logical Invest Forum › QT Backtested Investments
- This topic has 4 replies, 4 voices, and was last updated 3 years, 9 months ago by hiker360.
- AuthorPosts
- 12/28/2020 at 8:13 am #80917hiker360Participant
In QT is there there any way to get the historical allocations of the actual investments? When using meta-strategies, the only way to see the actual investments of the sub strategies is on the Consolidate Allocations dialog. But that is only for the current month. I’d like to run some tactical trading scenarios over the actual backtested allocations.
12/28/2020 at 2:31 pm #80923Frank1 GrossmannKeymasterIn QuantTrader you can open the „ranking log“ page on the left side to see all historical allocations
12/28/2020 at 2:42 pm #80924Mark VincentParticipantThere is no easy way but you could run each of the strategies at the lowest level then look at the performance log. You can download the performance log to .csv and open in Excel. You can do this for all the strategies then paste them into one spreadsheet. It would be a lot of cutting and pasting. You would have to calculate the allocations manually. Possible but time consuming. You could automate a lot of the work if you used your own database and setup your own reference tables. This would be nice feature to have automate in QT.
Cheers,
MV12/29/2020 at 7:16 am #80929Alex @ Logical InvestKeymasterActually we have that data in our API. One of our best-kept secrets, but probably this is something we need to release and document for our “power users”. And hey, maybe a bit of “LI XMas feeling” is good in these times:
If you’re logged in and paste this into your browser this should work:
https://logical-invest.com/app/api/GetDailyData.php?symbol=BRS&dataType=consolidated&fromDate=2018-07-01
https://logical-invest.com/app/api/GetDailyData.php?symbol=BRS&dataType=returns&fromDate=2018-07-01And “all in one”, albeit in json format, which is not so easy to digest in Excel:
https://logical-invest.com/app/api/GetAssetChartData.php?symbol=Aggressive
12/29/2020 at 8:05 am #80930hiker360ParticipantGood to know on the LI strategies. In QT, I found the historical data in the, drum roll please, data folder already in a csv format – strategies prefixed with a “#”. It seems all I will need to do is recursively build the allocations by reading each of a meta-strategies strategies until I get to the actual symbols.
- AuthorPosts
- You must be logged in to reply to this topic.