14 New Messages
Digest #2801
Messages
Tue Oct 8, 2013 6:01 am (PDT) . Posted by:
weekeewawa
hello randy,
is the code =smfStrExtr("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"add_ticker")
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Use the smfStrExtr() function, as we've done before...
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@... mailto:weekeewawa@...> wrote:
when i extract the price data for IBM using the code below =smfGetTagContent("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"add_ticker")
the result shows 182.100 <Span> USD
is there a way to just display 182.100?
is the code =smfStrExtr(
---In smf_addin@yahoogrou
Use the smfStrExtr() function, as we've done before...
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@
when i extract the price data for IBM using the code below =smfGetTagContent(
the result shows 182.100 <Span> USD
is there a way to just display 182.100?
Tue Oct 8, 2013 6:12 am (PDT) . Posted by:
weekeewawa
what i saw the code for ibm is
<h3 class="">IBM:US </h3>
<span class=" price"> 182.0100 <span> USD</span> </span>
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
You didn't look at the source code of the web page, did you? None of the things you want are in tables.
Try:
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"Sub-Industry")
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","h2",1,"ticker_header")
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"add_ticker")
Your URL was bad as well. The ticker symbols needs the ":US" suffix on it. That last item needs to be parsed to get out the specific data your want. I'll leave that to you.
On Mon, Oct 7, 2013 at 7:43 AM, <weekeewawa@... mailto:weekeewawa@...> wrote:
how do i extract certain data from bloomberg using rchgettablecell?
tried using the code below but the data just does not point to what i want
=RCHGetTableCell("http://www.bloomberg.com/quote/ http://www.bloomberg.com/quote/"&A1&"",1,"Sub-Industry")
i want to get data for example
1) Sub-Industry (IT Services)
2) price of the stock (182.8720 USD)
3) name of the stock (International Business Machines Corp)
<h3 class="
<span class=" price"> 182.0100 <span> USD</span> </span>
---In smf_addin@yahoogrou
You didn't look at the source code of the web page, did you? None of the things you want are in tables.
Try:
=smfGetTagContent(
=smfGetTagContent(
=smfGetTagContent(
Your URL was bad as well. The ticker symbols needs the ":US" suffix on it. That last item needs to be parsed to get out the specific data your want. I'll leave that to you.
On Mon, Oct 7, 2013 at 7:43 AM, <weekeewawa@
how do i extract certain data from bloomberg using rchgettablecell?
tried using the code below but the data just does not point to what i want
=RCHGetTableCell(
i want to get data for example
1) Sub-Industry (IT Services)
2) price of the stock (182.8720 USD)
3) name of the stock (International Business Machines Corp)
Tue Oct 8, 2013 6:13 am (PDT) . Posted by:
weekeewawa
hello randy,
is the code =smfStrExtr("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"add_ticker")
?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Use the smfStrExtr() function, as we've done before...
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@... mailto:weekeewawa@...> wrote:
when i extract the price data for IBM using the code below =smfGetTagContent("http://www.bloomberg.com/quote/IBM:US http://www.bloomberg.com/quote/IBM:US","span",1,"add_ticker")
the result shows 182.100 <Span> USD
is there a way to just display 182.100?
is the code =smfStrExtr(
?
---In smf_addin@yahoogrou
Use the smfStrExtr() function, as we've done before...
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@
when i extract the price data for IBM using the code below =smfGetTagContent(
the result shows 182.100 <Span> USD
is there a way to just display 182.100?
Tue Oct 8, 2013 8:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you even bother to read the documentation on smfStrExtr()?
The string you want to extract data from is the first function results of:
"182.100 <Span> USD"
On Tue, Oct 8, 2013 at 5:59 AM, <weekeewawa@yahoo.com> wrote:
>
> is the code =smfStrExtr("http://www.bloomberg.com/quote/IBM:US
> ","span",1,"add_ticker")
>
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
>
> Use the smfStrExtr() function, as we've done before...
>
> On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@...> wrote:
>
> when i extract the price data for IBM using the code below
>
> =smfGetTagContent("http://www.bloomberg.com/quote/IBM:US
> ","span",1,"add_ticker")
>
> the result shows 182.100 <Span> USD
>
> is there a way to just display 182.100?
>
>
The string you want to extract data from is the first function results of:
"182.100 <Span> USD"
On Tue, Oct 8, 2013 at 5:59 AM, <weekeewawa@yahoo.
>
> is the code =smfStrExtr(
> ","
>
> ---In smf_addin@yahoogrou
>
> Use the smfStrExtr() function, as we've done before...
>
> On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@
>
> when i extract the price data for IBM using the code below
>
> =smfGetTagContent(
> ","
>
> the result shows 182.100 <Span> USD
>
> is there a way to just display 182.100?
>
>
Tue Oct 8, 2013 12:29 pm (PDT) . Posted by:
ppasha1129
Thank you Randy, I will certainly look at the document. What you guys are doing here is simply amazing.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Go over the documentation and try a few things. There are examples in each function's documentation.
And if you have trouble after trying a few things, just mention it here and I'll (or we'll) try and get you on the right path.
One workbook you may want to use when playing around with things:
smfGetTagContent-Quick-Webpage-Examination.xls
Although I originally set it up as a template for smfGetTagContent, I added templates for some of the basic functions in other worksheets, so that someone can modify the various parameters and see what the result might be.
I often use it when looking at an extraction from a new web page.
On Tue, Oct 1, 2013 at 6:24 PM, <ppasha1129@... mailto:ppasha1129@...> wrote:
Is there a way to learn how to generate links like the one you provided? I am asking this because I am building a complex model. I also asked a computer science professor today, and he wasn't able to help me. I would like to be able to edit my links, if morningstar changed its interface. We actually talked about the SMF community and how generous some members (like yourself) are here.
---In smf_addin@yahoogrou
Go over the documentation and try a few things. There are examples in each function'
And if you have trouble after trying a few things, just mention it here and I'll (or we'll) try and get you on the right path.
One workbook you may want to use when playing around with things:
smfGetTagContent-
Although I originally set it up as a template for smfGetTagContent, I added templates for some of the basic functions in other worksheets, so that someone can modify the various parameters and see what the result might be.
I often use it when looking at an extraction from a new web page.
On Tue, Oct 1, 2013 at 6:24 PM, <ppasha1129@
Is there a way to learn how to generate links like the one you provided? I am asking this because I am building a complex model. I also asked a computer science professor today, and he wasn't able to help me. I would like to be able to edit my links, if morningstar changed its interface. We actually talked about the SMF community and how generous some members (like yourself) are here.
Tue Oct 8, 2013 12:39 pm (PDT) . Posted by:
stephen.ronson@ymail.com
The add in is GREAT! I've read that I can't get Expense ratios for ETFs ... has this changed?
Also all of the Vanguard Funds ERs are showing up great except Vanguard Target Date 2045 VTIVX. The 1 year return is showing up for me but the Expense ratio is showing up as 0.00 while the same equation using 5079 for all the other funds is working fine (I also tried 5086)
Also all of the Vanguard Funds ERs are showing up great except Vanguard Target Date 2045 VTIVX. The 1 year return is showing up for me but the Expense ratio is showing up as 0.00 while the same equation using 5079 for all the other funds is working fine (I also tried 5086)
Tue Oct 8, 2013 1:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
0.0% is what Yahoo has posted for the VITVX expense ratio:
http://finance.yahoo.com/q/pr?s=VTIVX
ETF expense ratios are carried differently than the mutual funds. You can
get them with:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s="&Ticker,1,"Annual Report
Expense Ratio")
On Tue, Oct 8, 2013 at 11:47 AM, <stephen.ronson@gmail.com> wrote:
>
> The add in is GREAT! I've read that I can't get Expense ratios for ETFs
> ... has this changed?
>
> Also all of the Vanguard Funds ERs are showing up great except Vanguard
> Target Date 2045 VTIVX. The 1 year return is showing up for me but the
> Expense ratio is showing up as 0.00 while the same equation using 5079 for
> all the other funds is working fine (I also tried 5086)
>
http://finance.
ETF expense ratios are carried differently than the mutual funds. You can
get them with:
=RCHGetTableCell(
Expense Ratio")
On Tue, Oct 8, 2013 at 11:47 AM, <stephen.ronson@
>
> The add in is GREAT! I've read that I can't get Expense ratios for ETFs
> ... has this changed?
>
> Also all of the Vanguard Funds ERs are showing up great except Vanguard
> Target Date 2045 VTIVX. The 1 year return is showing up for me but the
> Expense ratio is showing up as 0.00 while the same equation using 5079 for
> all the other funds is working fine (I also tried 5086)
>
Tue Oct 8, 2013 2:45 pm (PDT) . Posted by:
"Steve Meyer" socal_steve
Thank you Randy. I was expecting doc with the file and did not look into the other areas. I think I am on my way now.
I do have another question. I have been exploring Google Docs, primarily to share out our investment club portfolio and have a current accounting of our holdings to the members. I am pretty sure I cannot use an add-in with Google Docs so are you aware of any similar functionality? Right now was can pull certain criteria on a stock but I believe we are limited to Google Finance and also it is a bit sketchy as far as consistently populating the fields, i.e. sometimes we get a blank. Can you offer any information or other resources I can look into?
THank you again for your help and patients with an SMF noob.
Steve
Please consider the environment before printing this email or any attachments.
_________________________________________________
Steve Meyer
LinkedIn
Never mistake a clear view for a short distance.
On Oct 8, 2013, at 1:10 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
>
> 0.0% is what Yahoo has posted for the VITVX expense ratio:
>
> http://finance.yahoo.com/q/pr?s=VTIVX
>
> ETF expense ratios are carried differently than the mutual funds. You can get them with:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s="&Ticker,1,"Annual Report Expense Ratio")
>
>
> On Tue, Oct 8, 2013 at 11:47 AM, <stephen.ronson@gmail.com> wrote:
>
> The add in is GREAT! I've read that I can't get Expense ratios for ETFs ... has this changed?
>
> Also all of the Vanguard Funds ERs are showing up great except Vanguard Target Date 2045 VTIVX. The 1 year return is showing up for me but the Expense ratio is showing up as 0.00 while the same equation using 5079 for all the other funds is working fine (I also tried 5086)
>
>
>
I do have another question. I have been exploring Google Docs, primarily to share out our investment club portfolio and have a current accounting of our holdings to the members. I am pretty sure I cannot use an add-in with Google Docs so are you aware of any similar functionality? Right now was can pull certain criteria on a stock but I believe we are limited to Google Finance and also it is a bit sketchy as far as consistently populating the fields, i.e. sometimes we get a blank. Can you offer any information or other resources I can look into?
THank you again for your help and patients with an SMF noob.
Steve
Please consider the environment before printing this email or any attachments.
____________
Steve Meyer
Never mistake a clear view for a short distance.
On Oct 8, 2013, at 1:10 PM, Randy Harmelink <rharmelink@gmail.
>
> 0.0% is what Yahoo has posted for the VITVX expense ratio:
>
> http://finance.
>
> ETF expense ratios are carried differently than the mutual funds. You can get them with:
>
> =RCHGetTableCell(
>
>
> On Tue, Oct 8, 2013 at 11:47 AM, <stephen.ronson@
>
> The add in is GREAT! I've read that I can't get Expense ratios for ETFs ... has this changed?
>
> Also all of the Vanguard Funds ERs are showing up great except Vanguard Target Date 2045 VTIVX. The 1 year return is showing up for me but the Expense ratio is showing up as 0.00 while the same equation using 5079 for all the other funds is working fine (I also tried 5086)
>
>
>
Tue Oct 8, 2013 4:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Google has its own API to interface with the Internet. A good overview:
http://mashe.hawksey.info/2012/10/feeding-google-spreadsheets-exercises-in-import/
And a function to get specific financial items on stocks:
http://seekingalpha.com/article/568641-using-google-spreadsheet-as-your-watch-list
I don't use them much, though, so I can't say how accurate or reliable they
are.
Note that in the second link, he wrote his own add-on function to get
dividend -- using the Yahoo CSV file. :)
On Tue, Oct 8, 2013 at 2:45 PM, Steve Meyer <stevencmeyer@me.com> wrote:
>
> I do have another question. I have been exploring Google Docs, primarily
> to share out our investment club portfolio and have a current accounting of
> our holdings to the members. I am pretty sure I cannot use an add-in with
> Google Docs so are you aware of any similar functionality? Right now was
> can pull certain criteria on a stock but I believe we are limited to Google
> Finance and also it is a bit sketchy as far as consistently populating the
> fields, i.e. sometimes we get a blank. Can you offer any information or
> other resources I can look into?
>
http://mashe.
And a function to get specific financial items on stocks:
http://seekingalpha
I don't use them much, though, so I can't say how accurate or reliable they
are.
Note that in the second link, he wrote his own add-on function to get
dividend -- using the Yahoo CSV file. :)
On Tue, Oct 8, 2013 at 2:45 PM, Steve Meyer <stevencmeyer@
>
> I do have another question. I have been exploring Google Docs, primarily
> to share out our investment club portfolio and have a current accounting of
> our holdings to the members. I am pretty sure I cannot use an add-in with
> Google Docs so are you aware of any similar functionality? Right now was
> can pull certain criteria on a stock but I believe we are limited to Google
> Finance and also it is a bit sketchy as far as consistently populating the
> fields, i.e. sometimes we get a blank. Can you offer any information or
> other resources I can look into?
>
Tue Oct 8, 2013 1:11 pm (PDT) . Posted by:
socal_steve
I am trying to set up the RCHGetTableCell-Template-Options-CC-List-Returns.xls spreadsheet I obtained from the justcoveredcalls group. there is a note at the top linking to this group "Requires the SMF add-in -- click here to go to the Yahoo group." I have downloaded the only file (actually it is a directory) I can see available, RCH_Stock_Market_Functions-2, however I am not sure I understand how to proceed if this is the correct file. Would someone clarify the use or point me to where I can find the "correct add-in" or instructions on using the file. Thank you.
Tue Oct 8, 2013 1:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You have the correct file.
As the opening page to the group notes and the "Welcome to the group"
message state:
"The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. *Installation instructions and documentation of the
various functions can be found in the "Documentation" folder.* Sample uses
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."
On Tue, Oct 8, 2013 at 12:54 PM, <stevencmeyer@me.com> wrote:
>
> I am trying to set up
> the RCHGetTableCell-Template-Options-CC-List-Returns.xls spreadsheet I
> obtained from the justcoveredcalls group. there is a note at the top
> linking to this group "Requires the SMF add-in -- click here to go to the
> Yahoo group." I have downloaded the only file (actually it is a directory)
> I can see available, RCH_Stock_Market_Functions-2, however I am not sure
> I understand how to proceed if this is the correct file. Would someone
> clarify the use or point me to where I can find the "correct add-in" or
> instructions on using the file. Thank you.
>
As the opening page to the group notes and the "Welcome to the group"
message state:
"The first step to using the add-in would be to visit the files area of the
group. You can download a ZIP file from the "Add-In Files" folder that
contains the add-in. *Installation instructions and documentation of the
various functions can be found in the "Documentation
of add-in functions can be found in the "Templates and Examples" folder.
Also, be sure to check out the "Links" area of the group for links to tips
and frequently asked questions."
On Tue, Oct 8, 2013 at 12:54 PM, <stevencmeyer@
>
> I am trying to set up
> the RCHGetTableCell-
> obtained from the justcoveredcalls group. there is a note at the top
> linking to this group "Requires the SMF add-in -- click here to go to the
> Yahoo group." I have downloaded the only file (actually it is a directory)
> I can see available, RCH_Stock_Market_
> I understand how to proceed if this is the correct file. Would someone
> clarify the use or point me to where I can find the "correct add-in" or
> instructions on using the file. Thank you.
>
Tue Oct 8, 2013 1:54 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Go to this write-up done by a member. It is great for installing the SMF-Addin tool
http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of stevencmeyer@me.com
Sent: Tuesday, October 08, 2013 3:55 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] SMF add-in required
I am trying to set up the RCHGetTableCell-Template-Options-CC-List-Returns.xls spreadsheet I obtained from the justcoveredcalls group. there is a note at the top linking to this group "Requires the SMF add-in -- click here to go to the Yahoo group." I have downloaded the only file (actually it is a directory) I can see available, RCH_Stock_Market_Functions-2, however I am not sure I understand how to proceed if this is the correct file. Would someone clarify the use or point me to where I can find the "correct add-in" or instructions on using the file. Thank you.
http://seekingalpha
From: smf_addin@yahoogrou
Sent: Tuesday, October 08, 2013 3:55 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] SMF add-in required
I am trying to set up the RCHGetTableCell-
Tue Oct 8, 2013 8:25 pm (PDT) . Posted by:
dcharlotte99
I'm using the Gurufocus 10-yr spreadsheet created by one of the members here. The following data is not downloading from the website:
Investment for Property, Plant & Equipment Cash Flow from Acquisitions
These are rows 68 and 69 from the Cashflow statement. Anyone know why these 2 are not working? The formulas seem identical to the other rows.
Investment for Property, Plant & Equipment Cash Flow from Acquisitions
These are rows 68 and 69 from the Cashflow statement. Anyone know why these 2 are not working? The formulas seem identical to the other rows.
Tue Oct 8, 2013 10:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried the workbook with ticker MMM, and those lines worked fine here.
On Tue, Oct 8, 2013 at 8:25 PM, <dcharlotte99@yahoo.com> wrote:
>
> I'm using the Gurufocus 10-yr spreadsheet created by one of the members
> here. The following data is not downloading from the website:
>
> Investment for Property, Plant & Equipment Cash Flow from Acquisitions
>
> These are rows 68 and 69 from the Cashflow statement. Anyone know why
> these 2 are not working? The formulas seem identical to the other rows.
>
On Tue, Oct 8, 2013 at 8:25 PM, <dcharlotte99@
>
> I'm using the Gurufocus 10-yr spreadsheet created by one of the members
> here. The following data is not downloading from the website:
>
> Investment for Property, Plant & Equipment Cash Flow from Acquisitions
>
> These are rows 68 and 69 from the Cashflow statement. Anyone know why
> these 2 are not working? The formulas seem identical to the other rows.
>
Tidak ada komentar:
Posting Komentar