Today we're going to show you how to use the Tradestream.in Journal to get insights into your own trading history. To get started, go to the Journal tab on the navigation bar.
When it loads for the first time, the P&L summary will be blank, since we don't have any data yet. If you have an account with Zerodha, you can import your trades instantly in just one click. Hit the Import Data button on the Dashboard to import today's trading history. If this is the first time you're logging in with Zerodha account on Tradestream.in, it will ask you for Read Permissions.
After you start importing the data everyday, you should see a summary similar to the one below-
Alternately, to upload a lot of trades in bulk, you can upload a CSV file- Tradebook from Zerodha backoffice Q. We are going to download the trade history, save it as CSV and upload it to the Journal. To import the tradebook, first head to the backoffice Q, and from the menu on the left, navigate to Tradebook.
Set the start and end dates, select the right segment- FO or CM, and hit the Download button. You should get an Excel file. Open the file in Excel,and go to Save As. Select format as CSV and hit the save button.
Once you have saved the downloaded Excel file in the CSV format, all thats left is to upload it. On Tradestreamin, select the Upload Tradebook button from the Journal Dashboard.
Select the saved CSV file, and hit Upload. If the file is large, it may take some time- a few minutes for it to process the data.
Upload the Tradebook only when there are no starting positions. Tradestream.in will process all the trades in your tradebook to calculate your positions and P&L. But if you have previously open positions from prior to the tradebook's start date, the loaded data will be incorrect. In that case, please use the Import Data and start from the present day.