I need help with some scripting so I can updating my current spreadsheet so it calculates my total profit/loss in pips and dollar amounts.
I'm stuck on calculating pips from a single trade. In column K, I want the total pips calculated from the Price and Close blocks to be displayed as whole numbers; red number for a loss, black for a win.
I'm also stuck on calculating the initial risk involved in dollars. In column L, I want the initial risk calculated from Price and Stop to be displayed as dollar amounts based on lot size.
Any help is appreciated.
I'm stuck on calculating pips from a single trade. In column K, I want the total pips calculated from the Price and Close blocks to be displayed as whole numbers; red number for a loss, black for a win.
I'm also stuck on calculating the initial risk involved in dollars. In column L, I want the initial risk calculated from Price and Stop to be displayed as dollar amounts based on lot size.
Any help is appreciated.
Attached File(s)
Forex Journal Template.zip
14 KB
|
223 downloads
|
Uploaded Feb 23, 2012 7:08pm