Find Amount Traded (In Acc Currency) per symbol
Find Amount Traded (In Acc Currency) per symbol
28 Apr 2021, 08:33
Hello Spotware,
Is there a way to find total traded in Acc Currency per symbol?
Let's say my Account is USD
I buy 10k AUDUSD, which is approx 6k in USD traded.
Then I buy 10 of an index, i.e. JP225, that's approx 2700 USD
Let's say I have a combination of various other assets... this becomes a bit complex
What I have done is create a dictionary,
JP225 is quoted in USDJPY, so the formula would be => Quantity Traded * Current Asset Price / USDJPY Price
US500 is quoted in USD, so the formula would be => Quantity Traded * Current Asset Price
DAX is quoted in EURUSD, so the formula would be => Quantity Traded * Current Asset Price * EURUSD Price
So this goes for all assets, which might be too much, maybe I'm missing something, I can't find any property to check this info.
Would appreciate your help.
Regards,
PanagiotisCharalampous
28 Apr 2021, 08:49
Hi Waxy,
There is no built in feature for this. You would need to build something custom.
Best Regards,
Panagiotis
Join us on Telegram
@PanagiotisCharalampous