6 Messages
Digest #4287
Messages
Mon Jan 8, 2018 6:34 pm (PST) . Posted by:
eadamy
Randy, I've been kicking the tires on Tiingo for historical data and it looks pretty good. Their ticker plant includes stocks, ETFs and OEFs with 30+ years of history which includes both raw and dividend adjusted data. The API supports both JSON and csv retrieval. They claim their data is highly scrubbed although I have yet to put that to the test. Data limits for the Free plan are pretty generous and the $10/month plan is huge.
I'm wondering if you are considering adding support for Tiingo?
Earl Adamy
I'm wondering if you are considering adding support for Tiingo?
Earl Adamy
Mon Jan 8, 2018 7:09 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in currently can grab Tiingo historical quotes (as long as you sign
in). For example:
=smfGetCSVFile("https://api.tiingo.com/tiingo/daily/SPY/
prices?startDate=2017-12-1&endDate=2017-12-31&format=csv&resampleFreq=daily
")
But, yes, I have it on my "To Do" list to look at adding a function similar
to smfGetYahooHistory() and then adding Tiingo as a possible data source
for smfPricesByDates() and smfPricesBetween().
One nice thing about Tiingo is that it prompts you to log in if you try to
access the data, so there's no need to create the security cookie ahead of
time.
It's not particularly fast on turnaround time though. :(
On Mon, Jan 8, 2018 at 7:34 PM, earladamy@
...
wrote:
> Randy, I've been kicking the tires on Tiingo for historical data and it
> looks pretty good. Their ticker plant includes stocks, ETFs and OEFs with
> 30+ years of history which includes both raw and dividend adjusted data.
> The API supports both JSON and csv retrieval. They claim their data is
> highly scrubbed although I have yet to put that to the test. Data limits
> for the Free plan are pretty generous and the $10/month plan is huge.
>
> I'm wondering if you are considering adding support for Tiingo?
>
in). For example:
=smfGetCSVFile("https://api.tiingo.com/tiingo/daily/SPY/
prices?startDate=
")
But, yes, I have it on my "To Do" list to look at adding a function similar
to smfGetYahooHistory(
for smfPricesByDates(
One nice thing about Tiingo is that it prompts you to log in if you try to
access the data, so there's no need to create the security cookie ahead of
time.
It's not particularly fast on turnaround time though. :(
On Mon, Jan 8, 2018 at 7:34 PM, earladamy@
...
wrote:
> Randy, I've been kicking the tires on Tiingo for historical data and it
> looks pretty good. Their ticker plant includes stocks, ETFs and OEFs with
> 30+ years of history which includes both raw and dividend adjusted data.
> The API supports both JSON and csv retrieval. They claim their data is
> highly scrubbed although I have yet to put that to the test. Data limits
> for the Free plan are pretty generous and the $10/month plan is huge.
>
> I'm wondering if you are considering adding support for Tiingo?
>
Mon Jan 8, 2018 7:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
P.S. One issue I've seen is that although the adjusted prices seem to be
OK, the "divCash" column they return isn't. For example, look at FOOLX. It
issued both a dividend and a capital gains distribution last month. The
prices are adjusted for it, but nothing shows up in the "divCash" column
they produce. So I would probably limit fields to the date, volume, and
adjusted O/H/L/C. Maybe unadjusted prices?
On Mon, Jan 8, 2018 at 7:34 PM, earladamy@
...
wrote:
> Randy, I've been kicking the tires on Tiingo for historical data and it
> looks pretty good. Their ticker plant includes stocks, ETFs and OEFs with
> 30+ years of history which includes both raw and dividend adjusted data.
> The API supports both JSON and csv retrieval. They claim their data is
> highly scrubbed although I have yet to put that to the test. Data limits
> for the Free plan are pretty generous and the $10/month plan is huge.
>
> I'm wondering if you are considering adding support for Tiingo?
>
>
>
OK, the "divCash" column they return isn't. For example, look at FOOLX. It
issued both a dividend and a capital gains distribution last month. The
prices are adjusted for it, but nothing shows up in the "divCash" column
they produce. So I would probably limit fields to the date, volume, and
adjusted O/H/L/C. Maybe unadjusted prices?
On Mon, Jan 8, 2018 at 7:34 PM, earladamy@
...
wrote:
> Randy, I've been kicking the tires on Tiingo for historical data and it
> looks pretty good. Their ticker plant includes stocks, ETFs and OEFs with
> 30+ years of history which includes both raw and dividend adjusted data.
> The API supports both JSON and csv retrieval. They claim their data is
> highly scrubbed although I have yet to put that to the test. Data limits
> for the Free plan are pretty generous and the $10/month plan is huge.
>
> I'm wondering if you are considering adding support for Tiingo?
>
>
>
Tue Jan 9, 2018 10:34 am (PST) . Posted by:
"Ron Spruell" hashky
Is Yahoo smfPricesByDates() broken?
Ron
Ron
Tue Jan 9, 2018 11:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears to be working here:
2018-01-09 2017-12-31 2016-12-31 2015-12-31
SPY 275.220001220703 266.859985351563 220.387939453125 196.778656005859
What problems are you having?
On Tue, Jan 9, 2018 at 11:34 AM, Ron Spruell hashky@
...
wrote:
>
> Is Yahoo smfPricesByDates() broken?
>
>
>
2018-01-09 2017-12-31 2016-12-31 2015-12-31
SPY 275.220001220703 266.859985351563 220.387939453125 196.778656005859
What problems are you having?
On Tue, Jan 9, 2018 at 11:34 AM, Ron Spruell hashky@
...
wrote:
>
> Is Yahoo smfPricesByDates(
>
>
>
Tue Jan 9, 2018 4:11 pm (PST) . Posted by:
"Ron Spruell" hashky
My bad. I was using =smfGetYahooPortfolioView(I6,"87") to pull the date. Then I used smfPricesByDates() to pull in the price which was #N/A.
smfPricesByDates() is for past dates and smfGetYahooPortfolioView(I6,"15") would be for current dates.
I guess I got the old functions and the new functions out of sync.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 9, 2018 1:03 PM
Subject: Re: [smf_addin] smfPricesByDates()
It appears to be working here:
| | 2018-01-09 | 2017-12-31 | 2016-12-31 | 2015-12-31 |
| SPY | 275.220001220703 | 266.859985351563 | 220.387939453125 | 196.778656005859 |
What problems are you having?
On Tue, Jan 9, 2018 at 11:34 AM, Ron Spruell hashky@... wrote:
Is Yahoo smfPricesByDates() broken?
#yiv8911881626 #yiv8911881626 -- #yiv8911881626ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8911881626 #yiv8911881626ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8911881626 #yiv8911881626ygrp-mkp #yiv8911881626hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8911881626 #yiv8911881626ygrp-mkp #yiv8911881626ads {margin-bottom:10px;}#yiv8911881626 #yiv8911881626ygrp-mkp .yiv8911881626ad {padding:0 0;}#yiv8911881626 #yiv8911881626ygrp-mkp .yiv8911881626ad p {margin:0;}#yiv8911881626 #yiv8911881626ygrp-mkp .yiv8911881626ad a {color:#0000ff;text-decoration:none;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ygrp-lc {font-family:Arial;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ygrp-lc #yiv8911881626hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ygrp-lc .yiv8911881626ad {margin-bottom:10px;padding:0 0;}#yiv8911881626 #yiv8911881626actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8911881626 #yiv8911881626activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8911881626 #yiv8911881626activity span {font-weight:700;}#yiv8911881626 #yiv8911881626activity span:first-child {text-transform:uppercase;}#yiv8911881626 #yiv8911881626activity span a {color:#5085b6;text-decoration:none;}#yiv8911881626 #yiv8911881626activity span span {color:#ff7900;}#yiv8911881626 #yiv8911881626activity span .yiv8911881626underline {text-decoration:underline;}#yiv8911881626 .yiv8911881626attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8911881626 .yiv8911881626attach div a {text-decoration:none;}#yiv8911881626 .yiv8911881626attach img {border:none;padding-right:5px;}#yiv8911881626 .yiv8911881626attach label {display:block;margin-bottom:5px;}#yiv8911881626 .yiv8911881626attach label a {text-decoration:none;}#yiv8911881626 blockquote {margin:0 0 0 4px;}#yiv8911881626 .yiv8911881626bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8911881626 .yiv8911881626bold a {text-decoration:none;}#yiv8911881626 dd.yiv8911881626last p a {font-family:Verdana;font-weight:700;}#yiv8911881626 dd.yiv8911881626last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8911881626 dd.yiv8911881626last p span.yiv8911881626yshortcuts {margin-right:0;}#yiv8911881626 div.yiv8911881626attach-table div div a {text-decoration:none;}#yiv8911881626 div.yiv8911881626attach-table {width:400px;}#yiv8911881626 div.yiv8911881626file-title a, #yiv8911881626 div.yiv8911881626file-title a:active, #yiv8911881626 div.yiv8911881626file-title a:hover, #yiv8911881626 div.yiv8911881626file-title a:visited {text-decoration:none;}#yiv8911881626 div.yiv8911881626photo-title a, #yiv8911881626 div.yiv8911881626photo-title a:active, #yiv8911881626 div.yiv8911881626photo-title a:hover, #yiv8911881626 div.yiv8911881626photo-title a:visited {text-decoration:none;}#yiv8911881626 div#yiv8911881626ygrp-mlmsg #yiv8911881626ygrp-msg p a span.yiv8911881626yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8911881626 .yiv8911881626green {color:#628c2a;}#yiv8911881626 .yiv8911881626MsoNormal {margin:0 0 0 0;}#yiv8911881626 o {font-size:0;}#yiv8911881626 #yiv8911881626photos div {float:left;width:72px;}#yiv8911881626 #yiv8911881626photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8911881626 #yiv8911881626photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8911881626 #yiv8911881626reco-category {font-size:77%;}#yiv8911881626 #yiv8911881626reco-desc {font-size:77%;}#yiv8911881626 .yiv8911881626replbq {margin:4px;}#yiv8911881626 #yiv8911881626ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8911881626 #yiv8911881626ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8911881626 #yiv8911881626ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8911881626 #yiv8911881626ygrp-mlmsg select, #yiv8911881626 input, #yiv8911881626 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8911881626 #yiv8911881626ygrp-mlmsg pre, #yiv8911881626 code {font:115% monospace;}#yiv8911881626 #yiv8911881626ygrp-mlmsg * {line-height:1.22em;}#yiv8911881626 #yiv8911881626ygrp-mlmsg #yiv8911881626logo {padding-bottom:10px;}#yiv8911881626 #yiv8911881626ygrp-msg p a {font-family:Verdana;}#yiv8911881626 #yiv8911881626ygrp-msg p#yiv8911881626attach-count span {color:#1E66AE;font-weight:700;}#yiv8911881626 #yiv8911881626ygrp-reco #yiv8911881626reco-head {color:#ff7900;font-weight:700;}#yiv8911881626 #yiv8911881626ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ov li a {font-size:130%;text-decoration:none;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8911881626 #yiv8911881626ygrp-sponsor #yiv8911881626ov ul {margin:0;padding:0 0 0 8px;}#yiv8911881626 #yiv8911881626ygrp-text {font-family:Georgia;}#yiv8911881626 #yiv8911881626ygrp-text p {margin:0 0 1em 0;}#yiv8911881626 #yiv8911881626ygrp-text tt {font-size:120%;}#yiv8911881626 #yiv8911881626ygrp-vital ul li:last-child {border-right:none !important;}#yiv8911881626
smfPricesByDates() is for past dates and smfGetYahooPortfolioView(I6,"15") would be for current dates.
I guess I got the old functions and the new functions out of sync.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 9, 2018 1:03 PM
Subject: Re: [smf_addin] smfPricesByDates(
It appears to be working here:
| | 2018-01-09 | 2017-12-31 | 2016-12-31 | 2015-12-31 |
| SPY | 275.220001220703 | 266.859985351563 | 220.387939453125 | 196.778656005859 |
What problems are you having?
On Tue, Jan 9, 2018 at 11:34 AM, Ron Spruell hashky@... wrote:
Is Yahoo smfPricesByDates(
#yiv8911881626 #yiv8911881626 -- #yiv8911881626ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar