Minggu, 17 Juli 2011

[smf_addin] Digest Number 1889

Messages In This Digest (9 Messages)

Messages

1a.

Re: smfGetOptionQuotes give wrong numbers for ADBE

Posted by: "Glen Fullmer" gfullmer@cox.net   gfullmer

Sat Jul 16, 2011 9:44 am (PDT)



On Thu, 2011-07-14 at 22:25 -0700, Randy Harmelink wrote:

> 1. The add-in is extracting the data from a web page it had saved
> from earlier. To resolve this, run the smfForceRecalculation
> macro (see the "Links" area of the group for info).
>
> 2. The add-in is picking up an old page from IE's cache. To
> resolve, see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/13523

The latter seemed to work, thanks. I am not sure how to use the
smfForceRecalculation macro. Looks like I can't just add it to a cell.
Is that correct? I will reread the documentation to get a better idea.
With Excel 2007 F9 seem to work. Is it bound to the macro?

Thanks for all you do,
Glen

--
Glen Fullmer, gfullmer@cox.net, http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot.com - cash flow blog
http://www.alreadytoharvest.com - historical novel
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
should do to you, do ye even so to them" - Jesus
---

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1b.

Re: smfGetOptionQuotes give wrong numbers for ADBE

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

Sat Jul 16, 2011 10:09 am (PDT)



Like I said, you need to go to the item in the "Links" area of the group to
find out more about smfForceRecalculation.

F9 with NOT update the smfGetOptionQuotes() function.

On Sat, Jul 16, 2011 at 9:44 AM, Glen Fullmer <gfullmer@cox.net> wrote:

> The latter seemed to work, thanks. I am not sure how to use the
> smfForceRecalculation macro. Looks like I can't just add it to a cell.
> Is that correct? I will reread the documentation to get a better idea.
> With Excel 2007 F9 seem to work. Is it bound to the macro?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

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

Sat Jul 16, 2011 11:33 am (PDT)



I have been successfully using formulas like the following to get quotes for mutual funds into a cell in an Excel spreadsheet:

=RCHGetYahooQuotes($B27,"l1",,NOW())

In the above, the cell B27 contains the 5-char ticker for a mutual fund or a 3-char ticker for an exchange-traded fund. This has been working for about the past six months.

Last Friday, some cell formulas started returning numbers that look like the following:

503240576.00
503256192.00
503105216.00

If I press F9 to update, some of the "problem" cells will show the correct quote, but other cells that were showing correct quotes, will now show these strange numbers. No matter how many times I press F9, the problem cells just move around.

I have made no changes to the spreadsheet. One possible issue: since the beginning (six months ago), I have been using Excel 2010 on a Windows 7 (64-bit) platform. But again the trouble only started last Friday.

Any clues as to what might be going on here? Has something changed at Yahoo that means I am going to have to abandon smf_addin??

Any suggestions will be welcome.

Dave Simonds

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

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

Sat Jul 16, 2011 11:43 am (PDT)



My guess would be something was going on with the Yahoo servers...

On Sat, Jul 16, 2011 at 11:31 AM, davedc78 <davedc78@yahoo.com> wrote:

> I have been successfully using formulas like the following to get quotes
> for mutual funds into a cell in an Excel spreadsheet:
>
> =RCHGetYahooQuotes($B27,"l1",,NOW())
>
> In the above, the cell B27 contains the 5-char ticker for a mutual fund or
> a 3-char ticker for an exchange-traded fund. This has been working for about
> the past six months.
>
> Last Friday, some cell formulas started returning numbers that look like
> the following:
>
> 503240576.00
> 503256192.00
> 503105216.00
>
> If I press F9 to update, some of the "problem" cells will show the correct
> quote, but other cells that were showing correct quotes, will now show these
> strange numbers. No matter how many times I press F9, the problem cells just
> move around.
>
> I have made no changes to the spreadsheet. One possible issue: since the
> beginning (six months ago), I have been using Excel 2010 on a Windows 7
> (64-bit) platform. But again the trouble only started last Friday.
>
> Any clues as to what might be going on here? Has something changed at Yahoo
> that means I am going to have to abandon smf_addin??
>
> Any suggestions will be welcome.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: bloomberg businessweek data

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

Sat Jul 16, 2011 11:46 am (PDT)



Did you try? It's about as straight-forward an extraction as there can be:

=RCHGetTableCell("
http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=PAEKY:US
",1,">Revenues")

It's just a matter of looking at the source code of the web page to find a
good search string to key the extraction off of.

On Fri, Jul 15, 2011 at 9:20 PM, alexander <life2539@yahoo.com> wrote:

> Is it possible or has anybody tried to use the SMF addin to get data from
> bloomberg businessweek website. here is a link of one company's financials.
>
>
> http://investing.businessweek.com/research/stocks/financials/financials.asp?ticker=PAEKY:US
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Split Information

Posted by: "MLSrini" mlsrini@yahoo.com   mlsrini

Sat Jul 16, 2011 12:00 pm (PDT)



Hello,
Can anybody please help me to extract split information for a specific symbol between two dates?
Thanks,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: Split Information

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

Sat Jul 16, 2011 12:01 pm (PDT)



See: http://finance.groups.yahoo.com/group/smf_addin/message/14400

On Sat, Jul 16, 2011 at 11:51 AM, MLSrini <mlsrini@yahoo.com> wrote:

>
> Can anybody please help me to extract split information for a specific
> symbol between two dates?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

Get the word "Event" in RCHGetTableCell

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Sat Jul 16, 2011 12:18 pm (PDT)



Hi foro members -

When trying:

=RCHGetTableCell("http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=BTU-N",1,">Forward
P/E")
 
I get the literal "Event" in the cell.

Any ideas?
Regards,
Jose L. Jacob
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: Get the word "Event" in RCHGetTableCell

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

Sat Jul 16, 2011 12:24 pm (PDT)



That's because the data you're trying to extract is not being presented in
an HTML table. Try:

=0+smfGetTagContent("
http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=BTU-N","span",1,">Forward
P/E")

On Sat, Jul 16, 2011 at 12:18 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> When trying:
>
> =RCHGetTableCell("
> http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=BTU-N",1,">ForwardP/E")
>
> I get the literal "Event" in the cell.
>
> Any ideas?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in 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
Diposting oleh EXCEL FEED LEARNING di 03.40

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)