The SASEQUAN Interface Engine

Example 43.1 Retrieving Historical Price Data for Oil India Limited

This example shows how to use one Quandl code, NSE/OIL, to retrieve historical prices for Oil India Limited, starting September 1, 2013, and ending November 5, 2013, with a daily frequency. The output is shown in Output 43.1.1.


options validvarname=any;

title 'Historical Prices for Oil India Limited';
libname _all_ clear;
libname mylib "U:\quan950\doc\";

libname myQoil sasequan "%sysget(QUANDL)"
   apikey='XXXXXXXXXXXXXXXXXXXX'
   idlist='NSE/OIL'
   format=XML
   outXml=oil
   automap=replace
   mapref=MyMap
   xmlmap="%sysget(QUANDL)oil.map"
   start='2013-09-01'
   end='2013-11-05'
   freq='daily'
   collapse='daily'
   ;

data mylib.oilall;
   set myQoil.oil;
run;
proc contents data=mylib.oilall; run;
proc print data=mylib.oilall; run;

Output 43.1.1: Historical Prices for Oil India Limited

Historical Prices for Oil India Limited

Obs date Open High Low Last Close Total Trade
Quantity
Turnover (Lacs)
1 2013-09-02 435.95 441.65 427.20 431.00 431.45 174437 755.45
2 2013-09-03 439.90 439.90 427.00 428.50 429.05 199749 860.41
3 2013-09-04 435.00 435.00 426.15 429.50 429.45 790295 3396.42
4 2013-09-05 430.00 439.95 430.00 435.00 432.60 586678 2539.29
5 2013-09-06 437.00 450.00 433.30 445.25 445.15 543652 2402.79
6 2013-09-10 450.00 465.00 446.10 462.10 460.65 663553 2997.61
7 2013-09-11 462.00 485.00 461.00 466.00 466.70 371647 1733.05
8 2013-09-12 458.05 466.00 446.10 448.70 448.10 211533 959.45
9 2013-09-13 452.50 484.00 448.15 471.05 470.25 826546 3884.01
10 2013-09-16 483.70 484.00 458.80 476.00 467.00 335598 1593.84
11 2013-09-17 467.00 479.20 460.35 473.00 475.55 241830 1148.25
12 2013-09-18 471.20 481.85 471.20 480.00 479.70 182343 868.29
13 2013-09-19 485.00 499.00 476.00 491.10 493.75 457626 2236.70
14 2013-09-20 493.00 493.00 459.00 472.15 466.50 295333 1393.19
15 2013-09-23 466.75 487.00 464.00 480.00 480.40 273803 1302.58
16 2013-09-24 481.90 481.90 464.10 466.00 465.80 314456 1486.22
17 2013-09-25 467.90 473.30 466.10 470.15 470.35 738597 3472.11
18 2013-09-26 471.00 473.70 447.30 453.00 451.95 537088 2434.72
19 2013-09-27 456.70 462.00 450.10 452.00 454.30 345246 1571.16
20 2013-09-30 449.70 457.80 435.00 435.25 437.40 394564 1742.00
21 2013-10-01 437.15 449.35 432.00 449.00 447.90 308033 1367.86
22 2013-10-03 448.00 461.00 444.15 457.10 458.90 197974 898.93
23 2013-10-04 456.95 464.00 455.55 461.50 461.10 227214 1047.43
24 2013-10-07 464.90 471.45 450.00 468.00 464.40 240571 1098.48
25 2013-10-08 467.00 471.65 461.00 463.00 462.25 208627 964.45
26 2013-10-09 462.00 465.80 456.75 465.50 465.10 101852 472.35
27 2013-10-10 465.10 468.50 459.20 460.30 462.25 339738 1578.62
28 2013-10-11 465.00 468.70 457.00 467.50 463.25 213591 983.10
29 2013-10-14 464.65 467.90 461.00 464.10 463.95 125129 580.40
30 2013-10-15 464.00 471.80 456.55 459.30 460.55 407231 1877.01
31 2013-10-17 460.50 465.00 452.50 453.20 454.40 220366 1009.36
32 2013-10-18 457.00 465.95 457.00 465.00 464.55 185891 857.04
33 2013-10-21 465.00 471.90 458.70 468.00 468.85 114130 531.62
34 2013-10-22 468.85 473.20 461.15 465.70 466.65 198435 924.12
35 2013-10-23 463.05 469.50 451.40 456.00 457.65 469852 2152.30
36 2013-10-24 458.00 462.95 452.00 452.00 453.40 246085 1126.66
37 2013-10-25 458.00 460.05 450.00 454.00 454.65 272926 1238.47
38 2013-10-28 455.00 459.70 445.10 457.00 454.10 173547 785.17
39 2013-10-29 457.00 469.30 451.50 464.00 459.95 258106 1179.18
40 2013-10-30 460.20 467.80 453.95 463.50 463.25 301971 1391.67
41 2013-10-31 463.00 481.00 456.00 473.00 473.85 472301 2221.88
42 2013-11-01 470.10 481.00 464.50 480.00 475.05 318091 1495.83
43 2013-11-03 479.00 482.20 475.25 476.00 477.70 34250 163.85
44 2013-11-05 475.05 476.90 465.10 467.05 469.35 190319 894.87