4 Messages
Digest #3753
Messages
Sun Jul 24, 2016 7:19 pm (PDT) . Posted by:
eadamy
It's been a well known fact that Yahoo has been shopped for a long time now. It appears that an announcement is on the way from Verizon on Monday morning that it will acquire Yahoo. No matter whether Verizon or another buyer, I expect that the entire business model will be under close scrutiny and that will most likely include the availability of free (and especially) historical quotes data. I'm not sure that a business case can be made for allowing many thousands of us to continue downloading masses of free historical data. Maintaining a historical quotes database is expensive and both storage and bandwidth are not insignificant costs.
As a heavy user of the RCHGetYahooHistory-Function, I am to say the least, very concerned. I know changes will not occur overnight but I am wondering what Plan B looks like. The closest I have come is Quandl which runs $50/month for US data; however I would have to make major changes to my Excel VBA model to switch.
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
As a heavy user of the RCHGetYahooHistory-
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
Sun Jul 24, 2016 7:44 pm (PDT) . Posted by:
"David" who1012000
This is a very good question. I have only done a small amount of research to try and find an alternate price history source. I would be interested if anyone comes up with another source. Thanks for bringing this up. Thanks, David
From: "earladamy@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 24, 2016 7:19 PM
Subject: [smf_addin] Yahoo and Verizon (or whoever)
<!--#yiv2163260981 #yiv2163260981 .yiv2163260981ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv2163260981 div.yiv2163260981ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;min-height:62px;width:62px;}#yiv2163260981 div.yiv2163260981photo-title a, #yiv2163260981 div.yiv2163260981photo-title a:active, #yiv2163260981 div.yiv2163260981photo-title a:hover, #yiv2163260981 div.yiv2163260981photo-title a:visited {text-decoration:none;}#yiv2163260981 div.yiv2163260981attach-table div.yiv2163260981attach-row {clear:both;}#yiv2163260981 div.yiv2163260981attach-table div.yiv2163260981attach-row div {float:left;}#yiv2163260981 p {clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv2163260981 div.yiv2163260981ygrp-file {width:30px;}#yiv2163260981 div.yiv2163260981attach-table div.yiv2163260981attach-row div div a {text-decoration:none;}#yiv2163260981 div.yiv2163260981attach-table div.yiv2163260981attach-row div div span {font-weight:normal;}#yiv2163260981 div.yiv2163260981ygrp-file-title {font-weight:bold;}#yiv2163260981 --> <!--#yiv2163260981 #yiv2163260981ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2163260981 #yiv2163260981ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2163260981 #yiv2163260981ygrp-mkp #yiv2163260981hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2163260981 #yiv2163260981ygrp-mkp #yiv2163260981ads {margin-bottom:10px;}#yiv2163260981 #yiv2163260981ygrp-mkp .yiv2163260981ad {padding:0 0;}#yiv2163260981 #yiv2163260981ygrp-mkp .yiv2163260981ad p {margin:0;}#yiv2163260981 #yiv2163260981ygrp-mkp .yiv2163260981ad a {color:#0000ff;text-decoration:none;}-->
It's been a well known fact that Yahoo has been shopped for a long time now. It appears that an announcement is on the way from Verizon on Monday morning that it will acquire Yahoo. No matter whether Verizon or another buyer, I expect that the entire business model will be under close scrutiny and that will most likely include the availability of free (and especially) historical quotes data. I'm not sure that a business case can be made for allowing many thousands of us to continue downloading masses of free historical data. Maintaining a historical quotes database is expensive and both storage and bandwidth are not insignificant costs.
As a heavy user of the RCHGetYahooHistory-Function, I am to say the least, very concerned. I know changes will not occur overnight but I am wondering what Plan B looks like. The closest I have come is Quandl which runs $50/month for US data; however I would have to make major changes to my Excel VBA model to switch.
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
From: "earladamy@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, July 24, 2016 7:19 PM
Subject: [smf_addin] Yahoo and Verizon (or whoever)
<!--#yiv21632609
It's been a well known fact that Yahoo has been shopped for a long time now. It appears that an announcement is on the way from Verizon on Monday morning that it will acquire Yahoo. No matter whether Verizon or another buyer, I expect that the entire business model will be under close scrutiny and that will most likely include the availability of free (and especially) historical quotes data. I'm not sure that a business case can be made for allowing many thousands of us to continue downloading masses of free historical data. Maintaining a historical quotes database is expensive and both storage and bandwidth are not insignificant costs.
As a heavy user of the RCHGetYahooHistory-
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
Sun Jul 24, 2016 8:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
None of the other free sources I'm aware of adjust historical prices for
dividends.
Well, not totally true. The NYSE export (data provided by MorningStar)
does, but it won't allow the add-in access to the portal:
https://www.nyse.com/quote/ARCX:SPY
Google is easy, but no adjustments:
=smfGetCSVFile("
http://www.google.com/finance/historical?q=SPY&output=csv&startdate=Jul 1,
2016&enddate=Jul 24, 2016")
Or from MorningStar, also no adjustments, and data only goes back to 2000
or so:
=smfGetCSVFile("
http://performance.morningstar.com/perform/Performance/stock/exportStockPrice.action?t=MMM&pd=custom&freq=d&sd=01/01/2016&ed=06/30/2016
")
And I'm not happy with the quality of data from either.
On Sun, Jul 24, 2016 at 7:19 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> It's been a well known fact that Yahoo has been shopped for a long time
> now. It appears that an announcement is on the way from Verizon on Monday
> morning that it will acquire Yahoo. No matter whether Verizon or another
> buyer, I expect that the entire business model will be under close scrutiny
> and that will most likely include the availability of free (and especially)
> historical quotes data. I'm not sure that a business case can be made for
> allowing many thousands of us to continue downloading masses of free
> historical data. Maintaining a historical quotes database is expensive and
> both storage and bandwidth are not insignificant costs.
>
> As a heavy user of the RCHGetYahooHistory-Function, I am to say the least,
> very concerned. I know changes will not occur overnight but I am wondering
> what Plan B looks like. The closest I have come is Quandl which runs
> $50/month for US data; however I would have to make major changes to my
> Excel VBA model to switch.
>
> I am wondering what options other may see and if Randy is giving
> consideration to migrating functions to other data sources?
>
>
dividends.
Well, not totally true. The NYSE export (data provided by MorningStar)
does, but it won't allow the add-in access to the portal:
https://www.nyse.com/quote/ARCX:SPY
Google is easy, but no adjustments:
=smfGetCSVFile("
http://www.google.com/finance/historical?q=SPY&output=csv&startdate=Jul 1,
2016&enddate=Jul 24, 2016")
Or from MorningStar, also no adjustments, and data only goes back to 2000
or so:
=smfGetCSVFile("
http://performance.morningstar.com/perform/Performance/stock/exportStockPrice.action?t=MMM&pd=custom&freq=d&sd=01/01/2016&ed=06/30/2016
")
And I'm not happy with the quality of data from either.
On Sun, Jul 24, 2016 at 7:19 PM, earladamy@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> It's been a well known fact that Yahoo has been shopped for a long time
> now. It appears that an announcement is on the way from Verizon on Monday
> morning that it will acquire Yahoo. No matter whether Verizon or another
> buyer, I expect that the entire business model will be under close scrutiny
> and that will most likely include the availability of free (and especially)
> historical quotes data. I'm not sure that a business case can be made for
> allowing many thousands of us to continue downloading masses of free
> historical data. Maintaining a historical quotes database is expensive and
> both storage and bandwidth are not insignificant costs.
>
> As a heavy user of the RCHGetYahooHistory-
> very concerned. I know changes will not occur overnight but I am wondering
> what Plan B looks like. The closest I have come is Quandl which runs
> $50/month for US data; however I would have to make major changes to my
> Excel VBA model to switch.
>
> I am wondering what options other may see and if Randy is giving
> consideration to migrating functions to other data sources?
>
>
Sun Jul 24, 2016 10:40 pm (PDT) . Posted by:
"YewMun Lee" leeyewmun
Try Metastock, they have EOD data for usd25 per month, real time data for usd150 per month.I did subscribed the usd150 as data feed for QuantShare (backtesting software).
Sent from Yahoo Mail on Android
On Mon, 25 Jul, 2016 at 10:19, earladamy@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
It's been a well known fact that Yahoo has been shopped for a long time now. It appears that an announcement is on the way from Verizon on Monday morning that it will acquire Yahoo. No matter whether Verizon or another buyer, I expect that the entire business model will be under close scrutiny and that will most likely include the availability of free (and especially) historical quotes data. I'm not sure that a business case can be made for allowing many thousands of us to continue downloading masses of free historical data. Maintaining a historical quotes database is expensive and both storage and bandwidth are not insignificant costs.
As a heavy user of the RCHGetYahooHistory-Function, I am to say the least, very concerned. I know changes will not occur overnight but I am wondering what Plan B looks like. The closest I have come is Quandl which runs $50/month for US data; however I would have to make major changes to my Excel VBA model to switch.
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
Sent from Yahoo Mail on Android
On Mon, 25 Jul, 2016 at 10:19, earladamy@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:
It's been a well known fact that Yahoo has been shopped for a long time now. It appears that an announcement is on the way from Verizon on Monday morning that it will acquire Yahoo. No matter whether Verizon or another buyer, I expect that the entire business model will be under close scrutiny and that will most likely include the availability of free (and especially) historical quotes data. I'm not sure that a business case can be made for allowing many thousands of us to continue downloading masses of free historical data. Maintaining a historical quotes database is expensive and both storage and bandwidth are not insignificant costs.
As a heavy user of the RCHGetYahooHistory-
I am wondering what options other may see and if Randy is giving consideration to migrating functions to other data sources?
Earl
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar