4 New Messages
Digest #2455
Messages
Tue Jan 1, 2013 3:31 pm (PST) . Posted by:
"twoq2bstr8" twoq2bstr8
Hi Randy
I came across your addin's over twelve months ago and they have provided me with invaluable functionality to build my excel portfolio templates.
However I have an issue and a big one!
The yahoo historical price data that the smfpricebydate function pulls in is not accurate. I know this has been raised before by other people and complained about, and I have accepted until now that the yahoo data has numerous errors. But it is getting to a point where the quality of the data is so poor that the usefulness of your functions is now becoming questionable. As an example the most recent dates of the 27/12, 28/12 and 31/12 there is no price data on yahoo. However if you put in today's date it has the closing price for the 31st???? (before market opened). Google on the other hand has price for all three dates AND they are accurate.
If the add is just going to pull in rubbish data than it is not much use. I have read other threads asking whether price data can be pulled in from google finance. And you have said this is quite difficult, but I'm asking again, would it be possible to get the smfpricesby date addin to access google historical price data as an option?
My last option is to go to a data provider but I feel I do not use the infomration often enough to justify the expense. One thing is certain I will not be using the data providers that yahoo uses!
I came across your addin's over twelve months ago and they have provided me with invaluable functionality to build my excel portfolio templates.
However I have an issue and a big one!
The yahoo historical price data that the smfpricebydate function pulls in is not accurate. I know this has been raised before by other people and complained about, and I have accepted until now that the yahoo data has numerous errors. But it is getting to a point where the quality of the data is so poor that the usefulness of your functions is now becoming questionable. As an example the most recent dates of the 27/12, 28/12 and 31/12 there is no price data on yahoo. However if you put in today's date it has the closing price for the 31st???? (before market opened). Google on the other hand has price for all three dates AND they are accurate.
If the add is just going to pull in rubbish data than it is not much use. I have read other threads asking whether price data can be pulled in from google finance. And you have said this is quite difficult, but I'm asking again, would it be possible to get the smfpricesby date addin to access google historical price data as an option?
My last option is to go to a data provider but I feel I do not use the infomration often enough to justify the expense. One thing is certain I will not be using the data providers that yahoo uses!
Tue Jan 1, 2013 4:22 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You're preaching to the choir. Unfortunately, the add-in, when working at
its best, can only return what is at the data source.
When I started doing options, I ran into continual data problems with
Yahoo, MSN, and Google. And still run into them. All three have a lot of
missing options, even to the point of missing entire expiration dates. Even
on popular ETFs like SPY and IWM. It's why I use the slower OptionsXPress
-- I'm more likely to find the data, and better quality data, from a data
source that actually is trading the options they show.
The primary reason I haven't gone to other data sources (like Google) for
historical quotes, is they don't adjust the historical quotes for
dividends. I consider that to be completely bogus data. A secondary reason
was that I've run into a number of ticker symbols that don't even have CSV
files available on Google.
OTOH, it probably wouldn't be that hard to create an smfPricesByDates()
function for Google. The main difference would just be the retrieval of the
CSV file.
On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@gmail.com > wrote:
>
> I came across your addin's over twelve months ago and they have provided
> me with invaluable functionality to build my excel portfolio templates.
>
> However I have an issue and a big one!
>
> The yahoo historical price data that the smfpricebydate function pulls in
> is not accurate. I know this has been raised before by other people and
> complained about, and I have accepted until now that the yahoo data has
> numerous errors. But it is getting to a point where the quality of the data
> is so poor that the usefulness of your functions is now becoming
> questionable. As an example the most recent dates of the 27/12, 28/12 and
> 31/12 there is no price data on yahoo. However if you put in today's date
> it has the closing price for the 31st???? (before market opened). Google on
> the other hand has price for all three dates AND they are accurate.
>
> If the add is just going to pull in rubbish data than it is not much use.
> I have read other threads asking whether price data can be pulled in from
> google finance. And you have said this is quite difficult, but I'm asking
> again, would it be possible to get the smfpricesby date addin to access
> google historical price data as an option?
>
> My last option is to go to a data provider but I feel I do not use the
> infomration often enough to justify the expense. One thing is certain I
> will not be using the data providers that yahoo uses!
>
its best, can only return what is at the data source.
When I started doing options, I ran into continual data problems with
Yahoo, MSN, and Google. And still run into them. All three have a lot of
missing options, even to the point of missing entire expiration dates. Even
on popular ETFs like SPY and IWM. It's why I use the slower OptionsXPress
-- I'm more likely to find the data, and better quality data, from a data
source that actually is trading the options they show.
The primary reason I haven't gone to other data sources (like Google) for
historical quotes, is they don't adjust the historical quotes for
dividends. I consider that to be completely bogus data. A secondary reason
was that I've run into a number of ticker symbols that don't even have CSV
files available on Google.
OTOH, it probably wouldn't be that hard to create an smfPricesByDates(
function for Google. The main difference would just be the retrieval of the
CSV file.
On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@
>
> I came across your addin's over twelve months ago and they have provided
> me with invaluable functionality to build my excel portfolio templates.
>
> However I have an issue and a big one!
>
> The yahoo historical price data that the smfpricebydate function pulls in
> is not accurate. I know this has been raised before by other people and
> complained about, and I have accepted until now that the yahoo data has
> numerous errors. But it is getting to a point where the quality of the data
> is so poor that the usefulness of your functions is now becoming
> questionable. As an example the most recent dates of the 27/12, 28/12 and
> 31/12 there is no price data on yahoo. However if you put in today's date
> it has the closing price for the 31st???? (before market opened). Google on
> the other hand has price for all three dates AND they are accurate.
>
> If the add is just going to pull in rubbish data than it is not much use.
> I have read other threads asking whether price data can be pulled in from
> google finance. And you have said this is quite difficult, but I'm asking
> again, would it be possible to get the smfpricesby date addin to access
> google historical price data as an option?
>
> My last option is to go to a data provider but I feel I do not use the
> infomration often enough to justify the expense. One thing is certain I
> will not be using the data providers that yahoo uses!
>
Tue Jan 1, 2013 8:19 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just looked at an example of Google historical prices for MMM.
- Data is adjusted for splits only, no dividends.
- I found a number of days (holidays?) where open, high, low, and volume
are zero, but closing price exists, matching neither the day before or the
day after.
- Data only goes back to 1997-02-28.
I used:
=smfGetCSVFIle("http://www.google.com/finance/historical?q=MMM&startdate=Feb26,
1990&output=csv")
I don't see it as an improvement to Yahoo's glitches...
On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@gmail.com > wrote:
>
> I have read other threads asking whether price data can be pulled in from
> google finance.
>
- Data is adjusted for splits only, no dividends.
- I found a number of days (holidays?) where open, high, low, and volume
are zero, but closing price exists, matching neither the day before or the
day after.
- Data only goes back to 1997-02-28.
I used:
=smfGetCSVFIle(
1990&output=
I don't see it as an improvement to Yahoo's glitches...
On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@
>
> I have read other threads asking whether price data can be pulled in from
> google finance.
>
Wed Jan 2, 2013 1:45 am (PST) . Posted by:
"twoq2bstr8" twoq2bstr8
Hi Randy
Thanks for the reply, made me laugh, yes I know I'm only saying things that everyone else is experiencing as well.
As for historcial pricing I'm using smfpricesbydate function to get stock prices not options.
I'm not familiar with the getcsvfile addin below will need to take a closer look at this. But ths limitation you mentioned ie. data only back to 1997 is not a big deal for me, and no dividends I think does not affect what I'm doing although I have to declare my knowledge is limited in this area so can't be sure on this one.
I appreciate that all data has it's faults however I believe google's has less that yahoo and the present time.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just looked at an example of Google historical prices for MMM.
>
> - Data is adjusted for splits only, no dividends.
>
> - I found a number of days (holidays?) where open, high, low, and volume
> are zero, but closing price exists, matching neither the day before or the
> day after.
>
> - Data only goes back to 1997-02-28.
>
> I used:
>
> =smfGetCSVFIle("http://www.google.com/finance/historical?q=MMM&startdate=Feb26,
> 1990&output=csv")
>
> I don't see it as an improvement to Yahoo's glitches...
>
> On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@...> wrote:
>
> >
> > I have read other threads asking whether price data can be pulled in from
> > google finance.
> >
>
Thanks for the reply, made me laugh, yes I know I'm only saying things that everyone else is experiencing as well.
As for historcial pricing I'm using smfpricesbydate function to get stock prices not options.
I'm not familiar with the getcsvfile addin below will need to take a closer look at this. But ths limitation you mentioned ie. data only back to 1997 is not a big deal for me, and no dividends I think does not affect what I'm doing although I have to declare my knowledge is limited in this area so can't be sure on this one.
I appreciate that all data has it's faults however I believe google's has less that yahoo and the present time.
--- In smf_addin@yahoogrou
>
> I just looked at an example of Google historical prices for MMM.
>
> - Data is adjusted for splits only, no dividends.
>
> - I found a number of days (holidays?) where open, high, low, and volume
> are zero, but closing price exists, matching neither the day before or the
> day after.
>
> - Data only goes back to 1997-02-28.
>
> I used:
>
> =smfGetCSVFIle(
> 1990&output=
>
> I don't see it as an improvement to Yahoo's glitches...
>
> On Tue, Jan 1, 2013 at 4:31 PM, twoq2bstr8 <simongbalzer@
>
> >
> > I have read other threads asking whether price data can be pulled in from
> > google finance.
> >
>
Tidak ada komentar:
Posting Komentar