EastMoney USDCNY Reference Rate Data Interface

June 15, 2016
The forex data of Sina Stock Data is realtime trading data, but USDCNY reference rate is widely used in LOF, so the SZ162411 Net Value calculation may have 0.1 cent of difference compared with final official data. As the difference is so small, and I also believe the trading price will move to reference rate during the day, I was not changing it. After all, I will not trade based 0.1 cent any way.
Since this year, the manager of SZ160216 works very hard to keep its net value moves almost the same as USO, and triggered huge amount of arbitrage between SZ160216 and CL future. One of them, zzzzv, is trading for 0.05 cent profit now, so the use of USDCNY reference rate is necessary. Based on his long term experience, he also confirmed me that the trading price will not move to the USDCNY reference rate. He also provided the USDCNY reference rate interface from Easy Money USDCNY, which was used in his Excel+VBA tools.
Document first, then to implement my ForexReference class. The data as following:
var js={futures:["USDCNY0,USDCNY,美元人民币,6.5842,6.5835,6.5966,6.5966,6.5804,0,1, 0.0000,0,0,6.5842,0.0000,0,0,0.0124,0.19%,0.0000, 0,0,0,0,0,0.0024,0.0000,2016-06-14 23:45:00,3"]}
After removed double quotation marks, separated by ',', the interpretation of words in the next table.

Index Original Data Meaning
0 USDCNY0 Interface symbol
2 美元人民币 Chinese name
3 6.5842 Previous close?
4 6.5835 Open
5 6.5966 Current price
6 6.5966 Today high
7 6.5804 Today low
8-12 0,1,0.0000,0,0 (Unknown)
13 6.5842 Previous close?
14-16 0.0000,0,0 (Unknown)
17 0.0124 Change
18 0.19% Change percentage
19-26 0.0000,0,0,0,0,0,0.0024,0.0000 (Unknown)
27 2016-06-14 23:45:00 Date and time
28 3 (Unknown)


June 16, 2016
The auto calibration last night used data from East Money, but today's SZ162411 net value still has small difference compared with offical data. Continue to get advise from zzzzv, I found that the USDCNY data from East Money is actually the same USDCNY data from Sian, they are both trading data. To get USDCNY reference rate from East Money, symbol USCNY is needed. Data saved in uscny.txt.

No comments for this page yet.

More options? Please login or register account.