5 Messages
Digest #4053
Messages
Thu Jun 8, 2017 12:47 am (PDT) . Posted by:
msimmsx
re: "wife passed last week and kids need me"
Omigosh Steve....my prayers are with you.
Omigosh Steve....my prayers are with you.
Thu Jun 8, 2017 6:43 am (PDT) . Posted by:
nanastasakis
http://beta.morningstar.com/stocks/xnys/aep/quote.html http://beta.morningstar.com/stocks/xnys/aep/quote.html
If you scroll down past the valuation ratios referenced in the elements above, under the dividend section you'll see the payout ratio metrics.
Is that sufficient?
-Nick
If you scroll down past the valuation ratios referenced in the elements above, under the dividend section you'll see the payout ratio metrics.
Is that sufficient?
-Nick
Thu Jun 8, 2017 8:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. As far as I can tell, when Morningstar goes to "beta", the
add-in will no longer have access to the data. The data is retrieved using
APIs that require credentials. I don't see the data you want there, anyway.
All they had was payout ratio by year. If that's what you want, you can
grab this CSV file:
=smfGetCSVFile("
http://financials.morningstar.com/finan/ajax/exportKR2CSV.html?t=AEP&order=asc
")
On Thu, Jun 8, 2017 at 6:43 AM, nanastasakis@
...
wrote:
>
> http://beta.morningstar.com/stocks/xnys/aep/quote.html
>
> If you scroll down past the valuation ratios referenced in the elements
> above, under the dividend section you'll see the payout ratio metrics.
>
> Is that sufficient?
>
>
>
add-in will no longer have access to the data. The data is retrieved using
APIs that require credentials. I don't see the data you want there, anyway.
All they had was payout ratio by year. If that's what you want, you can
grab this CSV file:
=smfGetCSVFile("
http://financials.morningstar.com/finan/ajax/exportKR2CSV.html?t=AEP&order=asc
")
On Thu, Jun 8, 2017 at 6:43 AM, nanastasakis@
...
wrote:
>
> http://beta.morningstar.com/stocks/xnys/aep/quote.html
>
> If you scroll down past the valuation ratios referenced in the elements
> above, under the dividend section you'll see the payout ratio metrics.
>
> Is that sufficient?
>
>
>
Thu Jun 8, 2017 3:14 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, you may already know this but other may not.
Plus, I am not sure it is totally correct –
Yahoo has terminated the stock price APIs that many applications use for downloads
From: xltraders@yahoogroups.com [mailto:xltraders@yahoogroups.com]
Sent: Thursday, June 08, 2017 5:55 PM
To: xltraders@yahoogroups.com
Subject: [xlt] Update for Yahoo stock price downloader
Yahoo has terminated the stock price APIs that many applications use for downloads. It's still possible to obtain Yahoo data in json or .csv formats, but information on how to do it is scattered around the web--Yahoo doesn't seem to offer any guidance. Since they'll soon be merging with AOL and laying off up to 1000 people, it's probably just as well not to depend on them anyway.
Other sites provide free data; here are three of them I've looked at, in increasing order of preference, with pros and cons. In all cases, free registration is required.
EODdata.com: Offers unlimited daily data but only 30 days of free historical data. One year of historical is $35/mo; 3 years is $45/mo.
Intrinio.com: Someone in this group mentioned the site. Offers up to 500 data points per day free and a free Excel add-in (works with Excel 2010 and later). A data point consists of a daily price or other datum (dividend, etc.) or 100 historical prices obtained in one API call. The Excel add-in works well, but if you have more than a few tickers, it would require some juggling to avoid exceeding the data cap-–maybe daily and dividends one day and historical prices the next. Even then, you have to pare down your data set to minimize the number of points requested. Unlimited data is $40/mo.
Tiingo.com: I found out about this in a post by Vangelis on logical-invest.com, and it seems to be the best. They have a much higher cap that most people are unlikely to exceed: 40GB a month, 10,000 hourly requests, and 100,000 daily requests (https://api.tiingo.com/account/usage). They ask for a $7/month donation, but it's not required, and even so is very reasonable compared to what other sites charge. It's possible to get daily, historical, and dividends in two calls--see https://api.tiingo.com/docs/tiingo/daily:
Daily: https://api.tiingo.com/tiingo/daily/**tickerHere**/prices
Historical (including dividends–"divCash"): https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?startDate=2016-1-1 <https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?startDate=2016-1-1&endDate=2017-1-1> &endDate=2017-1-1
These return data in json format, then the file needs to be parsed to extract it.
I'm having my Excel downloader updated to use these (for daily, historical, and dividends) and will post it here when it's ready, probably within the next week or two.
Plus, I am not sure it is totally correct –
Yahoo has terminated the stock price APIs that many applications use for downloads
From: xltraders@yahoogroups.com [mailto:xltraders@yahoogroups.com]
Sent: Thursday, June 08, 2017 5:55 PM
To: xltraders@yahoogroups.com
Subject: [xlt] Update for Yahoo stock price downloader
Yahoo has terminated the stock price APIs that many applications use for downloads. It's still possible to obtain Yahoo data in json or .csv formats, but information on how to do it is scattered around the web--Yahoo doesn't seem to offer any guidance. Since they'll soon be merging with AOL and laying off up to 1000 people, it's probably just as well not to depend on them anyway.
Other sites provide free data; here are three of them I've looked at, in increasing order of preference, with pros and cons. In all cases, free registration is required.
EODdata.com: Offers unlimited daily data but only 30 days of free historical data. One year of historical is $35/mo; 3 years is $45/mo.
Intrinio.com: Someone in this group mentioned the site. Offers up to 500 data points per day free and a free Excel add-in (works with Excel 2010 and later). A data point consists of a daily price or other datum (dividend, etc.) or 100 historical prices obtained in one API call. The Excel add-in works well, but if you have more than a few tickers, it would require some juggling to avoid exceeding the data cap-–maybe daily and dividends one day and historical prices the next. Even then, you have to pare down your data set to minimize the number of points requested. Unlimited data is $40/mo.
Tiingo.com: I found out about this in a post by Vangelis on logical-invest.com, and it seems to be the best. They have a much higher cap that most people are unlikely to exceed: 40GB a month, 10,000 hourly requests, and 100,000 daily requests (https://api.tiingo.com/account/usage). They ask for a $7/month donation, but it's not required, and even so is very reasonable compared to what other sites charge. It's possible to get daily, historical, and dividends in two calls--see https://api.tiingo.com/docs/tiingo/daily:
Daily: https://api.tiingo.com/tiingo/daily/**tickerHere**/prices
Historical (including dividends–"divCash"): https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?startDate=2016-1-1 <https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?startDate=2016-1-1&endDate=2017-1-1> &endDate=2017-
These return data in json format, then the file needs to be parsed to extract it.
I'm having my Excel downloader updated to use these (for daily, historical, and dividends) and will post it here when it's ready, probably within the next week or two.
Thu Jun 8, 2017 3:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's what we've been talking about for the last month. :)
On Thu, Jun 8, 2017 at 3:14 PM, 'Kermit W. Prather' kermitp@
...
wrote:
>
> Randy, you may already know this but other may not.
>
> Plus, I am not sure it is totally correct –
>
> Yahoo has terminated the stock price APIs that many applications use for
> downloads
>
>
>
> *From:* xltraders@yahoogroups.com [mailto:xltraders@yahoogroups.com]
> *Sent:* Thursday, June 08, 2017 5:55 PM
> *To:* xltraders@yahoogroups.com
> *Subject:* [xlt] Update for Yahoo stock price downloader
>
>
> Yahoo has terminated the stock price APIs that many applications use for
> downloads. It's still possible to obtain Yahoo data in json or .csv
> formats, but information on how to do it is scattered around the web--Yahoo
> doesn't seem to offer any guidance. Since they'll soon be merging with AOL
> and laying off up to 1000 people, it's probably just as well not to depend
> on them anyway.
>
> Other sites provide free data; here are three of them I've looked at, in
> increasing order of preference, with pros and cons. In all cases, free
> registration is required.
>
> *EODdata.com:* Offers unlimited daily data but only 30 days of free
> historical data. One year of historical is $35/mo; 3 years is $45/mo.
>
> *Intrinio.com:* Someone in this group mentioned the site. Offers up to
> 500 data points per day free and a free Excel add-in (works with Excel 2010
> and later). A data point consists of a daily price or other datum
> (dividend, etc.) or 100 historical prices obtained in one API call. The
> Excel add-in works well, but if you have more than a few tickers, it would
> require some juggling to avoid exceeding the data cap-–maybe daily and
> dividends one day and historical prices the next. Even then, you have to
> pare down your data set to minimize the number of points requested.
> Unlimited data is $40/mo.
>
> *Tiingo.com:* I found out about this in a post by Vangelis on
> logical-invest.com, and it seems to be the best. They have a much higher
> cap that most people are unlikely to exceed: 40GB a month, 10,000 hourly
> requests, and 100,000 daily requests (https://api.tiingo.com/account/usage).
> They ask for a $7/month donation, but it's not required, and even so is
> very reasonable compared to what other sites charge. It's possible to get
> daily, historical, and dividends in two calls--see
> https://api.tiingo.com/docs/tiingo/daily:
>
> *Daily:* https://api.tiingo.com/tiingo/daily/**tickerHere**/prices
>
> *Historical* (including dividends–"divCash"):
> https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?
> startDate=2016-1-1&endDate=2017-1-1
>
> These return data in json format, then the file needs to be parsed to
> extract it.
>
> I'm having my Excel downloader updated to use these (for daily,
> historical, and dividends) and will post it here when it's ready, probably
> within the next week or two.
>
>
On Thu, Jun 8, 2017 at 3:14 PM, 'Kermit W. Prather' kermitp@
...
wrote:
>
> Randy, you may already know this but other may not.
>
> Plus, I am not sure it is totally correct –
>
> Yahoo has terminated the stock price APIs that many applications use for
> downloads
>
>
>
> *From:* xltraders@yahoogroups.com [mailto:xltraders@yahoogroups.com]
> *Sent:* Thursday, June 08, 2017 5:55 PM
> *To:* xltraders@yahoogroups.com
> *Subject:* [xlt] Update for Yahoo stock price downloader
>
>
> Yahoo has terminated the stock price APIs that many applications use for
> downloads. It's still possible to obtain Yahoo data in json or .csv
> formats, but information on how to do it is scattered around the web--Yahoo
> doesn't seem to offer any guidance. Since they'll soon be merging with AOL
> and laying off up to 1000 people, it's probably just as well not to depend
> on them anyway.
>
> Other sites provide free data; here are three of them I've looked at, in
> increasing order of preference, with pros and cons. In all cases, free
> registration is required.
>
> *EODdata.com:* Offers unlimited daily data but only 30 days of free
> historical data. One year of historical is $35/mo; 3 years is $45/mo.
>
> *Intrinio.com:* Someone in this group mentioned the site. Offers up to
> 500 data points per day free and a free Excel add-in (works with Excel 2010
> and later). A data point consists of a daily price or other datum
> (dividend, etc.) or 100 historical prices obtained in one API call. The
> Excel add-in works well, but if you have more than a few tickers, it would
> require some juggling to avoid exceeding the data cap-–maybe daily and
> dividends one day and historical prices the next. Even then, you have to
> pare down your data set to minimize the number of points requested.
> Unlimited data is $40/mo.
>
> *Tiingo.com:* I found out about this in a post by Vangelis on
> logical-invest.com, and it seems to be the best. They have a much higher
> cap that most people are unlikely to exceed: 40GB a month, 10,000 hourly
> requests, and 100,000 daily requests (https://api.tiingo.com/account/usage).
> They ask for a $7/month donation, but it's not required, and even so is
> very reasonable compared to what other sites charge. It's possible to get
> daily, historical, and dividends in two calls--see
> https://api.tiingo.com/docs/tiingo/daily:
>
> *Daily:* https://api.tiingo.com/tiingo/daily/**tickerHere**/prices
>
> *Historical* (including dividends–"divCash"):
> https://api.tiingo.com/tiingo/daily/**tickerHere**/prices?
> startDate=2016-
>
> These return data in json format, then the file needs to be parsed to
> extract it.
>
> I'm having my Excel downloader updated to use these (for daily,
> historical, and dividends) and will post it here when it's ready, probably
> within the next week or two.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar