Http Source

Community Support
1

Is there a way to pull the source text from a website directly into q?  

Havent seen it on the reference site.

Thanks

2 
as of 2016.05.12, version 3.4 added:.Q.hg, http get. e.g.


to get historical prices of FD plc:

q)("DFFFFJ";1#",") 0:3_.Q.hg `$":[http://www.google.com/finance/historical?q=LON%3AFDP&output=csv]("http://www.google.com/finance/historical?q=LON%3AFDP&output=csv")"
Date Open High Low Close Volume
----------------------------------------------
2016.11.25 2123 2123 2100 2103 21
2016.11.24 2114.6 2114.6 2113.8 2113.8 0
2016.11.23 2125 2125 2106.75 2124 156
2016.11.22 2125 2125 2100 2125 193
2016.11.21 2124 2125 2100 2124 3089
..
3

Perfect, that helps thanks Nick

4

Hi Nick,

trying to get data from website to q ,but not successful.

for example, using below :

("DFFFFJ";1#",") 0:3_.Q.hg `$":[http://www.google.com/<wbr>finance/historical?q=LON%<wbr>3AFDP&amp;output=csv</wbr></wbr>]("http://www.google.com/finance/historical?q=LON%3AFDP&output=csv")"



gives '.Q.hg output on console.



any help will be appreciated.



Thanks

Neetha
5

On Friday, June 9, 2017 at 11:56:04 AM UTC+2, Neetha wrote:

Hi Nick,

trying to get data from website to q ,but not successful.

for example, using below :

(“DFFFFJ”;1#“,”) 0:3_.Q.hg `$“:http://www.google.com/finance/historical?q=LON%3AFDP&output=csv”

gives '.Q.hg output on console.

any help will be appreciated.

Thanks

Neetha

Hi, you are probably using an older kdb version. You can download the newest version from kx.com

Markus

6

Hi guys, 

Is there any way I could come to a website like this: https://www.instituteforsupplymanagement.org/ismreport/mfgrob.cfm?SSO=1 and pull out first 5 rows from the “MANUFACTURING AT A GLANCE” table on that website? 

Or from  WallStreet Journal website 

Regards, VA

7

Hi Marcus,

Thanks for immediate response, you’re right, mine is older version 3.3 and upgraded to version 3.5 just now and 

got below display and output.

[root@oracle ~]# q -p 5000

KDB+ 3.5 2017.05.02 Copyright (C) 1993-2017 Kx Systems

l32/ 1()core 1010MB root oracle 127.0.0.1 NONEXPIRE  

Welcome to kdb+ 32bit edition

q)(“DFFFFJ”;1#“,”) 0:3_.Q.hg `$“:http://www.google.com/finance/historical?q=LON%3AFDP&output=csv”

Date       Open High    Low     Close   Volume

2017.06.08 3124 3130.24 2932.23 3044    9541  

2017.06.07 3100 3150    3076    3082    8051  

2017.06.06 3156 3200    2878    3125    2766  

2017.06.05 3124 3135    3100    3101    2970  

2017.06.02 3127 3135    3100    3102    585   

2017.06.01 3149 3149    3100    3100    6347  

2017.05.31 3160 3175.5  3101    3103    792   

2017.05.30 3050 3180    3024.4  3135    4643  

2017.05.26 3050 3123    3029.5  3123    4757  

2017.05.25 2996 3017    2953    3000    7901  

2017.05.24 2990 3049    2961.8  3002    3274  

2017.05.23 2810 2983.3  2810    2949.37 20170 

2017.05.22 2724 2802    2701    2802    3412  

2017.05.19 2555 2700    2535    2597.63 15742 

2017.05.18 2510 2543.25 2485    2522    1710  

2017.05.17 2550 2550    2490    2490    5302  

2017.05.16 2560 2570.3  2540    2540    6554  

2017.05.15 2502 2560    2502    2560    2455  

2017.05.12 2560 2560    2501    2559    682   

2017.05.11 2571 2600    2550    2569    2768  

..

q)

Thanks a lot.

Regards

Neetha