Example: I have tick data for AUDUSD and also for USDCAD I would like to create a new CSV file based upon this data for AUDCAD.
I want to be able to this for a lot more currency crosses.
AUDUSD & GBPUSD creates GBPAUD
AUDUSD & EURUSD creates EURAUD
USDCAD & GBPUSD creates GBPCAD
USDCHF & USDCAD creates CADCHF
USDCAD & EURUSD creates EURCAD
AUDUSD & NZDUSD creates AUDNZD
What all calculations have in common is the fact that the USD is the common currency.
More details available upon request.
The CSV files are large 4-5 GB each, they exceed the excel maximum lines.
13 freelance font une offre moyenne de $172 pour ce travail
Hello, Excel VBA expert here. I've done similar project. Please check PM for details. Thanks!
Hi! It is very simple task for one sql query for each AUDUSD & GBPUSD creates GBPAUD ant etc. Regards.