Hi Guys,

Im noob to excel and vba and have a question.

Iv started currency trading, not the normal forex, but actual money transfers. Im after a template or macro that enables me to choose the best route to transfer money in between say 5-10 diffrent currencies that will enable a profit. for example say i buy 1000 usd using 1000 gbp which gives me 1530.10 usd then i transfer it into euro which gives me 1143.92 then transfer back into gbp which gives me 1000.66 gbp (a profit of 66p) i have the live exchange rates but need a tamplate to run the 5-10 currencies.

Any help and info would be great.


Thanks