15 New Messages
Digest #2944
2d
Re: Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table? by "Randy Harmelink" rharmelink
Messages
Mon Jan 27, 2014 1:33 am (PST) . Posted by:
andrewhills97
Thanks Randy, much appreciated.
I'm listing about 12 stock codes down column A (ie my portfolio) and would like to use this function to tell me the date (and description if possible) of the next "Upcoming Event". When I enter that RCH function as an array it requires 4 cells for each company, ie the headings are included each time.
Is there a cleaner way to bring into Excel the date and description of the next upcoming event in 1 row?
I'm listing about 12 stock codes down column A (ie my portfolio) and would like to use this function to tell me the date (and description if possible) of the next "Upcoming Event". When I enter that RCH function as an array it requires 4 cells for each company, ie the headings are included each time.
Is there a cleaner way to bring into Excel the date and description of the next upcoming event in 1 row?
Mon Jan 27, 2014 6:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
=RCHGetTableCell("http://au.finance.yahoo.com/q/ce?s=WSM",1,">Event",,,,1)
On Mon, Jan 27, 2014 at 2:33 AM, <andrewhills97@yahoo.com> wrote:
> I'm listing about 12 stock codes down column A (ie my portfolio) and
> would like to use this function to tell me the date (and description if
> possible) of the next "Upcoming Event". When I enter that RCH function as
> an array it requires 4 cells for each company, ie the headings are included
> each time.
>
> Is there a cleaner way to bring into Excel the date and description of the
> next upcoming event in 1 row?
>
=RCHGetTableCell(
On Mon, Jan 27, 2014 at 2:33 AM, <andrewhills97@
> I'm listing about 12 stock codes down column A (ie my portfolio) and
> would like to use this function to tell me the date (and description if
> possible) of the next "Upcoming Event". When I enter that RCH function as
> an array it requires 4 cells for each company, ie the headings are included
> each time.
>
> Is there a cleaner way to bring into Excel the date and description of the
> next upcoming event in 1 row?
>
Mon Jan 27, 2014 11:35 am (PST) . Posted by:
andrewhills97
thanks again Randy.
Mon Jan 27, 2014 5:11 am (PST) . Posted by:
Charles8839
I down loaded the zip file, went to add-ons, and did everything that was described in the Seeking Alpha blog.
A2 = JNJ
B2=RchGetElementNum
B2 =Undefined (this is the message I get
I'm using Office 2013, any suggestions
Mon Jan 27, 2014 6:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
"Undefined" means you didn't unzip all of the files in the ZIP archive into
the same folder as the XLA file. The "smf-elements-*.txt" files contain the
element definitions. If they aren't in that folder, no element definitions
ever get loaded.
Note that you may want to pick up some of the updated element definitions
from the "Works in Progress" folder. A lot of elements have been redefined
since the last official release of the add-in.
On Mon, Jan 27, 2014 at 6:11 AM, <charles.coker@cokersoft.com> wrote:
> I down loaded the zip file, went to add-ons, and did everything that was
> described in the Seeking Alpha blog.
>
> A2 = JNJ
>
> B2=RchGetElementNumber(A2, 63)
>
> B2 =Undefined (this is the message I get
>
> I'm using Office 2013, any suggestions
>
the same folder as the XLA file. The "smf-elements-
element definitions. If they aren't in that folder, no element definitions
ever get loaded.
Note that you may want to pick up some of the updated element definitions
from the "Works in Progress" folder. A lot of elements have been redefined
since the last official release of the add-in.
On Mon, Jan 27, 2014 at 6:11 AM, <charles.coker@
> I down loaded the zip file, went to add-ons, and did everything that was
> described in the Seeking Alpha blog.
>
> A2 = JNJ
>
> B2=RchGetElementNum
>
> B2 =Undefined (this is the message I get
>
> I'm using Office 2013, any suggestions
>
Mon Jan 27, 2014 9:41 am (PST) . Posted by:
"Marc ." whichwaytobeach
Hello Randy,
Is there a book or Online Tutorial on how to set up the RCH Get Elements table that you have done?
Regards,
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Mon, 27 Jan 2014 07:48:21 -0700
Subject: Re: [smf_addin] What does undefined mean
"Undefined" means you didn't unzip all of the files in the ZIP archive into the same folder as the XLA file. The "smf-elements-*.txt" files contain the element definitions. If they aren't in that folder, no element definitions ever get loaded.
Note that you may want to pick up some of the updated element definitions from the "Works in Progress" folder. A lot of elements have been redefined since the last official release of the add-in.
On Mon, Jan 27, 2014 at 6:11 AM, <charles.coker@cokersoft.com> wrote:
I down loaded the zip file, went to add-ons, and did everything that was described in the Seeking Alpha blog.
A2 = JNJ
B2=RchGetElementNumber(A2, 63)
B2 =Undefined (this is the message I get
I'm using Office 2013, any suggestions
Is there a book or Online Tutorial on how to set up the RCH Get Elements table that you have done?
Regards,
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Mon, 27 Jan 2014 07:48:21 -0700
Subject: Re: [smf_addin] What does undefined mean
"Undefined&quo
Note that you may want to pick up some of the updated element definitions from the "Works in Progress" folder. A lot of elements have been redefined since the last official release of the add-in.
On Mon, Jan 27, 2014 at 6:11 AM, <charles.coker@
I down loaded the zip file, went to add-ons, and did everything that was described in the Seeking Alpha blog.
A2 = JNJ
B2=RchGetElementNum
B2 =Undefined (this is the message I get
I'm using Office 2013, any suggestions
Mon Jan 27, 2014 4:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You're asking how to create your own elements, right? If so, nothing formal
has been written up. The easiest process right now:
-- The add-in loads element definitions from files "smf-element-0.txt" thru
"smf-element-20.txt". I would suggest not modifying any existing files.
Best process would be to create new files #19 and #20. Since they are
loaded last, they will override any previously loaded definitions (in case
you are redefining something).
-- In its simplest form, an element definition is just four things,
separated by a semi-colon:
#;source;name;formula
where:
"#" is the index for all element definitions. It can be anything
from 1 to 20000.
"source" can be whatever you want. I try to use a unique group name for
all elements coming from the same
web page. It is informational only, and not critical to
anything.
"name" is the name of the element, and can be whatever you want.
It is informational only, and not critical to anything.
"formula" can be the add-in formula you use in a worksheet cell, except
that five tildas (i.e. "~~~~~") should
be where you want the "Ticker" parameter from the
RCHGetElementNumber() formula to be placed.
For example, suppose I had this formula retrieving the 20-day volume for
ticker MMM from website stockscores.com:
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20
Day Avg Vol")
I could define an element number by adding an element number, the name of
the source, the name of the element, and then the formula (changing the
ticker symbol to "~~~~~").
785;StockScores;20 Day Avg Vol;=RCHGetTableCell("
http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg Vol")
Once loaded, this formula would be the equivalent of the original formula:
=RCHGetElementNumber("MMM";,785)
If that's not what you are asking, let me know.
On Mon, Jan 27, 2014 at 10:41 AM, Marc . <WHICHWAYTOBEACH@hotmail.com>wrote:
>
> Is there a book or Online Tutorial on how to set up the RCH Get Elements
> table that you have done?
>
>
has been written up. The easiest process right now:
-- The add-in loads element definitions from files "smf-element-
"smf-element-
Best process would be to create new files #19 and #20. Since they are
loaded last, they will override any previously loaded definitions (in case
you are redefining something).
-- In its simplest form, an element definition is just four things,
separated by a semi-colon:
#;source;name;
where:
"#" is the index for all element definitions. It can be anything
from 1 to 20000.
"source" can be whatever you want. I try to use a unique group name for
all elements coming from the same
web page. It is informational only, and not critical to
anything.
"name" is the name of the element, and can be whatever you want.
It is informational only, and not critical to anything.
"formula" can be the add-in formula you use in a worksheet cell, except
that five tildas (i.e. "~~~~~"
be where you want the "Ticker" parameter from the
RCHGetElementNumber
For example, suppose I had this formula retrieving the 20-day volume for
ticker MMM from website stockscores.
=RCHGetTableCell(
Day Avg Vol")
I could define an element number by adding an element number, the name of
the source, the name of the element, and then the formula (changing the
ticker symbol to "~~~~~"
785;StockScores;
http://www.stocksco
Once loaded, this formula would be the equivalent of the original formula:
=RCHGetElementNumbe
If that's not what you are asking, let me know.
On Mon, Jan 27, 2014 at 10:41 AM, Marc . <WHICHWAYTOBEACH@
>
> Is there a book or Online Tutorial on how to set up the RCH Get Elements
> table that you have done?
>
>
Mon Jan 27, 2014 4:45 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Hello Randy,
Yes, that is what I was asking about.
I will try out what you say below.
Regards & Thanks for responding!
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Mon, 27 Jan 2014 17:12:02 -0700
Subject: Re: [smf_addin] Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table?
You're asking how to create your own elements, right? If so, nothing formal has been written up. The easiest process right now:
-- The add-in loads element definitions from files "smf-element-0.txt" thru "smf-element-20.txt". I would suggest not modifying any existing files. Best process would be to create new files #19 and #20. Since they are loaded last, they will override any previously loaded definitions (in case you are redefining something).
-- In its simplest form, an element definition is just four things, separated by a semi-colon:
#;source;name;formula
where:
"#" is the index for all element definitions. It can be anything from 1 to 20000.
"source" can be whatever you want. I try to use a unique group name for all elements coming from the same
web page. It is informational only, and not critical to anything.
"name" is the name of the element, and can be whatever you want.
It is informational only, and not critical to anything.
"formula" can be the add-in formula you use in a worksheet cell, except that five tildas (i.e. "~~~~~") should
be where you want the "Ticker" parameter from the RCHGetElementNumber() formula to be placed.
For example, suppose I had this formula retrieving the 20-day volume for ticker MMM from website stockscores.com:
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol")
I could define an element number by adding an element number, the name of the source, the name of the element, and then the formula (changing the ticker symbol to "~~~~~").
785;StockScores;20 Day Avg Vol;=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg Vol")
Once loaded, this formula would be the equivalent of the original formula:
=RCHGetElementNumber("MMM";,785)
If that's not what you are asking, let me know.
On Mon, Jan 27, 2014 at 10:41 AM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:
Is there a book or Online Tutorial on how to set up the RCH Get Elements table that you have done?
Yes, that is what I was asking about.
I will try out what you say below.
Regards & Thanks for responding!
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Mon, 27 Jan 2014 17:12:02 -0700
Subject: Re: [smf_addin] Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table?
You're asking how to create your own elements, right? If so, nothing formal has been written up. The easiest process right now:
-- The add-in loads element definitions from files "smf-element-
-- In its simplest form, an element definition is just four things, separated by a semi-colon:
#;source;name;
where:
"#" is the index for all element definitions. It can be anything from 1 to 20000.
"source" can be whatever you want. I try to use a unique group name for all elements coming from the same
web page. It is informational only, and not critical to anything.
"name" is the name of the element, and can be whatever you want.
It is informational only, and not critical to anything.
"formula" can be the add-in formula you use in a worksheet cell, except that five tildas (i.e. "~~~~~"
be where you want the "Ticker" parameter from the RCHGetElementNumber
For example, suppose I had this formula retrieving the 20-day volume for ticker MMM from website stockscores.
=RCHGetTableCell(
I could define an element number by adding an element number, the name of the source, the name of the element, and then the formula (changing the ticker symbol to "~~~~~"
785;StockScores;
Once loaded, this formula would be the equivalent of the original formula:
=RCHGetElementNumbe
If that's not what you are asking, let me know.
On Mon, Jan 27, 2014 at 10:41 AM, Marc . <WHICHWAYTOBEACH@
Is there a book or Online Tutorial on how to set up the RCH Get Elements table that you have done?
Mon Jan 27, 2014 11:02 am (PST) . Posted by:
petekoch
I did something similar in Morningstar_Financials_Example.xlsx which can be found in 'Uploads by forum members' in the Files section. Rather than GetYahooHistory, this sheet uses smfGetCSVFile, which I have found to be much faster. The area at the very top 'extracts' data from Key Ratios, the Income Sheet, Balance Sheet and Cash Flow Statement, using the Index and Match Excel functions in a compound formula.
The caveat, of course, is that one must be a Morningstar member in order to get the full 10 years of data. I hope this helps.
The caveat, of course, is that one must be a Morningstar member in order to get the full 10 years of data. I hope this helps.
Mon Jan 27, 2014 4:22 pm (PST) . Posted by:
freefaller6
Hi Randy, first - thanks again for your continued support of this site. It's simply amazing.
My question - I am getting "Error" for element #13878, Zack's Earnings per Share (TTM). All other elements seem to be working.
I have the 10/17/2013 add-in installed, running Excel 2013, Win 7.
Suggestions? If I can't pull the value directly, is there a way to calculate it with other elements?
Thanks,
Brent
My question - I am getting "Error" for element #13878, Zack's Earnings per Share (TTM). All other elements seem to be working.
I have the 10/17/2013 add-in installed, running Excel 2013, Win 7.
Suggestions? If I can't pull the value directly, is there a way to calculate it with other elements?
Thanks,
Brent
Mon Jan 27, 2014 4:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Exit and restart EXCEL. What do you get in a new workbook with:
=RCHGetElementNumber("MMM";,13878)
=RCHGetElementNumber("Version")
=smfGetAParms(13878)
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates
",1,">EPS(TTM)")
They don't have the pieces, to allow you to compute it yourself.
On Mon, Jan 27, 2014 at 5:22 PM, <freefaller6@yahoo.com> wrote:
>
> My question - I am getting "Error" for element #13878, Zack's Earnings per
> Share (TTM). All other elements seem to be working.
>
> I have the 10/17/2013 add-in installed, running Excel 2013, Win 7.
>
> Suggestions? If I can't pull the value directly, is there a way to
> calculate it with other elements?
>
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetTableCell(
",1,"
They don't have the pieces, to allow you to compute it yourself.
On Mon, Jan 27, 2014 at 5:22 PM, <freefaller6@
>
> My question - I am getting "Error" for element #13878, Zack's Earnings per
> Share (TTM). All other elements seem to be working.
>
> I have the 10/17/2013 add-in installed, running Excel 2013, Win 7.
>
> Suggestions? If I can't pull the value directly, is there a way to
> calculate it with other elements?
>
Mon Jan 27, 2014 5:37 pm (PST) . Posted by:
freefaller6
Hi Randy, thanks. Here's what I get:
Exit and restart EXCEL. What do you get in a new workbook with:
=RCHGetElementNumber("MMM";,13878) = Error
=RCHGetElementNumber("Version") = Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program Files (x86)\SMF Yahoo; www; 1)
=smfGetAParms(13878) = Zacks;Earning per Share (TTM);=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~",1,">EPS TTM<")
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,">EPS(TTM)") = 39.63, when using aapl as an example. The actual value is 39.75, so it's close, but not quite there.
Again, using aapl as an example, if I divide the price by the P/E (ttm), I do get 39.75. While not ideal, I could set up a formula for Price / [P/E (ttm)] = EPS (ttm), or RCHElements 13626/Price???
What happened to the price? The MSN Price, element 25?
Exit and restart EXCEL. What do you get in a new workbook with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetTableCell(
Again, using aapl as an example, if I divide the price by the P/E (ttm), I do get 39.75. While not ideal, I could set up a formula for Price / [P/E (ttm)] = EPS (ttm), or RCHElements 13626/Price?
What happened to the price? The MSN Price, element 25?
Mon Jan 27, 2014 6:16 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You've got the old Zacks element definitions. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
I obsoleted element #25 because MSN has been posting the previous day's
closing price as "Last Price" ever since they redid the stock print page
last year. I suggest the RCHGetYahooQuotes() function for quotes.
On Mon, Jan 27, 2014 at 6:37 PM, <freefaller6@yahoo.com> wrote:
> Exit and restart EXCEL. What do you get in a new workbook with:
>
> =RCHGetElementNumber("MMM";,13878) = Error
>
> =RCHGetElementNumber("Version") = Stock Market Functions add-in, Version
> 2.1.2013.10.17 (C:\Program Files (x86)\SMF Yahoo; www; 1)
>
> =smfGetAParms(13878) = Zacks;Earning per Share (TTM);=RCHGetTableCell("
> http://www.zacks.com/stock/quote/~~~~~",1,">EPS TTM<")
>
> =RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,">EPS(TTM)")
> = 39.63, when using aapl as an example. The actual value is 39.75, so it's
> close, but not quite there.
>
> Again, using aapl as an example, if I divide the price by the P/E (ttm), I
> do get 39.75. While not ideal, I could set up a formula for Price / [P/E
> (ttm)] = EPS (ttm), or RCHElements 13626/Price???
>
> What happened to the price? The MSN Price, element 25?
>
https://groups.
I obsoleted element #25 because MSN has been posting the previous day's
closing price as "Last Price" ever since they redid the stock print page
last year. I suggest the RCHGetYahooQuotes(
On Mon, Jan 27, 2014 at 6:37 PM, <freefaller6@
> Exit and restart EXCEL. What do you get in a new workbook with:
>
> =RCHGetElementNumbe
>
> =RCHGetElementNumbe
> 2.1.2013.10.
>
> =smfGetAParms(
> http://www.zacks.
>
> =RCHGetTableCell(
> = 39.63, when using aapl as an example. The actual value is 39.75, so it's
> close, but not quite there.
>
> Again, using aapl as an example, if I divide the price by the P/E (ttm), I
> do get 39.75. While not ideal, I could set up a formula for Price / [P/E
> (ttm)] = EPS (ttm), or RCHElements 13626/Price?
>
> What happened to the price? The MSN Price, element 25?
>
Mon Jan 27, 2014 6:22 pm (PST) . Posted by:
mikemcq802
Adding on to Randy's comments ... The reason you see 39.63 for AAPL EPS(TTM) is because that is what Zacks says it is. Just go to their page:
http://www.zacks.com/stock/quote/aapl/detailed-estimates
That's the page that SMF is extracting the data from - it's the one identified in the RCHGetTableCell parameters.
http://www.zacks.
That's the page that SMF is extracting the data from - it's the one identified in the RCHGetTableCell parameters.
Mon Jan 27, 2014 6:17 pm (PST) . Posted by:
herkshirebathaway
Hi Randy,
I have successfully got together a script that will login to the GF website automatically. Thank you for your pointers.
I'm now putting together a GuruFocus model which I will upload when I have finished.
Gurufocus offers very complete dataset for any stock which can be downloaded at the following URL http://www.gurufocus.com/download_dataset.php?symbol=ASX:SHV .
The file is in .XLS format. Is the SMF addin capable of importing such a file directly from the web?
Thank you for your time Randy, very excited about this project.
I have successfully got together a script that will login to the GF website automatically. Thank you for your pointers.
I'm now putting together a GuruFocus model which I will upload when I have finished.
Gurufocus offers very complete dataset for any stock which can be downloaded at the following URL http://www.gurufocu
The file is in .XLS format. Is the SMF addin capable of importing such a file directly from the web?
Thank you for your time Randy, very excited about this project.
Tidak ada komentar:
Posting Komentar