How to use Forex functions in MarketXLS
All currency functions in MarketXLS need a Source currency Symbol and the target currency symbol. Always, 1st symbol is the source and the second is the symbol.
In the FX_Convert function provide the value to convert first and then provide the source and the target currency symbols.
Current Ask Price of USD to GBP:
1
=Fx_Ask("USD","GBP")
Copied!
Current Bid Price of USD to GBP:
1
=Fx_Bid("USD","GBP")
Copied!
Convert 100 USD to GBP:
1
=Fx_Convert(100,"USD","GBP")
Copied!
Copy link