3 New Messages

Digest #2350

Re: Yahoo Historical Prices - close by "dguillett1" donaldb36

Real Time Quotes by "thomas91112" thomas91112

Re: Problem with RCHGetElementNumber() by "T A R U N" tarun_1457

Messages

1a

Re: Yahoo Historical Prices - close

Thu Sep 20, 2012 5:36 am (PDT) . Posted by:

"dguillett1" donaldb36

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com

From: antonvanas1989
Sent: Wednesday, September 19, 2012 2:16 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo Historical Prices - close

Hi Randy,

Im looking at my sheet at the moment and i found a problem.

The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.

Example:
Tick = KO
Stocksplit = 13 august 2012 (2:1 split)

Following data from Annual 2011
before sp. after split
Outstanding shares 2284 4568
EPS 3.75 1.88
Share Price 69.97 69.97

P/E Ratio 18.66 37.32

So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.

Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits

Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?

How do you think about this bug?

Greets Anton

Attachments with this message:

1 of 1 File(s)

GetYahooMultipleHistoryALL_SAS_P1.xls

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Real Time Quotes

Thu Sep 20, 2012 7:24 am (PDT) . Posted by:

"thomas91112" thomas91112

A lot of people have expressed interest in real time Yahoo quotes through the smf functions, but has anyone actually done it? I subscribe to Yahoo real time quotes and receive them on the Yahoo Finance pages, I log into Yahoo Finance using IE9 and find that my GetYahooQuotes are still delayed 15 min. The Yahoo quotes screen is real time, my smf spreadsheet is delayed.

Does anyone have a working spreadsheet they could provide so we can find out how to get real time quotes? Please delete any formulas or other items you view as proprietary, I just want to find out how to get these quotes because nothing in this Message or Documentation sections seems to resolve the problem.

Thanks
Mike

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3a

Re: Problem with RCHGetElementNumber()

Thu Sep 20, 2012 5:39 pm (PDT) . Posted by:

"T A R U N" tarun_1457

Hi Randy,

Had a chance to dig further into this to see if its URL related. But
doesnt seem so, tried this:
http://www.advfn.com/p.php?pid=financials&symbol=JNJ&mode=annual_reports
http://www.advfn.com/p.php?pid=financials&symbol=BAC&mode=annual_reports
(or any other banking stock)

I tried looking up "Revenues (YTD)" for both;

JNJ => RCHGetElementNumber("JNJ",5906) > 65030But BAC =>
RCHGetElementNumber("BAC",5906) > Error
Please take a look when you get chance. Thanks for the great project
sharing.
Tarun
--- In smf_addin@yahoogroups.com, "tarun_1457" <tarunparmar@...> wrote:
>
> Hey Randy,
>
> I was working with RCHGetElementNumber() and came across a minor
problem where Source AdvFN-A (#7096) reads "Cash End of Period -- FY1".
But AdvFN website has a typo for Banking related companies e.g. BAC, JPM
etc. read "Cash At End of Period".
>
> I then tried to add up "Net Change in Cash & Equivalents" and "Cash At
Beginning of Period" to get 'Cash at End of Period'. But it does not
show values under any of these columns.
>
> Please advise.
>
> Thanks,
> Tarun
>
> Sample: =RCHGetElementNumber("BAC",7076) or
> =RCHGetElementNumber("JPM",7086)
>