[smf_addin] Digest Number 2086

EXCEL Stock Market Functions Add-in

Messages In This Digest (6 Messages)

1a.

Re: Grab info from Boursorama.com From: nicodemus_65

1b.

Re: Grab info from Boursorama.com From: Patrick Van Beesen

1c.

Re: Grab info from Boursorama.com From: nicodemus_65

2a.

Problems with Yahoo Finance Data Retrieval From: thomas91112

2b.

Re: Problems with Yahoo Finance Data Retrieval From: Mike McQuaid

3a.

Re: YAHOO Latest Price access From: Pete A

View All Topics | Create New Topic

Messages

1a.

Re: Grab info from Boursorama.com

Posted by: "nicodemus_65" nicodemus_65@yahoo.fr   nicodemus_65

Sun Jan 22, 2012 5:07 am (PST)

Excellent ! Works perfectly !

I must admint that I've never thought about using this function.
Now that I know, I guess I'm gonna have a lot of fun grabbing more details elsewhere.

Thanks a million for your add-ins and most of all for your outstanding support.

Nico

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =TRIM(smfStrExtr("|"&smfGetTagContent($C$3,"title",1),"|","|"))
> =TRIM(smfStrExtr(smfGetTagContent($C$3,"title",1)&"|","|","|"))
> =smfGetTagContent($C$3,"span",-1,"fv-isin")
>
> None of them were in tables, so the next choice is usually the
> smfGetTagContent() function.
>
> On Sat, Jan 21, 2012 at 9:32 AM, nicodemus_65 <nicodemus_65@...> wrote:
>
> >
> > I'm using with success
> > =RCHGetTableCell("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS
> > ";2;">Cotations";;;;1)
> > to retrieve, among other info, the last price of the the stock EVS.
> > Further to these info, I'd like now to grab its name (EVS BROADC.EQUIPM),
> > its symbol (EVS) and its isin code (BE0003820371) but can't manage to find
> > the correct syntax.
> > I've tried =RCHGetWebData("http://www.boursorama.com/cours.phtml?symbole=
> > FF11-EVS") to get the whole html code to help me manipulate RCHGetTableCell(),
> > but it didn't helped me.
> >
> > Could someone give some hints ?
> >
>

Back to top

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

1b.

Re: Grab info from Boursorama.com

Posted by: "Patrick Van Beesen" patrick.van.beesen@perso.be   patrickvb

Sun Jan 22, 2012 7:01 am (PST)

Try this,

=smfGetTagContent($C$3,"span",-1,"dn") give EVS BROADC.EQUIPM. |
EVS

EVS is an exellent company It's 90% of the slow motion replay on TV and
it is an olympic game year.

Patrick.

On 1/21/2012 9:33 PM, Randy Harmelink wrote:
>
> Try:
>
> =TRIM(smfStrExtr("|"&smfGetTagContent($C$3,"title",1),"|","|"))
> =TRIM(smfStrExtr(smfGetTagContent($C$3,"title",1)&"|","|","|"))
> =smfGetTagContent($C$3,"span",-1,"fv-isin")
>
> None of them were in tables, so the next choice is usually the
> smfGetTagContent() function.
>
> On Sat, Jan 21, 2012 at 9:32 AM, nicodemus_65 <nicodemus_65@yahoo.fr
> <mailto:nicodemus_65@yahoo.fr>> wrote:
>
>
> I'm using with success
> =RCHGetTableCell("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS";2;">Cotations";;;;1)
> to retrieve, among other info, the last price of the the stock EVS.
> Further to these info, I'd like now to grab its name (EVS
> BROADC.EQUIPM), its symbol (EVS) and its isin code (BE0003820371)
> but can't manage to find the correct syntax.
> I've tried
> =RCHGetWebData("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS")
> to get the whole html code to help me manipulate
> RCHGetTableCell(), but it didn't helped me.
>
> Could someone give some hints ?
>
>
>

Back to top

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

1c.

Re: Grab info from Boursorama.com

Posted by: "nicodemus_65" nicodemus_65@yahoo.fr   nicodemus_65

Sun Jan 22, 2012 9:15 am (PST)

thx Patrick !

--- In smf_addin@yahoogroups.com, Patrick Van Beesen <patrick.van.beesen@...> wrote:
>
> Try this,
>
> =smfGetTagContent($C$3,"span",-1,"dn") give EVS BROADC.EQUIPM. |
> EVS
>
>
> EVS is an exellent company It's 90% of the slow motion replay on TV and
> it is an olympic game year.
>
> Patrick.
>
>
> On 1/21/2012 9:33 PM, Randy Harmelink wrote:
> >
> > Try:
> >
> > =TRIM(smfStrExtr("|"&smfGetTagContent($C$3,"title",1),"|","|"))
> > =TRIM(smfStrExtr(smfGetTagContent($C$3,"title",1)&"|","|","|"))
> > =smfGetTagContent($C$3,"span",-1,"fv-isin")
> >
> > None of them were in tables, so the next choice is usually the
> > smfGetTagContent() function.
> >
> > On Sat, Jan 21, 2012 at 9:32 AM, nicodemus_65 <nicodemus_65@...
> > <mailto:nicodemus_65@...>> wrote:
> >
> >
> > I'm using with success
> > =RCHGetTableCell("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS";2;">Cotations";;;;1)
> > to retrieve, among other info, the last price of the the stock EVS.
> > Further to these info, I'd like now to grab its name (EVS
> > BROADC.EQUIPM), its symbol (EVS) and its isin code (BE0003820371)
> > but can't manage to find the correct syntax.
> > I've tried
> > =RCHGetWebData("http://www.boursorama.com/cours.phtml?symbole=FF11-EVS")
> > to get the whole html code to help me manipulate
> > RCHGetTableCell(), but it didn't helped me.
> >
> > Could someone give some hints ?
> >
> >
> >
>

Back to top

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

2a.

Problems with Yahoo Finance Data Retrieval

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

Sun Jan 22, 2012 12:07 pm (PST)

Following is a message received from Yahoo Finance Customer Support regarding recent issues retrieving price information and a possible cause for the problems.

"We understand that some functionality of Yahoo! Finance may be lost when being viewed within Google Chrome.

At this time, Google Chrome is not supported by Yahoo! Finance. To get the most from Yahoo! Finance on a PC, you will need to be running Windows XP, Windows Vista, or Windows 7 and either Internet Explorer 7 (or higher) or Mozilla Firefox 3 (or higher)."

Hope this helps.
Mike

Back to top

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

2b.

Re: Problems with Yahoo Finance Data Retrieval

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Sun Jan 22, 2012 12:16 pm (PST)

Handy to know but it has nothing to do with the add-in.

SMF uses the Excel Web Query interface which itself relies on Internet
Explorer. It doesn't matter which other browser you use or may have
installed - Excel always goes through IE. See Randy's doc about that here:
http://finance.groups.yahoo.com/group/smf_addin/message/13523

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of thomas91112
Sent: Sunday, January 22, 2012 3:08 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Problems with Yahoo Finance Data Retrieval

Following is a message received from Yahoo Finance Customer Support
regarding recent issues retrieving price information and a possible cause
for the problems.

"We understand that some functionality of Yahoo! Finance may be lost when
being viewed within Google Chrome.

At this time, Google Chrome is not supported by Yahoo! Finance. To get the
most from Yahoo! Finance on a PC, you will need to be running Windows XP,
Windows Vista, or Windows 7 and either Internet Explorer 7 (or higher) or
Mozilla Firefox 3 (or higher)."

Hope this helps.
Mike

Back to top

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

3a.

Re: YAHOO Latest Price access

Posted by: "Pete A" optionzz@gmail.com   option2z

Sun Jan 22, 2012 12:42 pm (PST)

RE: Although I don't understand why RCHGetYahooQuotes() isn't just used...
Me either. Lost in the mists of antiquity, but a very easy (and obvious now) solution. Thanks! The words that came out of my mouth was duh!!
Pete A

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/17013
>
> Although I don't understand why RCHGetYahooQuotes() isn't just used...
>
> On Sun, Jan 22, 2012 at 12:54 AM, PLA <optionzz@...> wrote:
> We've discussed the change Yahoo made to the summary page where they
> changed "Latest Price." But I can't find a good solution
> looking back.
> Here's a fragment of the new page's html:
>
> <span class="time_rtq_ticker"><span id="yfs_l84_ibm">188.52</span>
>
> And a picture of the page from whence it came:
>
>
>
> Used to use: RCHGetTableCell("http://finance.yahoo.com/q?s=
> <http://finance.yahoo.com/q?s=> "&B5,1,">Last Trade:") embedded with
> some other formulas so was very convenient.
>
> Some formulas, including the one you suggested for the two day RSI need
> this data. I can't figure out how to get the number 188.52. The
> tag before it changes with the _TICKER (_ibm"> in this case. Can
> you help?
>

Back to top

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

Recent Activity

•  117
  New Members
•  5
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

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

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