adivinorum
New Member
- Joined
- Nov 8, 2005
- Messages
- 2
Hello
I want to use excel for trading currencies. I am new to excel. The first 2 obvious questions are:
1. I receive streaming live data directly and constantly onto excel. is there any macro out there to help me to constantly record it?
2.
futures spot differential
1.0678 0.7405 0.3273
1.0714 0.7468 ...
1.0762 0.7464
1.0904 0.7454
1.0948 0.7444
...etc
I need to calculate the differential for each row. I have thousands of rows for futures and spot prices. Is there any formula to calculate all differentials in one single step?
Thank you very much
Oscar Lledo
I want to use excel for trading currencies. I am new to excel. The first 2 obvious questions are:
1. I receive streaming live data directly and constantly onto excel. is there any macro out there to help me to constantly record it?
2.
futures spot differential
1.0678 0.7405 0.3273
1.0714 0.7468 ...
1.0762 0.7464
1.0904 0.7454
1.0948 0.7444
...etc
I need to calculate the differential for each row. I have thousands of rows for futures and spot prices. Is there any formula to calculate all differentials in one single step?
Thank you very much
Oscar Lledo