Senin, 25 Juli 2016

[smf_addin] Digest Number 3753

4 Messages

Digest #3753
1b
1c
Re: Yahoo and Verizon (or whoever) by "Randy Harmelink" rharmelink
1d
Re: Yahoo and Verizon (or whoever) by "YewMun Lee" leeyewmun

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




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

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?
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar