Thread: FOREX Trading - Calculating Today's Profit

Hello,

I am making a spreadsheet in order to keep track of my FOREX Trading Data.
I am relatively new to excel, and made my spreadsheet from various youtube tutorial videos.

I use this spreadsheet to input new data everyday.
I found a VBA script that creates a timetamp in the column just to the right of my data.

I am currently trying to a make a field that would calculate the results of TODAY (Today's Profit).
I want this cell to reset everyday.

Im sure its a very simple task involving the =TODAY and =MATCH function, as well as a simple logic statement involving =IF , but I dont know how to go about it.

I have attached my spreadsheet to this thread (without macros), if anyone has the time to help me out, I would greatly appreciate it.

Alex