12 New Messages
Digest #2598
5b
Re: why no msn stockscouter rating for all these midstream mlp's ? 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?
> >
>
is it possible to extract data from the section Valuation History C
Price/Earnings
Price/Book
Price/Sales
Price/Cash Flow
on http://financials.
--- In smf_addin@yahoogrou
>
> 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.
>
> So, this appears to work, but the page is not a real HTML page, but one to
> be consumed by JavaScript:
>
> =RCHGetTableCell(
> http://financials.
> ",9,"
>
> On Tue, Nov 29, 2011 at 10:34 PM, Les S <dolce7ss@
>
> > I see, thanks. Any way to tap into the javascript of the main morningstar
> > page? http://financials.
> >
> > 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
>
generated, so no data is available to be extracted. You should be able to
get it from the print report though:
http://quicktake.
On Sun, Apr 28, 2013 at 6:57 AM, weekeewawa <weekeewawa@yahoo.
> 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.
>
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
> >
>
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@yahoogrou
>
> 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.
>
> On Sun, Apr 28, 2013 at 6:57 AM, 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.
> >
>
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
I am new to the group and am especially interested in the AdvFN quarterly data.
The function RCHGetElementNumber
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?
>
using it as well.
On Sun, Apr 28, 2013 at 4:54 AM, kcaisaacs <ken.isaacs@verizon.
>
> I am new to the group and am especially interested in the AdvFN quarterly
> data.
>
> The function RCHGetElementNumber
> 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
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)201220112010200
Diluted EPS1,971,852,
Price by dates from Yahoo
period low32,1528,9722,
period high39,8334,
period close35,9933,
not adjusted close36,2569,
My sheet at this moment
PE Close18,4037,
PE High20,2218,
PE Low16,3215,669,
Actual PE from Advfn
PE Close18,4191319,
PE High20,619,51320,
PE Low16,916,79,
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.
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.
>
>
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@
>
> 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.
> 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
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?
>
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.
<lm5585@sbcglobal.
>
> 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?
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?
>
>
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&s=bac140118c00012000 but it retrun a price of '0' (for stocks it work).
Does anyone know how to fix that?
Thanks!
Avi
I need to read an option last price from Yahoo Finance. I'm trying something like http://download.
Does anyone know how to fix that?
Thanks!
Avi
Tidak ada komentar:
Posting Komentar