Hello All,
I have a little problem here on keeping updates on my trading logs. I want to know how everyone else store their daily trade logs ??
I have been using an excel sheet to keep my trade logs, with columns as
Date, Contract, Trade Type, Entry Time, Entry Price, Lot Size, Exit Time, Exit Price etc..
The problem I am facing with this, lets say I entered NF with 2 lots at once. but exited 1 lot at target 1 and exited the second at target 2. So in this case shall I record the Exit Price as the average price between my two exits ?? Else if I am making a second entry in my table then the second one is missing the entry price. And in that case it will be counted as 2 trades for the day, where I have done a single trade. So I am real confused here.
I am thinking of making an excel - Access driven application to store them in Access DB, but that will need some time, and I want to keep it simple. So just want to know how others handle this ??
Regards
Taiki
I have a little problem here on keeping updates on my trading logs. I want to know how everyone else store their daily trade logs ??
I have been using an excel sheet to keep my trade logs, with columns as
Date, Contract, Trade Type, Entry Time, Entry Price, Lot Size, Exit Time, Exit Price etc..
The problem I am facing with this, lets say I entered NF with 2 lots at once. but exited 1 lot at target 1 and exited the second at target 2. So in this case shall I record the Exit Price as the average price between my two exits ?? Else if I am making a second entry in my table then the second one is missing the entry price. And in that case it will be counted as 2 trades for the day, where I have done a single trade. So I am real confused here.
I am thinking of making an excel - Access driven application to store them in Access DB, but that will need some time, and I want to keep it simple. So just want to know how others handle this ??
Regards
Taiki
Last edited: