13 New Messages
Digest #2967
Messages
Fri Feb 14, 2014 8:43 am (PST) . Posted by:
"David Rossien" drrossien
With regard to converting PDFs to text, there are plenty of free/freemium
solutions out there but IMO you get what you pay (or not) for. Personally I
have had good experience with OmniPage by Nuance.
solutions out there but IMO you get what you pay (or not) for. Personally I
have had good experience with OmniPage by Nuance.
Fri Feb 14, 2014 8:52 am (PST) . Posted by:
"Marc ." whichwaytobeach
Hello Randy,
Thank you. I didn't catch this when going down the list. I will give them a whirl.
And, thank you to the others who have written; when I get some quiet time, I will learn the array method.
Grateful,
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Thank you. I didn't catch this when going down the list. I will give them a whirl.
And, thank you to the others who have written; when I get some quiet time, I will learn the array method.
Grateful,
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Fri Feb 14, 2014 9:30 am (PST) . Posted by:
elderbands
Hi: I'm Elder and I'm an investor but I'm not great with the computer. How
would I get on to see comparisons for dividends .What is the website?
Thank you,
_elderbands@aol.com_
(mailto:elderbands@aol.com)
In a message dated 2/14/2014 11:52:51 A.M. Eastern Standard Time,
WHICHWAYTOBEACH@HOTMAIL.COM writes:
Hello Randy,
Thank you. I didn't catch this when going down the list. I will give them
a whirl.
And, thank you to the others who have written; when I get some quiet time,
I will learn the array method.
Grateful,
Marc
____________________________________
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru
#5905...
Most people want dividends by calendar periods rather than fiscal periods.
They don't always line up the same, for comparisons between companies. And
getting them from the annual financials will always mean reporting delays
for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <_WHICHWAYTOBEACH@hotmail.com_
(mailto:WHICHWAYTOBEACH@hotmail.com) > wrote:
It be nice, as it is with so many other fundamental areas covered already,
that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 -
FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not
sure why there needs to be a struggle just to get the same thing for
Dividends. I do not see this in the listing.
would I get on to see comparisons for dividends .What is the website?
Thank you,
_elderbands@
(mailto:elderbands@aol.
In a message dated 2/14/2014 11:52:51 A.M. Eastern Standard Time,
WHICHWAYTOBEACH@
Hello Randy,
Thank you. I didn't catch this when going down the list. I will give them
a whirl.
And, thank you to the others who have written; when I get some quiet time,
I will learn the array method.
Grateful,
Marc
____________
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru
#5905...
Most people want dividends by calendar periods rather than fiscal periods.
They don't always line up the same, for comparisons between companies. And
getting them from the annual financials will always mean reporting delays
for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <_WHICHWAYTOBEACH@
(mailto:WHICHWAYTOBEACH@
It be nice, as it is with so many other fundamental areas covered already,
that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 -
FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not
sure why there needs to be a struggle just to get the same thing for
Dividends. I do not see this in the listing.
Fri Feb 14, 2014 10:31 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.com> wrote:
>
> Hi: I'm Elder and I'm an investor but I'm not great with the computer.
> How would I get on to see comparisons for dividends .What is the website?
> Thank you,
> elderbands@aol.com
>
>
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.
>
> Hi: I'm Elder and I'm an investor but I'm not great with the computer.
> How would I get on to see comparisons for dividends .What is the website?
> Thank you,
> elderbands@aol.
>
>
Fri Feb 14, 2014 2:59 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
If you want help on the group you need to explain yourself much better.
Randy will answer almost every question you ask if you provide clear information
The site I use are
dividend.com (Fee & Free) for me the FEE is worth it.
Dividata.com (Free)
Dividendchannel.com (Free)
Each of these sites has a rating system. Naturally they don't agree so it takes a little effort to compare them.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of elderbands@aol.com
Sent: Friday, February 14, 2014 12:31 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Hi: I'm Elder and I'm an investor but I'm not great with the computer. How would I get on to see comparisons for dividends .What is the website?
Thank you,
elderbands@aol.com
In a message dated 2/14/2014 11:52:51 A.M. Eastern Standard Time, WHICHWAYTOBEACH@HOTMAIL.COM writes:
Hello Randy,
Thank you. I didn't catch this when going down the list. I will give them a whirl.
And, thank you to the others who have written; when I get some quiet time, I will learn the array method.
Grateful,
Marc
_____
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Randy will answer almost every question you ask if you provide clear information
The site I use are
dividend.com (Fee & Free) for me the FEE is worth it.
Dividata.com (Free)
Dividendchannel.
Each of these sites has a rating system. Naturally they don't agree so it takes a little effort to compare them.
Kermit
From: smf_addin@yahoogrou
Sent: Friday, February 14, 2014 12:31 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Hi: I'm Elder and I'm an investor but I'm not great with the computer. How would I get on to see comparisons for dividends .What is the website?
Thank you,
elderbands@aol.
In a message dated 2/14/2014 11:52:51 A.M. Eastern Standard Time, WHICHWAYTOBEACH@
Hello Randy,
Thank you. I didn't catch this when going down the list. I will give them a whirl.
And, thank you to the others who have written; when I get some quiet time, I will learn the array method.
Grateful,
Marc
_____
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Fri Feb 14, 2014 5:17 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Works perfectly. Thanks, Randy.
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Thu, 13 Feb 2014 13:59:09 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
If you want them by fiscal years, you could try AdvFN elements #5896 thru #5905...
Most people want dividends by calendar periods rather than fiscal periods. They don't always line up the same, for comparisons between companies. And getting them from the annual financials will always mean reporting delays for the most recent period.
On Thu, Feb 13, 2014 at 12:52 PM, Marc . <WHICHWAYTOBEACH@
It be nice, as it is with so many other fundamental areas covered already, that Dividends was covered in the FY1-FY10 format.
For instance, I already pull in and graph, things like: EPS for FY1 - FY10, Book Value for FY1-FY10, Sales for FY1-FY10, ROE% for FY1-FY10, I am not sure why there needs to be a struggle just to get the same thing for Dividends. I do not see this in the listing.
Fri Feb 14, 2014 5:22 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as numbers and also a Histogram, I can send you the Excel piece that should work for you. Two things: Make sure you have Randy's SMF add-in, "added-in" to your Excel, and, tell me what cell letter & number (e.g. C3) you input the ticker symbol.
Regards,
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.com> wrote:
Hi: I'm Elder and I'm an investor but I'm not great with the
computer. How would I get on to see comparisons for dividends .What is the
website?
Thank you,
elderbands@aol.com
If you would like to see the last 10 years of annual dividends, both as numbers and also a Histogram, I can send you the Excel piece that should work for you. Two things: Make sure you have Randy's SMF add-in, "added-
Regards,
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.
Hi: I'm Elder and I'm an investor but I'm not great with the
computer. How would I get on to see comparisons for dividends .What is the
website?
Thank you,
elderbands@aol.
Fri Feb 14, 2014 7:52 pm (PST) . Posted by:
elderbands
Marc: Please tell me what you mean as if you are talking to a first grade
student. I am 84 yrs old and am a computer novice.What is Randy's SMF
add-in Excel piece
I also don't understand a cell letter that I have to input. I don't want
to be a burden to you so if if it is too much trouble I want to thank you
for replying to me.
elderbands
In a message dated 2/14/2014 8:22:09 P.M. Eastern Standard Time,
WHICHWAYTOBEACH@HOTMAIL.COM writes:
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as
numbers and also a Histogram, I can send you the Excel piece that should work
for you. Two things: Make sure you have Randy's SMF add-in, "added-in" to
your Excel, and, tell me what cell letter & number (e.g. C3) you input the
ticker symbol.
Regards,
Marc
____________________________________
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <_elderbands@aol.com_
(mailto:elderbands@aol.com) > wrote:
Hi: I'm Elder and I'm an investor but I'm not great with the computer. How
would I get on to see comparisons for dividends .What is the website?
Thank you,
_elderbands@aol.com_
(mailto:elderbands@aol.com)
student. I am 84 yrs old and am a computer novice.What is Randy's SMF
add-in Excel piece
I also don't understand a cell letter that I have to input. I don't want
to be a burden to you so if if it is too much trouble I want to thank you
for replying to me.
elderbands
In a message dated 2/14/2014 8:22:09 P.M. Eastern Standard Time,
WHICHWAYTOBEACH@
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as
numbers and also a Histogram, I can send you the Excel piece that should work
for you. Two things: Make sure you have Randy's SMF add-in, "added-
your Excel, and, tell me what cell letter & number (e.g. C3) you input the
ticker symbol.
Regards,
Marc
____________
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <_elderbands@
(mailto:elderbands@aol.
Hi: I'm Elder and I'm an investor but I'm not great with the computer. How
would I get on to see comparisons for dividends .What is the website?
Thank you,
_elderbands@
(mailto:elderbands@aol.
Fri Feb 14, 2014 7:54 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Marc - do you mind posting your spreadsheet in this foro?
Regards,
Jose L. Jacob
________________________________
From: Marc . <WHICHWAYTOBEACH@HOTMAIL.COM>
To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
Sent: Friday, February 14, 2014 8:22:00 PM
Subject: RE: [smf_addin] RE: Want to Make Dividend Histogram
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as numbers and also a Histogram, I can send you the Excel piece that should work for you. Two things: Make sure you have Randy's SMF add-in, "added-in" to your Excel, and, tell me what cell letter & number (e.g. C3) you input the ticker symbol.
Regards,
Marc
________________________________
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.com> wrote:
>
>Hi: I'm Elder and I'm an investor but I'm not great with the computer. How would I get on to see comparisons for dividends .What is the website?
>Thank you,
> elderbands@aol.com
>
Regards,
Jose L. Jacob
____________
From: Marc . <WHICHWAYTOBEACH@
To: "smf_addin@yahoogrou
Sent: Friday, February 14, 2014 8:22:00 PM
Subject: RE: [smf_addin] RE: Want to Make Dividend Histogram
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as numbers and also a Histogram, I can send you the Excel piece that should work for you. Two things: Make sure you have Randy's SMF add-in, "added-
Regards,
Marc
____________
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Fri, 14 Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.
>
>Hi: I'm Elder and I'm an investor but I'm not great with the computer. How would I get on to see comparisons for dividends .What is the website?
>Thank you,
> elderbands@aol.
>
Fri Feb 14, 2014 9:41 pm (PST) . Posted by:
whichwaytobeach
Hello!
I have done so. It is called "10 Year Annual Dividend Trend".
I hope that small example shows how easy it is to use Randy's table.
Regards,
Marc
I have done so. It is called "10 Year Annual Dividend Trend".
I hope that small example shows how easy it is to use Randy's table.
Regards,
Marc
Fri Feb 14, 2014 9:46 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Hello Elder,
I have made a small Excel spreadsheet in the FILES section of this user group. That should work for you, if you have Excel and have the SMF add-in you needed to have downloaded to your Excel program.
Here is a way to both get and place the SMF into your Excel spreadsheet; please follow this guy's instructions:
http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
Regards,
Marc
To: smf_addin@yahoogroups.com
From: elderbands@aol.com
Date: Fri, 14 Feb 2014 22:52:52 -0500
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Marc: Please tell me what you mean as if you are
talking to a first grade student. I am 84 yrs old and am
a computer novice.What is Randy's SMF
add-in Excel piece
I also don't understand a cell letter that I have to
input. I don't want to be a burden to you so if if it is too much trouble
I want to thank you for replying to me.
elderbands
In a message dated 2/14/2014 8:22:09 P.M. Eastern Standard Time,
WHICHWAYTOBEACH@HOTMAIL.COM writes:
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as
numbers and also a Histogram, I can send you the Excel piece that should work
for you. Two things: Make sure you have Randy's SMF add-in, "added-in" to your
Excel, and, tell me what cell letter & number (e.g. C3) you input the
ticker symbol.
Regards,
Marc
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Fri, 14
Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend
Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.com> wrote:
Hi: I'm Elder and I'm an investor but I'm not great with
the computer. How would I get on to see comparisons for dividends .What is
the website?
Thank you,
elderbands@aol.com
I have made a small Excel spreadsheet in the FILES section of this user group. That should work for you, if you have Excel and have the SMF add-in you needed to have downloaded to your Excel program.
Here is a way to both get and place the SMF into your Excel spreadsheet; please follow this guy's instructions:
http://seekingalpha
Regards,
Marc
To: smf_addin@yahoogrou
From: elderbands@aol.
Date: Fri, 14 Feb 2014 22:52:52 -0500
Subject: Re: [smf_addin] RE: Want to Make Dividend Histogram
Marc: Please tell me what you mean as if you are
talking to a first grade student. I am 84 yrs old and am
a computer novice.What is Randy's SMF
add-in Excel piece
I also don't understand a cell letter that I have to
input. I don't want to be a burden to you so if if it is too much trouble
I want to thank you for replying to me.
elderbands
In a message dated 2/14/2014 8:22:09 P.M. Eastern Standard Time,
WHICHWAYTOBEACH@
Hello Elder,
If you would like to see the last 10 years of annual dividends, both as
numbers and also a Histogram, I can send you the Excel piece that should work
for you. Two things: Make sure you have Randy's SMF add-in, "added-
Excel, and, tell me what cell letter & number (e.g. C3) you input the
ticker symbol.
Regards,
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Fri, 14
Feb 2014 11:31:39 -0700
Subject: Re: [smf_addin] RE: Want to Make Dividend
Histogram
Comparing between what and what?
On Fri, Feb 14, 2014 at 10:30 AM, <elderbands@aol.
Hi: I'm Elder and I'm an investor but I'm not great with
the computer. How would I get on to see comparisons for dividends .What is
the website?
Thank you,
elderbands@aol.
Fri Feb 14, 2014 1:25 pm (PST) . Posted by:
freefaller6
Hi Randy, this thread is a bit old, but I have a couple of questions:
1. How do you actually create the element number, i.e. what file would you save in it, R
RCHGetElementNumber-Element-Definitions?
2. Can the Element Name be anything you designate it to be?
3. How do you determine the formula for what for what you want to assign to a particular element number? For example, the stock scouter rating for aapl is currently a 9. How does that formula know to pick that number?
Thanks,
Brent
1. How do you actually create the element number, i.e. what file would you save in it, R
RCHGetElementNumber
2. Can the Element Name be anything you designate it to be?
3. How do you determine the formula for what for what you want to assign to a particular element number? For example, the stock scouter rating for aapl is currently a 9. How does that formula know to pick that number?
Thanks,
Brent
Fri Feb 14, 2014 2:11 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There is some additional information on element definitions in the
smf-elements-info.txt file that is contained within the ZIP archive. As
people ask me questions about element definitions, I try to update it so it
covers those topics. I attached a copy of what it looks like after
answering your questions. Some sections are verbatim. :)
On Fri, Feb 14, 2014 at 2:25 PM, <freefaller6@yahoo.com> wrote:
>
> Hi Randy, this thread is a bit old, but I have a couple of questions:
> 1. How do you actually create the element number, i.e. what file would
> you save in it, R
> RCHGetElementNumber-Element-Definitions?
>
The add-in loads element definitions from files smf-elements-0.txt thru
smf-elements-20.txt, in that order, if they exist. I'd suggest creating the
currently non-existing smf-elements-20.txt file for your own element
definitions. Otherwise, if you put them into an existing file, they would
get wiped out if you need to replace the file with a new update from me.
The #20 file will also be loaded last, so you can override and replace
other element definitions by just reusing the element number.
2. Can the Element Name be anything you designate it to be?
>
Yes. Source and element name are just for reference only.
> 3. How do you determine the formula for what for what you want to assign
> to a particular element number? For example, the stock scouter rating for
> aapl is currently a 9. How does that formula know to pick that number?
>
That all depends on how the web page is written. It may require a simple
formula, or some permutation of formulas, to extract the data. But once you
create that formula, it should be relatively simple to make an element
definition out of it.
For example, one way to get the Stock Scouter rating:
=smfConvertData(smfstrExtr(smfGetTagContent("
http://investing.money.msn.com/investments/stock-price?Symbol=AAPL","a",1,"Rating:"),"~","
out of"))
That could be easily converted into an element definition. Something like:
20000;MSN or whatever;StockScouter Rating or
whatever;=smfConvertData(smfstrExtr(smfGetTagContent("
http://investing.money.msn.com/investments/stock-price?Symbol=~~~~~","a",1,"Rating:"),"~","
out of"))
I just put an element number in front of it, gave it a source name, gave it
an element name, and then copied the formula, but changed the ticker symbol
to five tildas. All separated by semi-colons.
For my own purposes, I try to give all elements extracted from the same web
page a common source name, just so it's easy to see where everything is
coming from.
smf-elements-
people ask me questions about element definitions, I try to update it so it
covers those topics. I attached a copy of what it looks like after
answering your questions. Some sections are verbatim. :)
On Fri, Feb 14, 2014 at 2:25 PM, <freefaller6@
>
> Hi Randy, this thread is a bit old, but I have a couple of questions:
> 1. How do you actually create the element number, i.e. what file would
> you save in it, R
> RCHGetElementNumber
>
The add-in loads element definitions from files smf-elements-
smf-elements-
currently non-existing smf-elements-
definitions. Otherwise, if you put them into an existing file, they would
get wiped out if you need to replace the file with a new update from me.
The #20 file will also be loaded last, so you can override and replace
other element definitions by just reusing the element number.
2. Can the Element Name be anything you designate it to be?
>
Yes. Source and element name are just for reference only.
> 3. How do you determine the formula for what for what you want to assign
> to a particular element number? For example, the stock scouter rating for
> aapl is currently a 9. How does that formula know to pick that number?
>
That all depends on how the web page is written. It may require a simple
formula, or some permutation of formulas, to extract the data. But once you
create that formula, it should be relatively simple to make an element
definition out of it.
For example, one way to get the Stock Scouter rating:
=smfConvertData(
http://investing.
out of"))
That could be easily converted into an element definition. Something like:
20000;MSN or whatever;StockScout
whatever;=smfConver
http://investing.
out of"))
I just put an element number in front of it, gave it a source name, gave it
an element name, and then copied the formula, but changed the ticker symbol
to five tildas. All separated by semi-colons.
For my own purposes, I try to give all elements extracted from the same web
page a common source name, just so it's easy to see where everything is
coming from.
Attachments with this message:
1 of 1 File(s)
Tidak ada komentar:
Posting Komentar