[smf_addin] Digest Number 1839

EXCEL Stock Market Functions Add-in

Messages In This Digest (9 Messages)

1a.

Yahoo Dividends History Errors From: dguillett1

2a.

Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...) From: iddomilan

2b.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: Randy Harmelink

2c.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: iddomilan

2d.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: iddomilan

2e.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: Randy Harmelink

2f.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: iddomilan

2g.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: Randy Harmelink

2h.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM... From: iddomilan

View All Topics | Create New Topic

Messages

1a.

Yahoo Dividends History Errors

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Fri May 27, 2011 8:12 am (PDT)

Mar 7, 2006 0.25 Dividend
Dec 7, 2005 0.25 Dividend
Sep 7, 2005 0.25 Dividend
Jun 7, 2005 0.25 Dividend
Mar 16, 2005 0.25 Dividend
Dec 8, 2004 0.25 Dividend
Aug 16, 2004 2.25 Dividend
Jul 30, 2001 0.00 Dividend
Nov 27, 1998 0.152 Dividend
Aug 28, 1998 91: 16 Stock Split

I'm getting this sort of thing on MANY yahoo dividend histories. Ideas. This is FTR
I also get errors on others such as:
ALL 06/28/00 0.00
BHI 05/02/88 0.88
BMY 08/07/01 2.78

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.

Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...)

Posted by: "iddomilan" iddomilan@yahoo.com   iddomilan

Fri May 27, 2011 9:14 am (PDT)

Does anyone else have this same problem for some symbols (returns "N/A")? Does anyone have a work around?

http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2b.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri May 27, 2011 9:18 am (PDT)

The work-around would be to go to a different source for the data, since
"N/A" is what Yahoo is populating the field with on the CSV files.

On Fri, May 27, 2011 at 9:07 AM, iddomilan <iddomilan@yahoo.com> wrote:

> Does anyone else have this same problem for some symbols (returns "N/A")?
> Does anyone have a work around?
>
> http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2c.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "iddomilan" iddomilan@yahoo.com   iddomilan

Fri May 27, 2011 9:21 am (PDT)

Which source?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The work-around would be to go to a different source for the data, since
> "N/A" is what Yahoo is populating the field with on the CSV files.
>
> On Fri, May 27, 2011 at 9:07 AM, iddomilan <iddomilan@...> wrote:
>
> > Does anyone else have this same problem for some symbols (returns "N/A")?
> > Does anyone have a work around?
> >
> > http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2d.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "iddomilan" iddomilan@yahoo.com   iddomilan

Fri May 27, 2011 9:24 am (PDT)

I am not sure there are other sources I can get this data.

--- In smf_addin@yahoogroups.com, "iddomilan" <iddomilan@...> wrote:
>
> Which source?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > The work-around would be to go to a different source for the data, since
> > "N/A" is what Yahoo is populating the field with on the CSV files.
> >
> > On Fri, May 27, 2011 at 9:07 AM, iddomilan <iddomilan@> wrote:
> >
> > > Does anyone else have this same problem for some symbols (returns "N/A")?
> > > Does anyone have a work around?
> > >
> > > http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6
> > >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2e.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri May 27, 2011 9:34 am (PDT)

Any variety of them:

http://finance.yahoo.com/q?s=c
http://finance.yahoo.com/q/ecn?s=C
http://investing.money.msn.com/investments/stock-price?symbol=C
http://www.bloomberg.com/apps/quote?ticker=C:US

Etc, Etc.

But none will be as convenient as Yahoo's CSV feed.

On Fri, May 27, 2011 at 9:20 AM, iddomilan <iddomilan@yahoo.com> wrote:

> Which source?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > The work-around would be to go to a different source for the data, since
> > "N/A" is what Yahoo is populating the field with on the CSV files.
> >
> > On Fri, May 27, 2011 at 9:07 AM, iddomilan <iddomilan@...> wrote:
> >
> > > Does anyone else have this same problem for some symbols (returns
> "N/A")?
> > > Does anyone have a work around?
> > >
> > > http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2f.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "iddomilan" iddomilan@yahoo.com   iddomilan

Fri May 27, 2011 9:38 am (PDT)

Are you suggesting to parse through there HTML to get the info I need? This sounds like a bad idea, I could possible get blocked if I make to many hits. There isn't anything else you know of that returns a csv, or xml, or json or something along those lines?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Any variety of them:
>
> http://finance.yahoo.com/q?s=c
> http://finance.yahoo.com/q/ecn?s=C
> http://investing.money.msn.com/investments/stock-price?symbol=C
> http://www.bloomberg.com/apps/quote?ticker=C:US
>
> Etc, Etc.
>
> But none will be as convenient as Yahoo's CSV feed.
>
> On Fri, May 27, 2011 at 9:20 AM, iddomilan <iddomilan@...> wrote:
>
> > Which source?
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > The work-around would be to go to a different source for the data, since
> > > "N/A" is what Yahoo is populating the field with on the CSV files.
> > >
> > > On Fri, May 27, 2011 at 9:07 AM, iddomilan <iddomilan@> wrote:
> > >
> > > > Does anyone else have this same problem for some symbols (returns
> > "N/A")?
> > > > Does anyone have a work around?
> > > >
> > > > http://finance.yahoo.com/d/quotes.csv?s=C&f=a5b6
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2g.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri May 27, 2011 9:46 am (PDT)

I'm curious why you're asking the question here if you don't use the add-in?
The parsing is done by the add-in functions.

I don't know of another service that provides such a file. However, you
could use the Yahoo quotes interface, provided you had the proper portfolio
view set up. For example:

http://finance.yahoo.com/quotes/C,IBM,MMM
http://finance.yahoo.com/quotes/C,IBM,MMM/view/dv

On Fri, May 27, 2011 at 9:38 AM, iddomilan <iddomilan@yahoo.com> wrote:

> Are you suggesting to parse through there HTML to get the info I need? This
> sounds like a bad idea, I could possible get blocked if I make to many hits.
> There isn't anything else you know of that returns a csv, or xml, or json or
> something along those lines?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2h.

Re: Can't get Bid and Ask size for some symbols (C, IBM, LVS, MGM...

Posted by: "iddomilan" iddomilan@yahoo.com   iddomilan

Fri May 27, 2011 9:51 am (PDT)

I do have the add-in to excel but I can't get it to work on my linux server so I thought I'd take a different approach.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm curious why you're asking the question here if you don't use the add-in?
> The parsing is done by the add-in functions.
>
> I don't know of another service that provides such a file. However, you
> could use the Yahoo quotes interface, provided you had the proper portfolio
> view set up. For example:
>
> http://finance.yahoo.com/quotes/C,IBM,MMM
> http://finance.yahoo.com/quotes/C,IBM,MMM/view/dv
>
> On Fri, May 27, 2011 at 9:38 AM, iddomilan <iddomilan@...> wrote:
>
> > Are you suggesting to parse through there HTML to get the info I need? This
> > sounds like a bad idea, I could possible get blocked if I make to many hits.
> > There isn't anything else you know of that returns a csv, or xml, or json or
> > something along those lines?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

Recent Activity

•  89
  New Members
•  1
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

---

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe