AliciaGoyanes
New Member
- Joined
- Sep 29, 2022
- Messages
- 19
- Office Version
- 2021
- Platform
- Windows
- MacOS
Hello, how are you?
I am trying to find the way to build a code where each day, by running the code, I have a table of my PNL consolidation.
In cells L9 and L10 I have my "realized" and "unrealized pnl". This changes daily once I get connected in the morning, so I want to find a way in which every night, before leaving or once market is closed, I run the code so that a table is filled with these numbers.
To put the example:
in U column, starting in U3, I have a list of days, so that each day in the night I want in W3, W4, W5 to plug the value of realized and unrealized.
Could you give me a hand please?
Thank you so much
I am trying to find the way to build a code where each day, by running the code, I have a table of my PNL consolidation.
In cells L9 and L10 I have my "realized" and "unrealized pnl". This changes daily once I get connected in the morning, so I want to find a way in which every night, before leaving or once market is closed, I run the code so that a table is filled with these numbers.
To put the example:
L9 = REALIZED PNL | M9= 50000 |
L10=UNREALIZED PNL | M10= 0 |
in U column, starting in U3, I have a list of days, so that each day in the night I want in W3, W4, W5 to plug the value of realized and unrealized.
Could you give me a hand please?
Thank you so much