I will show you a much more convenient way how to do this kind of comparison in QuantSense. We will need one account for storing your full trade history (it is more like a folder). Let us call this account simply 'Full history'. In QuantSense, go to Accounts screen a create a new empty account with this name. Then import your full trading history from Meta Trader 4 into this account if you have not done it previously.
Next, we will need two another accounts for storing the trades of particular periods. Let us call them '1. quarter 2014' and '1. quarter 2015'. Just create both accounts and leave them empty.
Go to Trades screen and select the 'Full history' account. A full list of trades will appear on the right side. Now activate the date filter and set the date interval to January 1st 2014 - March 31 2014. Click 'Update'. The list of trades will change such that only trades which were closed in this period will appear. Right under the list there is button 'Select/Unselect all'. Click it and all displayed trades will be selected. Now in the bottom menu (right click or swipe from the bottom to open it) there is a 'Copy' button. Click it and QuantSense will offer you the destination accounts. Select the '1.quarter 2014' account and click 'OK'. All the selected trades will be copied to the '1.Quarter 2014' account.
Here is a screenshot of copying trades from 'Full history' to '1. Quarter 2014'.
Got the point now? We repeat the process for the first quarter 2015.
Change the date filter to match the first quarter 2015, i.e. to January 1 2015 - March 31 2015. Click update, select all trades shown and copy them to the '1.Quarter 2015' account. That is all. We have our data prepared. And the best part is coming now.
Go to Reports screen, select both accounts '1.Quarter 2014' and '1.Quarter 2015'. In the bottom menu there is a 'Settings' button, click it. Set the report such that you activate 'Compare' mode. The rest of the settings are self explanatory. If you know that difference between the number of trades in both account is larger you might want to set 'Custom granularity for profit chart' on, let us say, 7 days period in order to 'align' the curves and better see the profits in corresponding time periods. This is how does the Report Settings screen look like with all options selected as described above:
Return back to the Reports screen and click 'Create report'. QuantSense will generate a nice report for you comparing the two selected accounts with statistics computed for every account separately. You get a few charts, a table with statistics and a list of trades for every selected account. Yes, it is that easy.
For a quick view here are two screenshots from the Report screen. The first one showing the chart comparing the profits in both quarters computed in 7 days granularity. Note that my 1. Quarter 2015 (the orange line) finished a bit early - I do not have enough trades in March 2015 but you get the point:
And when you scroll the report a bit lower you can see an easy to read table with all statistics computed for every account separately:
You can save the report to a folder of your choice. It can be opened by any browser. And you can upload it on your website as it is - all files from the report folder to a folder on your website. To see the full report uploaded on my website click the following link.
After you have finished you can delete accounts '1. Quarter 2014' and '1. Quarter 2015'. All your trades are still in 'Full history' account so you will not loose anything.
To complete this example you need to have some upgrades in QuantSense. You can buy them in QuantSense store right in the app. You need Unlimited accounts upgrade to be able to create more than two accounts and to be able to copy trades between accounts. And you need the Reports upgrade to be able to generate the report. Or simply buy a Premium and do not care about upgrades any more. In the time of writing this post it is still for a discounted price and it will stay there until I finish Market Context upgrade allowing you to do interesting analysis and optimizations in the context of market quotes data. Part of it is available for the Premium users right now for beta testing.
Thanks for reading.
Ľubo
Hi Lubo,
ReplyDeleteYour App is Super. I love it so much.
One suggestion from my side. Why Deposits and Withdrawals not getting shown in Common Stats. If it is available. I can see all the Stats at one place
Please note it and make available
Thank you very much for wonderful app for reasonable price.
I hope a lot of journey is there. All the best.
Regards,
Vamsi
Hi Vamsi,
ReplyDeleteyou are right, it seems I got a bug there. I will try to fix it in the next release. Thank you very much for help. Regards, Lubo.
Hi Vamsi,
ReplyDeleteI have submitted the version 1.6.2 to the store today. It should fix the bug you have found.
Thank you for helping me improve my app.
Lubo.