Firstly, I find this forum is really great. I reference it a lot and am usually able to find the solutions I'm looking for, but this is only my second post...looking for some help again.
I'm a novice excel user but looking to improve so I'm looking to do an exercise and would greatly appreciate it if anyone can provide me with some direction as to where I should start, ie. formatting the spreadsheet, tools that might be helpful, formulas or scripts I'm going to need to research...etc. Any guidance is appreciated. I'm not looking for someone to create this for me, but I'm at a loss as to where to even start and I don't want to do a whole bunch of work then realize I've done it all completely wrong.
So, I'm looking at creating a spreadsheet that will determine opportunities for arbitrage among trading pairs such as you would find on currency exchanges. ie, USD/EUR, GBP/USD, etc.
For now, I'll manually enter the data manually or copy/paste it to keep things as simple as possible. I'm thinking the data I enter will look something like this:
There could be many more pairs than this, up to maybe 20-30. Essentially, I want it to check opportunities for arbitrage. So for example, if trading x amount of AAA for BBB, then BBB for CCC, then CCC back to AAA will yield a profit, it would output that somehow for me. Ideally it would calculate this not only for 2 or 3 hops, but for any number of hops that could provide a profit.
How difficult is this? I've done a bit of scripting (vbscript) outside of excel, so I'm willing to go that route if it's required as well. I just need to know where to start and would like any advice I can get. Hopefully I've been pretty clear here.
Thanks!
I'm a novice excel user but looking to improve so I'm looking to do an exercise and would greatly appreciate it if anyone can provide me with some direction as to where I should start, ie. formatting the spreadsheet, tools that might be helpful, formulas or scripts I'm going to need to research...etc. Any guidance is appreciated. I'm not looking for someone to create this for me, but I'm at a loss as to where to even start and I don't want to do a whole bunch of work then realize I've done it all completely wrong.
So, I'm looking at creating a spreadsheet that will determine opportunities for arbitrage among trading pairs such as you would find on currency exchanges. ie, USD/EUR, GBP/USD, etc.
For now, I'll manually enter the data manually or copy/paste it to keep things as simple as possible. I'm thinking the data I enter will look something like this:
There could be many more pairs than this, up to maybe 20-30. Essentially, I want it to check opportunities for arbitrage. So for example, if trading x amount of AAA for BBB, then BBB for CCC, then CCC back to AAA will yield a profit, it would output that somehow for me. Ideally it would calculate this not only for 2 or 3 hops, but for any number of hops that could provide a profit.
How difficult is this? I've done a bit of scripting (vbscript) outside of excel, so I'm willing to go that route if it's required as well. I just need to know where to start and would like any advice I can get. Hopefully I've been pretty clear here.
Thanks!
