Messages In This Digest (8 Messages)
- 1a.
- Re: Fair Value - Automated.xls From: osmangulseven@yahoo.com
- 2a.
- Re: Why does this formula produce an error From: NicholasDavid
- 2b.
- Re: Why does this formula produce an error From: Randy Harmelink
- 2c.
- Re: Why does this formula produce an error From: NicholasDavid
- 2d.
- Re: Why does this formula produce an error From: Randy Harmelink
- 3a.
- Re: Extracting data from Google Finance From: skml88
- 3b.
- Re: Extracting data from Google Finance From: Randy Harmelink
- 4.
- Free Cash Flow per Share From: Ron Spruell
Messages
- 1a.
-
Re: Fair Value - Automated.xls
Posted by: "osmangulseven@yahoo.com" osmangulseven@yahoo.com osmangulseven
Mon Oct 17, 2011 2:25 am (PDT)
You are right. It looks in much better shape after removing "$" signs. I was actually thinking about something like that, but could not figure it out. Let's see whether there will be any other improvements in soon future. I will upload an updated version once, we finalize the excel file.
--- In smf_addin@yahoogroups.com , "KailuaKid" <Gary.Hartling@...> wrote:
>
>
>
> This formula seems to work to get the corporate bond yield:
>
> =RCHGetTableCell("http://finance. yahoo.com/ ",1,"Corporate Bonds","20yr AAA")&"%"bonds/composite_ bond_rates
>
> If you take the "$" out of the formulas in the first 11 rows in Column "C" you can copy the formulas to the right to create more columns if you have more than 10 tickers in your portfolio and you want to compare them all at once.
>
> Thanks for a great spreadsheet!
> Gary H.
>
>
>
> --- In smf_addin@yahoogroups.com , osmangulseven@ wrote:
> >
> >
> >
> > --- In smf_addin@yahoogroups.com , "kiwi2y_98" <kiwi2y_98@> wrote:
> > >
> > > Great work!
> > > Question -- Are the exponents missing in the calculations,
> > > rows 23 thru 27, columns A thru J ?
> > > thanks again.
> > >
> >
> > No, they are not. The upper boundary includes the book value, and lower boundary does not. Nevertheless, there is a minor issue with the file. I should have automated the bond yields. It says 4.49% (30 yr AAA corporate bond yield) on the file, but that is static. Yahoo Finance has the data on corporate bond yields as well as treasuries:
> >
> > http://finance.yahoo.com/ bonds/composite_ bond_rates
> >
>
- 2a.
-
Re: Why does this formula produce an error
Posted by: "NicholasDavid" nicholasdavid@comcast.net dnicholas4967
Mon Oct 17, 2011 4:48 am (PDT)
Thanks Randy, but what does the greater sign ">" before market cap mean?
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Sunday, October 16, 2011 11:45:10 AM
Subject: Re: [smf_addin] Why does this formula produce an error
Because the "Market Cap (intraday) :" string is not in the source code of the web page. If you look at the web page, you'll notice it has a "5" tag on it for the footnotes. The actual source code for that table cell is:
<td class="yfnc_tablehead1" width="74%"> Market Cap (intraday)<font size="-1"><sup> 5</sup></ font>:</td>
...so you have a lot of data between "(intraday)" and ":".
What I use is:
=RCHGetTableCell(" http://finance. yahoo.com/ "&$A1,1,">Market Cap")q/ks?s=
On Sun, Oct 16, 2011 at 7:22 AM, David < nicholasdavid@comcast.net > wrote:
=RCHGetTableCell(" http://finance. yahoo.com/ "&$A1&"+Key+q/ks?s= Statistics" ,1,"Market Cap (intraday) :")
A1 is on the page that holds this formula
A1 =MCHP
- 2b.
-
Re: Why does this formula produce an error
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 17, 2011 10:10 am (PDT)
It's the end of the HTML tag prior to the "Market Cap" string. I find it
useful to use those from time to time because it can make the search string
unique. However, you can't just assume it will immediately precede -- you
need to look at the source code of the web page. For example, this was the
table cell contents, including the HTML tags:
<td class="yfnc_tablehead1" width="74%"* >Market Cap* (intraday)<font
size="-1"><sup>5</sup></ font>:</td>
On Mon, Oct 17, 2011 at 4:48 AM, NicholasDavid <nicholasdavid@comcast.net >wrote:
>
> Thanks Randy, but what does the greater sign ">" before market cap mean?
>
- 2c.
-
Re: Why does this formula produce an error
Posted by: "NicholasDavid" nicholasdavid@comcast.net dnicholas4967
Mon Oct 17, 2011 12:26 pm (PDT)
Thanks, and one last question. What do you have to do to see the html code? David
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Monday, October 17, 2011 12:10:33 PM
Subject: Re: [smf_addin] Why does this formula produce an error
It's the end of the HTML tag prior to the "Market Cap" string. I find it useful to use those from time to time because it can make the search string unique. However, you can't just assume it will immediately precede -- you need to look at the source code of the web page. For example, this was the table cell contents, including the HTML tags:
<td class="yfnc_tablehead1" width="74%" >Market Cap (intraday)<font size="-1"><sup> 5</sup></ font>:</td>
On Mon, Oct 17, 2011 at 4:48 AM, NicholasDavid < nicholasdavid@comcast.net > wrote:
Thanks Randy, but what does the greater sign ">" before market cap mean?
- 2d.
-
Re: Why does this formula produce an error
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 17, 2011 1:41 pm (PDT)
For me, using FireFox, I just do a right click on the web page. One of the
context menu items I get is "View Page Source". I'm pretty sure IE (and
other browsers) have a similar process. One advantage for me under FireFox
is that if the data I'm going after is within a frame on the web page, it
also allows me context menu items to view just the framed page, or the
source code of the framed page -- if the data being extracted is from that
framed page, you'd need its URL for the add-in functions.
On Mon, Oct 17, 2011 at 12:26 PM, NicholasDavid
<nicholasdavid@comcast.net >wrote:
>
> Thanks, and one last question. What do you have to do to see the html code?
> David
>
- 3a.
-
Re: Extracting data from Google Finance
Posted by: "skml88" skml88@gmail.com skml88
Mon Oct 17, 2011 7:31 pm (PDT)
Randy
I can't find the smfWord utility (along with others like smfJoin and smfConvertData). I am using the latest Version 2.1.2011.04. 03 of the add-in.
Is it a problem with my PC, or have these utilities been removed?
Thank you again for your wonderful work.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No. The data is within JavaScript. See:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/14738
> http://finance.groups.yahoo. com/group/ smf_addin/ message/8487
>
> On Sun, Oct 16, 2011 at 10:36 PM, skml88 <skml88@...> wrote:
>
> >
> > I would like to extract data from the Related Companies section of Google
> > Finance into a table. How can I do this? They don't seem to be located
> > within the usual tags.
> >
> > http://www.google.com/finance? q=aapl
> >
> > I would greaty appreciate your help. Thanks.
> >
>
- 3b.
-
Re: Extracting data from Google Finance
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Oct 17, 2011 7:44 pm (PDT)
smfWord() and smfJoin() should be in the 2.1.2011.04.03 version of the
add-in. They were added to the add-in on 2011-02-16, and are still there in
my version of the add-in. In general, you wouldn't use smfConvertData(), as
it is a utility routine for other add-in functions.
On Mon, Oct 17, 2011 at 7:31 PM, skml88 <skml88@gmail.com > wrote:
>
> I can't find the smfWord utility (along with others like smfJoin and
> smfConvertData). I am using the latest Version 2.1.2011.04. 03 of the add-in.
>
> Is it a problem with my PC, or have these utilities been removed?
>
- 4.
-
Free Cash Flow per Share
Posted by: "Ron Spruell" hashky@yahoo.com hashky
Mon Oct 17, 2011 9:15 pm (PDT)
Does anyone know of a reliable source of Free Cash Flow per share? I am interested in MLPs and REITs that depend on FCF/Share.
An example is NRGY (from ValueLine 9/9/2011 for the year 2011):
Cash Flow per Unit 1.55
Earnings per Unit 0.50
Dist. Decl'd per Unit 2.82
Capital Spending per Unit 0.90
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar