I am retrieving Corn chain, Naturalgas chain from below api via SOAP - http://www.reuters.com/ns/2006/05/01/webservices/rkd/Common_1
I am getting output in below format
[0#1C:] => Array
( [1CN9] => 3.88 [1CU9] => 3.9675 [1CZ9] => 4.06 [1CH0] => 4.165 [1CK0] => 4.21 [1CN0] => 4.25 [1CU0] => 4.105 [1CZ0] => 4.1225 [1CH1] => 4.21 [1CK1] => 4.26 [1CN1] => 4.3025 [1CU1] => 4.16 [1CZ1] => 4.17 [1CN2] => 4.3275 [1CZ2] => 4.21 )
Here [0#1C:] Corn chains future symbol
[1CN9] - 1CN represents for May month and 9 represents the difference in year from 2010. Current year 2019 so 2019-2010 so 9 Hence for 2020 we need to have data like 1CN10 but it is not present.
URL - http://www.reuters.com/ns/2006/05/01/webservices/rkd/Quotes_1/RetrieveItem_3