q/kdb+ api for getting market and financial data from IEX
Himanshu Gupta
Jack Andrews
--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
ag
q)t:.j.k .Q.hg`$"https://api.iextrading.com/1.0/stock/market/batch?symbols=aapl,googl,amzn,fb&types=quote,stats&filter=marketCap,peRatio,EBITDA"
q)
q)t
| quote stats
---- | -------------------------------------------------------------
AAPL | `marketCap`peRatio!8.983506e+11 19.88 (,`EBITDA)!,7.6569e+10
GOOGL| `marketCap`peRatio!7.340723e+11 35.37 (,`EBITDA)!,3.2714e+10
AMZN | `marketCap`peRatio!5.715004e+11 301.02 (,`EBITDA)!,1.4021e+10
FB | `marketCap`peRatio!5.311237e+11 35.22 (,`EBITDA)!,2.0304e+10
q)
q)type t
99h
Jonathon McMurray
Here’s one way to do it:
q)`sym`mcap`pe`ebitda xcol ([] sym:key t),'exec (quote,'stats) from value t
sym mcap pe ebitda
------------------------------------
AAPL 8.983506e+11 19.88 7.6569e+10
GOOGL 7.340723e+11 35.37 3.2714e+10
AMZN 5.715004e+11 301.02 1.4021e+10
FB 5.311237e+11 35.22 2.0304e+10
Hope this helps
Jonathon
--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
personal-kdbpl...@googlegroups.com.
To post to this group, send email to
personal...@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
This e-mail message is intended to be received only by persons entitled to receive the confidential information it may contain. E-mail messages to clients of AquaQ Analytics may contain information that is confidential and legally privileged. Please do not read, copy, forward, or store this message unless you are an intended recipient of it. If you have received this message in error, please forward it to the sender and delete it completely from your computer system.
ag
q)foo: flip`a`b`c!flip(0 0 0;1 2 3;2 4 6)
q)foo
a b c
-----
0 0 0
1 2 3
2 4 6
q)exec a from value foo
'type
[0] exec a from value foo
^
q)exec a from foo
0 1 2
([] sym:key t),'exec quote from value t
To post to this group, send email to persona...@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
Jonathon McMurray
quote stats
-------------------------------------------------------------
`marketCap`peRatio!8.938324e+11 19.78 (,`EBITDA)!,7.6569e+10
`marketCap`peRatio!7.448348e+11 35.89 (,`EBITDA)!,3.2714e+10
`marketCap`peRatio!5.762372e+11 303.51 (,`EBITDA)!,1.4021e+10
`marketCap`peRatio!5.318502e+11 35.27 (,`EBITDA)!,2.0304e+10
Sent: 27 November 2017 17:19
To: Kdb+ Personal Developers
Subject: Re: [personal kdb+] Re: q/kdb+ api for getting market and financial data from IEX
Anand C
'conn. OS reports: The requested protocol has not been configured into the system, or no implementation for it exists.
[2] C:\q\w32\iex_q.q:19: get_data:{[main_url;suffix;prefix;char_delta;identifier]
result: (`$":https://",main_url) suffix," ",prefix;
^
(char_delta + first result ss identifier) _ result
q))\
Jonathon McMurray
Hi Anand
Looks like you need to set up OpenSSL. You can download the installer for Windows from here: https://slproweb.com/products/Win32OpenSSL.html (you probably want to download “Win32 OpenSSL v1.1.0g Light”)
You’ll also need a certificate file – you can download this from here: https://curl.haxx.se/ca/cacert.pem
Finally in your command prompt, before running q, you need to run this command to set an environment variable:
set SSL_CA_CERT_FILE=C:\path\to\cacert.pem
(replacing path with correct path to wherever you downloaded cacert.pem)
Note the above “set” command will only be valid for the current command prompt session. To set it permanently, use the following instead:
setx SSL_CA_CERT_FILE C:\path\to\cacert.pem
This won’t set the variable in the current session, but will set it for all future sessions.
After doing these setup steps, HTTPS downloads should function correctly on Windows
Regards
Jonathon
From: personal...@googlegroups.com [mailto:personal...@googlegroups.com]
On Behalf Of Anand C
Sent: 03 January 2018 10:18
To: Kdb+ Personal Developers <personal...@googlegroups.com>
Subject: [personal kdb+] Re: q/kdb+ api for getting market and financial data from IEX
Hello Himanshu,,
--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
personal-kdbpl...@googlegroups.com.
To post to this group, send email to
personal...@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
Justin t
OS reports: The requested protocol has not been configured into the system, or no implementation for it exists.
Charles Skelton
--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
Justin t
I just tried uninstalling all versions of openssl and then installing it fresh, version "Win32 OpenSSL v1.1.0i" but am still getting the same error.Welcome to kdb+ 32bit editionFor support please see http://groups.google.com/d/forum/personal-kdbplusTutorials can be found at http://code.kx.com/wiki/TutorialsTo exit, type \\To remove this startup msg, edit q.q
On Wednesday, October 3, 2018 at 4:44:53 PM UTC-4, Charles Skelton wrote:
justin, are you using the 32 or 64bit version of kdb+? Please can you include the startup banner in your email?You'll need to install 32bit ssl libs if using 32bit kdb+, and 64bit ssl libs if using 64bit kdb+.hth,Charlie
On Wed, Oct 3, 2018 at 10:26 PM, Justin t <jjt...@gmail.com> wrote:
I've tried following these instructions as well as the kx SSL cookbook several times but cannot get this working for the life of me. I can't get past the following error:OS reports: The requested protocol has not been configured into the system, or no implementation for it exists.I have tried many versions of openssl and verified they work from the command line before running q, made sure the required windows DLLs are correctly on the PATH. I also have tried setting SSL_VERIFY_SERVER to "NO". Nothing works, I keep getting this same error.I'm on Windows 10.Does anyone know how I might be able to proceed to debug things from here to get this working?On Monday, November 13, 2017 at 7:00:15 AM UTC-5, Himanshu Gupta wrote:Figured I would post this here as many of you might find this useful.This weekend, I wrote a library to get IEX data in kdb. You can get all sorts of data including EOD summary (high, low, open, close, vwap), earnings (actual vs consensus EPS), financials and news.P.S. Through this project, I learnt that q has an operator for parsing json messages which I wasn't expecting. I just wish it had a more descriptive name than -29!. :)
--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbpl...@googlegroups.com.
To post to this group, send email to personal...@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.
Charles Skelton
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.