QT Backtested Investments

[hiker360]

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.

[Frank1 Grossmann]

In QuantTrader you can open the „ranking log“ page on the left side to see all historical allocations

[Mark Vincent]

There 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,
MV

[Alex @ Logical Invest]

Actually 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-01

And “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

[hiker360]

Good 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.

[Author]

Posts