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
Bookmarks