Tracking the Trades:
If one can code the strategy it will be easier to track, however since the strategy is run end of day, one can easily track the trades using excel sheet. Attached is a simple excel sheet I have created to help you track the trades. The content are as follows:
At the end of each day, one need to update the columns in green for new trades and if a trade is already in place, just update the current price to know the current P/L percentage in the last column highlighted in orange.
To make it simple to calculate the quantity of stocks one need to purchase based on the buy price value, he can use the following table, by entering the values in green cells.
If one can code the strategy it will be easier to track, however since the strategy is run end of day, one can easily track the trades using excel sheet. Attached is a simple excel sheet I have created to help you track the trades. The content are as follows:
At the end of each day, one need to update the columns in green for new trades and if a trade is already in place, just update the current price to know the current P/L percentage in the last column highlighted in orange.
To make it simple to calculate the quantity of stocks one need to purchase based on the buy price value, he can use the following table, by entering the values in green cells.
Attachments
-
50.3 KB Views: 50