cancel
Showing results for 
Search instead for 
Did you mean: 

Http Source

hoffmanroni
New Contributor III
Is there a way to pull the source text from a website directly into q?  

Havent seen it on the reference site.

Thanks
6 REPLIES 6

Nick
New Contributor
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"
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
..

hoffmanroni
New Contributor III
Perfect, that helps thanks Nick

neethakdb
New Contributor
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



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

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

VA
New Contributor
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