Look at Paper Trading performance in backtest?
Author: djmundus
Creation Date: 6/20/2018 9:34 PM
profile picture

djmundus

#1
Is there a way to look at the historical performance of a paper trading account like I can look at the performance of a strategy backtest?

If not, is there a way to export a daily view of the account equity, open positions, etc.?

Is there any way to configure a paper account for margin trading?
profile picture

Eugene

#2
Monitoring WL strategy Real time
Code to read from TradeHistory.xml ?
Add trades to Account manually

To save your time, all these topics point to the same solution: Import real (historical) trades. Install the MS123 Performance Visualizers library and restart WLP (if it's not already installed). You're interested in paragraph "Import the history of real trades from Wealth-Lab's Accounts tool" (only it applies to your case). In the code example the respective line is this:

CODE:
Please log in to see this code.
profile picture

KGo

#3
Eugene,
1. Note that TradeFile shares, account number, Strategy ID, and scale are not exported to ExportedTradeHistoryFromAccounts.csv with the other trade data. A csv with all included would be helpful as so only the desired trades could be easily modeled

2. If possible an option to get American date format in the csv file (m/d/yyyy hh:mm:ss or similar) would be good. I run this data thru "Historical Trades: splits, cash flow, multiple files, shared equity" using an Excel reformatted csv today. It allows all time stamps to process on daily bars.

A separate csv creator with those two extra capabilities would also work.
profile picture

Eugene

#4
Kevin,

Correct. The objective is to create a SimTradeFile2-compatible CSV file to be parsed by the internal routine. The Scale does get exported but as StrategyID may be empty it's not considered.

Thanks for pointing me at the omission of Shares. Although it's an optional field, I'm going to add support for it. This should prevent from liquidating entire position in a symbol which takes place now. Likewise, you're making a good point re: filtering by Account. An optional parameter to ImportHistoricalTrades() will add such capability for TradeFileImportMode.AccountsFile.

As to the custom date format, I'm not sure why it might be needed. Couldn't HistoricalTrades detect and support "dd-MM-yyyy HH:mm:ss" or whatever is there in the resulting CSV? Just keep in mind that a timestamp with "00:00:00" indicates EOD data (see comment in the CreateCsvFileFromAccountsXml() code).
profile picture

KGo

#5
Please see Post #11 for my suggested method to process the TradeHistory.xml data.
https://www.wealth-lab.com/Forum/Posts/Historical-Trades-splits-cash-flow-multiple-files-shared-equity-39101

QUOTE:
This should prevent from liquidating entire position in a symbol which takes place now.

Adding shares will enable share entry but will not prevent liquidating the entire position. Only Historical Trades does splits.

ImportHistoricalTrades reads the date by requiring the the matching format string. Some users wishing to edit the csv file to include only certain trades will find it difficult - that's what I needed to do. A typical date in ExportHistoricalTrades.csv is "07-01-2015 12:00:42" which in US culture is read as July, 1 when it is really Jan, 7. If the csv is opened in Excel it sees that wrong date via local culture and dates with day > 12 are considered text. Historical Trades uses local system culture so like Excel it cannot read it. I used format "G" in the code linked above with an option to provide a user preferred format.

Shares, account, scale and strategy are all usable in the Historical Trades link above. In addition position splits and stock splits are automatic. Editable ImportHistoricalTrades data can also be created.
profile picture

Eugene

#6
QUOTE:
A typical date in ExportHistoricalTrades.csv is "07-01-2015 12:00:42" which in US culture is read as July, 1 when it is really Jan, 7. If the csv is opened in Excel it sees that wrong date via local culture and dates with day > 12 are considered text.

Makes sense. With an optional parameter to ImportHistoricalTrades(), starting from in v2018.07 you'll be able to output to ExportHistoricalTrades.csv using an arbitrary DateTime format.
profile picture

KGo

#7
Thanks, Eugene.
profile picture

Eugene

#8
@KGo

As requested, support for reading the Share property and filtering by AccountName when importing Wealth-Lab's Accounts tool history has been added to C.Components 2018.07. On method syntax please check out the revamped documentation which I hope should read more clear now:

Import real (historical) trades
profile picture

KGo

#9
Thanks again, Eugene. I continue to use Historical Trades (post #5 above) as it provides shares, trade selection by Account, Scale and strategy combinations.Plus one entry can be sold in multiple lots and price series splits require no manual price adjustment.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).