DwMcQueen,
Have you looked at using the DDE function of Excel which allows you to import external data from another program (say Metatrader) into the spreadsheet on a dynamic basis second by second, which you can then link to another cell to calculate the swap rate for each pair you wish to know?
This will give you an ongoing swap rate for each and every pair, and once you have the formula for one pair, it is just a matter of inputting the data feed in each line for each pair you want and then copying and pasting the formula in the next cell to give you your answer.
If you don't know how to do it, perhaps someone reading this can post a template for you. I have not had the opportunity to explore this aspect of Excel yet.
Cheers
Frank.
DwMcQueen,
Have you looked at using the DDE function of Excel which allows you to import external data from another program (say Metatrader) into the spreadsheet on a dynamic basis second by second, which you can then link to another cell to calculate the swap rate for each pair you wish to know?
This will give you an ongoing swap rate for each and every pair, and once you have the formula for one pair, it is just a matter of inputting the data feed in each line for each pair you want and then copying and pasting the formula in the next cell to give you your answer.
If you don't know how to do it, perhaps someone reading this can post a template for you. I have not had the opportunity to explore this aspect of Excel yet.
Cheers
Frank.
Ignored
You are right Frank as I am using excel for calculating the SWP rates through excel. It's results are fine with 3-5 percent of error which is manual. If anyone want to use excel to calculate then I think it is good option.
You are right Frank as I am using excel for calculating the SWP rates through excel. It's results are fine with 3-5 percent of error which is manual. If anyone want to use excel to calculate then I think it is good option.
Ignored
We can use excel for calculating but aren't there any special software or program to calculate swp rates. It is very tiring to calculate swp rates with the help of excel.
20Neo,
Thanks for the input. I knew there would be people doing it.
Harry20,
Can you clarify why it is tiresome. All i understand is once you have the data feed in a cell. you then punch in the formula for the swap calculation (which can be found on many sites) and then include the cells with the data feed into the formula as the cells for the input data, and the cell is the one doing all the work, second by second. Then why not extend it and have another column which then averages out the swap for a long period, say an hour, 4hrs, or even 24 hours. This way, the swap number stabilises over a longer time range.
Have you been down this track and found some obstacle that I have not understood yet? Help me out here? Because when I get the time I want to start playing with the DDE functions of Excel, and if this is a useless endeavour I want to know why now, before I begin.
Frank
