Senin, 29 April 2013

[smf_addin] Digest Number 2598

12 New Messages

Digest #2598
2a
ADVFN by "kcaisaacs" kcaisaacs
2b
Re: ADVFN by "Randy Harmelink" rharmelink
3a
Yahoo Prices problem by antonvanas1989
3b
Re: Yahoo Prices problem by "Randy Harmelink" rharmelink
4a
Add-In Locations Changed by "lm5585@sbcglobal.net" lm5585@sbcglobal.net
4b
Re: Add-In Locations Changed by "Randy Harmelink" rharmelink

Messages

Sun Apr 28, 2013 6:57 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hello randy

is it possible to extract data from the section Valuation History C
Price/Earnings
Price/Book
Price/Sales
Price/Cash Flow

on http://financials.morningstar.com/valuation/price-ratio.html?t=C

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately that page is dynamically generated, so there is nothing in
> the source code of the web page for the add-in to extract. However, the
> data from that page you're interested in actually comes from here:
>
> http://financials.morningstar.com/valuation/valuation-history.action?t=C&type=price-earnings
>
> So, this appears to work, but the page is not a real HTML page, but one to
> be consumed by JavaScript:
>
> =RCHGetTableCell("
> http://financials.morningstar.com/valuation/valuation-history.action?t=C&type=price-earnings
> ",9,"abbr=""Price/Earnings")
>
> On Tue, Nov 29, 2011 at 10:34 PM, Les S <dolce7ss@...> wrote:
>
> > I see, thanks. Any way to tap into the javascript of the main morningstar
> > page? http://financials.morningstar.com/valuation/price-ratio.html?t=C
> >
> > Or is that the limit for now?
> >
>

Sun Apr 28, 2013 8:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

As the message you replied to indicated, that web page is dynamically
generated, so no data is available to be extracted. You should be able to
get it from the print report though:

http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=C

On Sun, Apr 28, 2013 at 6:57 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

> hello randy
>
> is it possible to extract data from the section Valuation History C
> Price/Earnings
> Price/Book
> Price/Sales
> Price/Cash Flow
>
> on http://financials.morningstar.com/valuation/price-ratio.html?t=C
>

Mon Apr 29, 2013 1:16 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hello randy,

for the page you referred, i could not find any of the datas below

what i would like specifically are the 10 year p/e, p/s, p/b and p/cf data which used to have a rchelement number.

tried using page source method but it just shows me a blank screen

was wondering is there any other tricks to get the data?

thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> As the message you replied to indicated, that web page is dynamically
> generated, so no data is available to be extracted. You should be able to
> get it from the print report though:
>
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=C
>
> On Sun, Apr 28, 2013 at 6:57 AM, weekeewawa <weekeewawa@...> wrote:
>
> > hello randy
> >
> > is it possible to extract data from the section Valuation History C
> > Price/Earnings
> > Price/Book
> > Price/Sales
> > Price/Cash Flow
> >
> > on http://financials.morningstar.com/valuation/price-ratio.html?t=C
> >
>

Sun Apr 28, 2013 8:21 am (PDT) . Posted by:

"kcaisaacs" kcaisaacs

Randy,
I am new to the group and am especially interested in the AdvFN quarterly data.

The function RCHGetElementNumber() has element numbers for the past 20 quarters of financial data. Is it possible get older data (back to say 1998)?

Also, is it possible to add/change some of the elements in order to get industry-specific data such as net interest income for banks?

I intially tried accessing this data with a query, but found that the date had to be changed manually for each set of 5 quarters of data. I then tried writing an ie automation macro, but a "Permisson Denied" error 70 kept appearing. Not having extensive programming skills, I can't tell if this is a problem related to thier site-i.e. access for continued downloading is restricted or tied up by other users. Have you had any experience with this?

Thanks

Sun Apr 28, 2013 8:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the smfGetAdvFNElement() function. There are a few templates
using it as well.

On Sun, Apr 28, 2013 at 4:54 AM, kcaisaacs <ken.isaacs@verizon.net> wrote:

>
> I am new to the group and am especially interested in the AdvFN quarterly
> data.
>
> The function RCHGetElementNumber() has element numbers for the past 20
> quarters of financial data. Is it possible get older data (back to say
> 1998)?
>
> Also, is it possible to add/change some of the elements in order to get
> industry-specific data such as net interest income for banks?
>
> I intially tried accessing this data with a query, but found that the date
> had to be changed manually for each set of 5 quarters of data. I then tried
> writing an ie automation macro, but a "Permisson Denied" error 70 kept
> appearing. Not having extensive programming skills, I can't tell if this is
> a problem related to thier site-i.e. access for continued downloading is
> restricted or tied up by other users. Have you had any experience with this?
>

Sun Apr 28, 2013 3:27 pm (PDT) . Posted by:

antonvanas1989

Hello Randy,





I have some problems on my sheet using: Yahoo price by dates (low, high, close, adj. close) and calculating ratios with those data.








Coca Cola (KO)2012201120102009

Diluted EPS1,971,852,531,47
Price by dates from Yahoo
period low32,1528,9722,8816,46
period high39,8334,3630,9227,05
period close35,9933,7830,8625,93
not adjusted close36,2569,9765,7757,00

My sheet at this moment
PE Close18,4037,8226,0038,78
PE High20,2218,5712,2218,40
PE Low16,3215,669,0411,20

Actual PE from Advfn
PE Close18,4191319,5
PE High20,619,51320,4
PE Low16,916,79,812,8



As you can see the data i calculate is not correct. The problem is because yahoo adjust the prices (i think for dividend). So my calculations will get off more and more after adjustment.



Now can i use Advfn data direct from the website, but then i have the following problem:

Because i am from Europa i like to use my sheet for American and Europeaan stocks aswell.

Advfn is not showing lot of stocks from Europe so i use for those calculations data from Msn instead.



So when i calculate all the formules on my own it is still working fine, but at this moment the data is not correct because the adjustments... How do you think about this? Hope you have a solution for me so i can still use data from both MSN and Advfn.



Thanks in advance,



Kind regards,

Anton van As

Sun Apr 28, 2013 3:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Are you doing this day-by-day, and using ONLY the diluted EPS only within
the timespan it was reported, and not based on the actual fiscal year?

That is, if the year-end 2012 data isn't available until mid-Feburary of
2013, you can't use it when calculating your 2012 ratios.

On Sun, Apr 28, 2013 at 3:26 PM, <antonvanas1989@yahoo.com> wrote:

>
> I have some problems on my sheet using: Yahoo price by dates (low, high,
> close, adj. close) and calculating ratios with those data.
>
> Coca Cola (*KO*) *2012* *2011* *2010* *2009* Diluted EPS 1,97 1,85
> 2,53 1,47 *Price by dates from Yahoo* period low 32,15 28,97 22,88 16,46 period
> high 39,83 34,36 30,92 27,05 period close 35,99 33,78 30,86 25,93 not
> adjusted close 36,25 69,97 65,77 57,00 *My sheet at this moment* PE
> Close 18,40 37,82 26,00 38,78 PE High 20,22 18,57 12,22 18,40 PE Low
> 16,32 15,66 9,04 11,20 *Actual PE from Advfn* PE Close 18,4 19 13
> 19,5 PE High 20,6 19,5 13 20,4 PE Low 16,9 16,7 9,8 12,8
>
> As you can see the data i calculate is not correct. The problem is because
> yahoo adjust the prices (i think for dividend). So my calculations will get
> off more and more after adjustment.
>
> Now can i use Advfn data direct from the website, but then i have the
> following problem:
> Because i am from Europa i like to use my sheet for American and Europeaan
> stocks aswell.
> Advfn is not showing lot of stocks from Europe so i use for those
> calculations data from Msn instead.
>
> So when i calculate all the formules on my own it is still working fine,
> but at this moment the data is not correct because the adjustments... How
> do you think about this? Hope you have a solution for me so i can still use
> data from both MSN and Advfn.
>
>

Sun Apr 28, 2013 4:00 pm (PDT) . Posted by:

"lm5585@sbcglobal.net" lm5585@sbcglobal.net

Hi,

I used the addin a while back to set up a really intricate search. It worked. Loved it. Used it recently, and all of my numbers were off. I'm guessing either the addin changed or MSN Finance (where I was extracting the numbers from) changed. Do I just need to install the latest version of the addin into excel or will I have to re write all of my functions?

Thanks

Sun Apr 28, 2013 4:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If the location has changed, you just need to do a one time "find and
replace all" for each file that used the old location as you open them. As
soon as you save each, EXCEL will save it with the new location so you
won't have the problem again with that workbook.

There is a macro within the add-in to do the "find and replace all" --
smfFixLinks. I use it whenever I have location errors. I put a button on my
QAT for it.

On Sun, Apr 28, 2013 at 4:00 PM, lm5585@sbcglobal.net
<lm5585@sbcglobal.net>wrote:

>
> I used the addin a while back to set up a really intricate search. It
> worked. Loved it. Used it recently, and all of my numbers were off. I'm
> guessing either the addin changed or MSN Finance (where I was extracting
> the numbers from) changed. Do I just need to install the latest version of
> the addin into excel or will I have to re write all of my functions?
>

Sun Apr 28, 2013 9:27 pm (PDT) . Posted by:

"zbgb952" zbgb952

Anyone know why there are no MSN stock scouter ratings for all these stocks, all of which are midstream MLPs?

ATLS
BKEP
BPL
CMLP
CQP
DPM
EEP
ENB
epd
EROC
ETE
etp
GEL
HEP
KMI
KMP
MMLP
MWE
NGLS
NRGM
NS
OILT
OKE
OKS
PBA
RGP
SE
SXL
TCP
TLLP
TLP
TRP
WES
WPZ

MSN does have a rating for a very few midstream mlp's like mmp, but all the others above return an error message. What gives?

Sun Apr 28, 2013 11:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I got ratings for the first two, but NA for the third. If you got "Error"
returned, it was probably a temporary issue with MSN?

On Sun, Apr 28, 2013 at 9:27 PM, zbgb952 <mb0329@msn.com> wrote:

> Anyone know why there are no MSN stock scouter ratings for all these
> stocks, all of which are midstream MLPs?
>
> ATLS
> BKEP
> BPL
> CMLP
> CQP
> DPM
> EEP
> ENB
> epd
> EROC
> ETE
> etp
> GEL
> HEP
> KMI
> KMP
> MMLP
> MWE
> NGLS
> NRGM
> NS
> OILT
> OKE
> OKS
> PBA
> RGP
> SE
> SXL
> TCP
> TLLP
> TLP
> TRP
> WES
> WPZ
>
>
> MSN does have a rating for a very few midstream mlp's like mmp, but all
> the others above return an error message. What gives?
>
>

Sun Apr 28, 2013 11:35 pm (PDT) . Posted by:

"aviadmfi" aviadmfi

Hi people,

I need to read an option last price from Yahoo Finance. I'm trying something like http://download.finance.yahoo.com/d/quotes.csv?f=sl1c4p0&amp;s=bac140118c00012000 but it retrun a price of '0' (for stocks it work).

Does anyone know how to fix that?

Thanks!
Avi

Tidak ada komentar:

Posting Komentar