11 New Messages
Digest #2946
Messages
Tue Jan 28, 2014 5:36 am (PST) . Posted by:
thelancour
Im trying to get the SGA % from the key ratios off morningstar. Link http://financials.morningstar.com/ratios/r.html?t=CLR®ion=usa&culture=en-US&ownerCountry=USA
Using the get element from 163 to 173 I keep getting errors? is it me or is morningstars page not cooperating?
Thanks.
Using the get element from 163 to 173 I keep getting errors? is it me or is morningstars page not cooperating?
Thanks.
Tue Jan 28, 2014 6:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Elements #163 to #173 are the average P/E data elements from MSN.
SGA% from MorningStar are elements #14080 thru 14090.
All of those work for me, so you probably just need to pick up the latest
element definitions from the "Works in Progress" folder. Both MSN and
MorningStar elements had to be redefined because of changes they had made
to their web pages.
On Tue, Jan 28, 2014 at 6:36 AM, <thelancour@yahoo.com> wrote:
>
> Im trying to get the SGA % from the key ratios off morningstar. Link
> http://financials.morningstar.com/ratios/r.html?t=CLR®ion=usa&culture=en-US&ownerCountry=USA
>
> Using the get element from 163 to 173 I keep getting errors? is it me or
> is morningstars page not cooperating?
>
SGA% from MorningStar are elements #14080 thru 14090.
All of those work for me, so you probably just need to pick up the latest
element definitions from the "Works in Progress" folder. Both MSN and
MorningStar elements had to be redefined because of changes they had made
to their web pages.
On Tue, Jan 28, 2014 at 6:36 AM, <thelancour@yahoo.
>
> Im trying to get the SGA % from the key ratios off morningstar. Link
> http://financials.
>
> Using the get element from 163 to 173 I keep getting errors? is it me or
> is morningstars page not cooperating?
>
Tue Jan 28, 2014 7:57 am (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy - I have the latest from the "Work in progress" folder. The Elements-Definitions file that I have is 2013-11-5, in the file, elements 14080 thru 14090 are crossed out, and I get Error using SMF-Template-Morningstar-Key-Ratios.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 28, 2014 9:52:50 AM
Subject: Re: [smf_addin] Morningstar quotes still possible?
Elements #163 to #173 are the average P/E data elements from MSN.
SGA% from MorningStar are elements #14080 thru 14090.
All of those work for me, so you probably just need to pick up the latest element definitions from the "Works in Progress" folder. Both MSN and MorningStar elements had to be redefined because of changes they had made to their web pages.
On Tue, Jan 28, 2014 at 6:36 AM, <thelancour@yahoo.com> wrote:
>Im trying to get the SGA % from the key ratios off morningstar. Link http://financials.morningstar.com/ratios/r.html?t=CLR®ion=usa&culture=en-US&ownerCountry=USA
>Using the get element from 163 to 173 I keep getting errors? is it me or is morningstars page not cooperating?
>
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Tuesday, January 28, 2014 9:52:50 AM
Subject: Re: [smf_addin] Morningstar quotes still possible?
Elements #163 to #173 are the average P/E data elements from MSN.
SGA% from MorningStar are elements #14080 thru 14090.
All of those work for me, so you probably just need to pick up the latest element definitions from the "Works in Progress" folder. Both MSN and MorningStar elements had to be redefined because of changes they had made to their web pages.
On Tue, Jan 28, 2014 at 6:36 AM, <thelancour@yahoo.
>Im trying to get the SGA % from the key ratios off morningstar. Link http://financials.
>Using the get element from 163 to 173 I keep getting errors? is it me or is morningstars page not cooperating?
>
Tue Jan 28, 2014 10:05 am (PST) . Posted by:
"jesus christ" thelancour
Ok thanks, I got the new definitions. However, it keeps returning "obsolete"
On Tuesday, January 28, 2014 9:53 AM, Randy Harmelink <rharmelink@gmail.
Elements #163 to #173 are the average P/E data elements from MSN.
SGA% from MorningStar are elements #14080 thru 14090.
All of those work for me, so you probably just need to pick up the latest element definitions from the "Works in Progress" folder. Both MSN and MorningStar elements had to be redefined because of changes they had made to their web pages.
On Tue, Jan 28, 2014 at 6:36 AM, <thelancour@yahoo.
>Im trying to get the SGA % from the key ratios off morningstar. Link http://financials.
>Using the get element from 163 to 173 I keep getting errors? is it me or is morningstars page not cooperating?
>
Tue Jan 28, 2014 11:13 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The MorningStar element definitions file was last uploaded on November
15th. I had three sets of updates to them after November 5. From the change
log:
2013-11-06 RCHGetElementNumber Reinstated obsolete elements #13931-#14057,
on smf-elements-4.txt, to pull valuation ratios from static MorningStar web
pages. 2013-11-06 RCHGetElementNumber Reinstated obsolete elements
#14058-#14343, on smf-elements-4.txt, to pull key ratios from static
MorningStar web pages. 2013-11-14 RCHGetElementNumber Update/added some
MorningStar "Take" and "Profile" element definitions, #877-#891, to
smf-elements-4.txt.
Hmmm. Looks like I didn't upload the newest XLS documentation file that I
have, as of 2013-11-15...
On Tue, Jan 28, 2014 at 8:57 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Hi Randy - I have the latest from the "Work in progress" folder. The
> Elements-Definitions file that I have is 2013-11-5, in the file, elements
> 14080 thru 14090 are crossed out, and I get Error using
> SMF-Template-Morningstar-Key-Ratios.
>
>
15th. I had three sets of updates to them after November 5. From the change
log:
2013-11-06 RCHGetElementNumber Reinstated obsolete elements #13931-#14057,
on smf-elements-
pages. 2013-11-06 RCHGetElementNumber Reinstated obsolete elements
#14058-#14343, on smf-elements-
MorningStar web pages. 2013-11-14 RCHGetElementNumber Update/added some
MorningStar "Take" and "Profile" element definitions, #877-#891, to
smf-elements-
Hmmm. Looks like I didn't upload the newest XLS documentation file that I
have, as of 2013-11-15..
On Tue, Jan 28, 2014 at 8:57 AM, Jacob Jose <pepecan47@yahoo.
>
> Hi Randy - I have the latest from the "Work in progress" folder. The
> Elements-Definition
> 14080 thru 14090 are crossed out, and I get Error using
> SMF-Template-
>
>
Tue Jan 28, 2014 11:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
After replacing the files, you need to get the add-in to reload the element
definitions (it typically only loads them once, when the first
RCHGetElementNumber() function is run). That happens either when you exit
and restart EXCEL, or when you run the smfForceRecalculation macro (see
LINKS area of group for more info on it).
On Tue, Jan 28, 2014 at 11:02 AM, jesus christ <thelancour@yahoo.com> wrote:
>
> Ok thanks, I got the new definitions. However, it keeps returning
> "obsolete"; ?? not sure why?
>
>
definitions (it typically only loads them once, when the first
RCHGetElementNumber
and restart EXCEL, or when you run the smfForceRecalculati
LINKS area of group for more info on it).
On Tue, Jan 28, 2014 at 11:02 AM, jesus christ <thelancour@yahoo.
>
> Ok thanks, I got the new definitions. However, it keeps returning
> "obsolete"
>
>
Tue Jan 28, 2014 11:55 am (PST) . Posted by:
thelancour
Got it! Thanks Randy!
Tue Jan 28, 2014 9:49 am (PST) . Posted by:
option2z
Getting ready to try installing SMF on my new Windows tablet (which, so far is WAY better than the Android it replaces. Anyone already tried this? Any caveats?
Thanks
Pete A
Thanks
Pete A
Tue Jan 28, 2014 2:25 pm (PST) . Posted by:
cdtrad123
As usual Randy, your skill and generosity is amazing. Every update improves efficiency and thus allows for more time doing what is important, following trading strategies and consequently, creating wealth. Thanks.
The trickiest thing for me is actually figuring out the formulae to get the information I want.
Great Stuff.
Clint
The trickiest thing for me is actually figuring out the formulae to get the information I want.
Great Stuff.
Clint
Tue Jan 28, 2014 11:02 pm (PST) . Posted by:
5626ab246680da11c468b726d6775461
In the "Search" form at the top select index "FTSE AIM All-Share" for instance and click "Search".
Tue Jan 28, 2014 11:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If you can't give me direct URL with screening results, you won't be able
to give one to the add-in function. And it will need one to know which web
page to extract data from.
On Wed, Jan 29, 2014 at 12:02 AM, <stefan.schmidt296@gmail.com> wrote:
> In the "Search" form at the top select index "FTSE AIM All-Share" for
> instance and click "Search".
>
to give one to the add-in function. And it will need one to know which web
page to extract data from.
On Wed, Jan 29, 2014 at 12:02 AM, <stefan.schmidt296@
> In the "Search" form at the top select index "FTSE AIM All-Share" for
> instance and click "Search"
>
Tidak ada komentar:
Posting Komentar