[smf_addin] Digest Number 2249

EXCEL Stock Market Functions Add-in

Messages In This Digest (6 Messages)

1a.

Re: Bloomberg stock last trade price From: Kevin Miole

1b.

Re: Bloomberg stock last trade price From: Randy Harmelink

1c.

Re: Bloomberg stock last trade price From: Kevin Miole

2.

Did somebody apply SMF to extract data from Mergent Online? From: JCHyjun

3a.

suggestion for smf formula RCHGetYahooQuotes(ticker, "n" ) From: investor952

3b.

Re: suggestion for smf formula RCHGetYahooQuotes(ticker, "n" ) From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

Re: Bloomberg stock last trade price

Posted by: "Kevin Miole" kevinleijh@yahoo.com   kevinleijh

Sat Jun 16, 2012 1:23 am (PDT)

Thank you again for your reply what does "|"& mean in the formula so that I can understand the syntax?

--- In smf_addin@yahoogroups.com, "Kevin Miole" <kevinleijh@...> wrote:
>
> Thank you very much
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Not a simple extraction:
> >
> > =smfConvertData(smfStrExtr("|"&smfGetTagContent("
> > http://www.bloomberg.com/quote/BPI:PM","span",-1,"class="" price"""),"|","
> > "))
> >
> > That works now, but I don't know if their web page format will be
> > consistent.
> >
> > On Sat, Jun 16, 2012 at 12:14 AM, Kevin Miole <kevinleijh@> wrote:
> >
> > > hi I'm new here can you help me get bloomberg stock qoutes for a company
> > > for example BPI:PM I can't figure out how to get the price thank you
> > >
> >
>

Back to top

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

1b.

Re: Bloomberg stock last trade price

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

Sat Jun 16, 2012 1:56 am (PDT)

It's a dummy string I appended so that the smfStrExtr() has a starting
point for extracting data.

Work through the formula piece-by-piece from the innards and you should see
why.

On Sat, Jun 16, 2012 at 1:23 AM, Kevin Miole <kevinleijh@yahoo.com> wrote:

> Thank you again for your reply what does "|"& mean in the formula so that
> I can understand the syntax?
> > >
> > > Not a simple extraction:
> > >
> > > =smfConvertData(smfStrExtr("|"&smfGetTagContent("
> > > http://www.bloomberg.com/quote/BPI:PM","span",-1,"class=""
> price"""),"|","
> > > "))
> > >
> > > That works now, but I don't know if their web page format will be
> > > consistent.
>

Back to top

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

1c.

Re: Bloomberg stock last trade price

Posted by: "Kevin Miole" kevinleijh@yahoo.com   kevinleijh

Sat Jun 16, 2012 2:15 am (PDT)

Thank you

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It's a dummy string I appended so that the smfStrExtr() has a starting
> point for extracting data.
>
> Work through the formula piece-by-piece from the innards and you should see
> why.
>
> On Sat, Jun 16, 2012 at 1:23 AM, Kevin Miole <kevinleijh@...> wrote:
>
> > Thank you again for your reply what does "|"& mean in the formula so that
> > I can understand the syntax?
> > > >
> > > > Not a simple extraction:
> > > >
> > > > =smfConvertData(smfStrExtr("|"&smfGetTagContent("
> > > > http://www.bloomberg.com/quote/BPI:PM","span",-1,"class=""
> > price"""),"|","
> > > > "))
> > > >
> > > > That works now, but I don't know if their web page format will be
> > > > consistent.
> >
>

Back to top

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

2.

Did somebody apply SMF to extract data from Mergent Online?

Posted by: "JCHyjun" jchyjun@yahoo.com   JCHyjun

Sat Jun 16, 2012 12:15 pm (PDT)

Did somebody apply SMF to extract data from Mergent Online?

Back to top

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

3a.

suggestion for smf formula RCHGetYahooQuotes(ticker, "n" )

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

Sat Jun 16, 2012 10:23 pm (PDT)

Randy, can the number of characters that this function returns be
increased. When I use it on many ticker symbols, much if not most of the name is cut off making it useless for most tickers...thx.

Back to top

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

3b.

Re: suggestion for smf formula RCHGetYahooQuotes(ticker, "n" )

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

Sat Jun 16, 2012 10:26 pm (PDT)

Sorry, but that's out of my control -- the length you are getting is all
that Yahoo is supplying...

On Sat, Jun 16, 2012 at 10:21 PM, investor952 <investor952@yahoo.com> wrote:

> Randy, can the number of characters that this function returns be
> increased. When I use it on many ticker symbols, much if not most of the
> name is cut off making it useless for most tickers...thx.
>

Back to top

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

Recent Activity

•  63
  New Members

Visit Your Group

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

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

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