Hello Forum,
I have a spread sheet which i use for Option trading profit and loss live, And i want to find the average of Profit and loss value which will go - to +.Cell -O12
Hello Forum,
I have a spread sheet which i use for Option trading profit and loss live, And i want to find the average of Profit and loss value which will go - to +.Cell -O12
And do you expect us to respond without a spreadsheet?
See yellow banner at top of page on how to attach a workbook. Please ensure you add manually calculated results
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
As John says a workbook is vital.
One other comment. Since the cell is changing you will need a macro to copy the cell and add it to a list of the previous values and average the list.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I could attach a spreadsheet not a problem but that data is streaming live from my trading terminal. I don't think it will be any use full. i assume.
For example i attached a spreadsheet which download data from web for BITCOIN. Please find M2 (P&L) .for my request .( i hope the data stream for you too)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks