Trade Analytics Report - Interest Tie Back To Trades in Excel
Joined 01/06/23 20:51
Look ahead to 2/6/23: US jobs; Baker Hughes rig count After the stronger than expected private payrolls number from ADP, risks would seem to be on the upside for the US non-farm jobs number on Friday. Jeremy Naylor | Analyst, London | Publication date: Thursday 01 June 2023 IGTV’s Jeremy Naylor looks at USD/JPY as a potential trade. Outside of this watch Brent around the Baker Hughes rig count.
What's the next move following the bank run that led to a rally in US stocks? The markets have been giving us hints on its coming trend, which markets are they? Deploying market psychology not only helps us to connect the dots in today’s complexity, it also gives us the simplicity to chart into the future. In this session, we have invited market veteran, Wong Kon How, to help you improve your trading literacy and successfully navigate the financial markets. Kon How will demonstrate how he understands today’s market complexity and seizes the coming opportunity with behavioral science.
Charting the Markets: 1 June Dow and CAC40 stabilise while Nasdaq 100 edges down. EUR/USD, EUR/GBP and USD/CAD stabilise as US debt ceiling bill goes to Senate. And Brent, orange juice stabilise while copper advances as US debt ceiling bill gets signed. Shaun Murison | Senior Market Analyst, Johannesburg | Publication date: Thursday 01 June 2023 This is here for you to catch up but if you have any ideas on markets or events you want us to relay to the TV team we’re more than happy to.
I was wondering whether anyone can help/advise on how to apply the correct interest payments to a trade it is associated too when downloaded to Excel?
If you have multiple overnight or weekend trades open in various markets over a long period of time and interest is applied to them, the Reference field does not have enough information to help tie it to a trade it is associated too.
You have to manually create a field and enter your own reference which sometimes can be wrong especially if you haven't kept on top of it for a while.
Happy to clarify questions further if my question is not clear.
Thank you for any help/advice in advance.
Link to comment
0 answers to this question
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now