7 New Messages
Digest #2844
Messages
Wed Nov 6, 2013 3:25 am (PST) . Posted by:
"Andreas Kucher" andreas.kucher
Hi Randy,
2 quick questions:
1. I have opted out several times to receive e-mails from the SMF_addin Group on Yahoo but each time I update a spresdsheet with the smf_addin I am again on the distribution list!
Therefore there must be a part in the code that sends out a message etc. Where is it exactly and how can I remove that function?
2. Is there meanwhile a way to get data from websites with dynamic html and websites the encode stock symbols or ISINs?
Thanks in advance
Andy
--------------------------------------------
rharmelink@gmail.com <rharmelink@gmail.com> schrieb am Di, 5.11.2013:
Betreff: [smf_addin] Attention -- Earnings.com element updates
An: smf_addin@yahoogroups.com
Datum: Dienstag, 5. November, 2013 22:42 Uhr
I've updated the following files to the
"Works in Progress" folder:
@Change-log.html -- Shows a log of changes to the
add-in since the last official release
RCHGetElementNumber-Element-Definitions.xls -- The
current documentation of element definitions, including the
many recent changes. I've added a "Usage"
column to indicate if an element is for Stocks
("S"), ETFs ("E"), and/or Mutual Funds
("F").
smf-elements-8.txt -- Contains the updates of the
earnings.com earnings announcement element definitions,
#1286 thru #1400, with element definitions from Zacks. I
replaced the old "Prev Year Actual" elements from
earnings.com with the new "Reported Time" from
Zacks. Otherwise, the elements mapped one-to-one. You could
even open up the old earnings.com template to see the data
for the new element definitions.
SMF-Template-Zacks-Earnings-Annoucements.xls -- A
new template, to display elements #1286 thru #1400 in
context.To
install the updates to the element definitions, replace the
smf-elements-8.txt in your SMF
add-in folder with this new file. Then, you'll either
need to exit and
restart EXCEL, or run the smfForceRecalculation macro, in
order for the
add-in to load the new definitions.
One thing that does concern me about the Zacks earnings
announcement table is that the older quarters have an
"Estimated EPS", but not a "Reported
EPS". That seem a little strange to me.
These are not trivial extractions, since the data was
extracted from JavaScript code. For example, the extraction
formula for element #1287 looks something like:
=smfConvertData(smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/IBM/earnings-announcements","script",-1,"Period
Ending"),"""data"" : [
","]"),1,"}"),4,","),":
","~"),"""",""""))
But once I got the pattern down, it went fairly quickly. :)
2 quick questions:
1. I have opted out several times to receive e-mails from the SMF_addin Group on Yahoo but each time I update a spresdsheet with the smf_addin I am again on the distribution list!
Therefore there must be a part in the code that sends out a message etc. Where is it exactly and how can I remove that function?
2. Is there meanwhile a way to get data from websites with dynamic html and websites the encode stock symbols or ISINs?
Thanks in advance
Andy
------------
rharmelink@gmail.
Betreff: [smf_addin] Attention -- Earnings.com element updates
An: smf_addin@yahoogrou
Datum: Dienstag, 5. November, 2013 22:42 Uhr
I've updated the following files to the
"Works in Progress" folder:
@Change-log.
add-in since the last official release
RCHGetElementNumber
current documentation of element definitions, including the
many recent changes. I've added a "Usage"
column to indicate if an element is for Stocks
("S"
("F"
smf-elements-
earnings.com earnings announcement element definitions,
#1286 thru #1400, with element definitions from Zacks. I
replaced the old "Prev Year Actual" elements from
earnings.com with the new "Reported Time" from
Zacks. Otherwise, the elements mapped one-to-one. You could
even open up the old earnings.com template to see the data
for the new element definitions.
SMF-Template-
new template, to display elements #1286 thru #1400 in
context.To
install the updates to the element definitions, replace the
smf-elements-
add-in folder with this new file. Then, you'll either
need to exit and
restart EXCEL, or run the smfForceRecalculati
order for the
add-in to load the new definitions.
One thing that does concern me about the Zacks earnings
announcement table is that the older quarters have an
"Estimated EPS", but not a "Reported
EPS". That seem a little strange to me.
These are not trivial extractions, since the data was
extracted from JavaScript code. For example, the extraction
formula for element #1287 looks something like:
=smfConvertData(
Ending"
","
","
But once I got the pattern down, it went fairly quickly. :)
Wed Nov 6, 2013 3:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Your settings are to only receive "Special Notices", which is what I tagged
these last two "Attention" messages.
There's nothing in the code of the add-in to put anyone on a distribution
list, or send a message.
You'd have to Interact with the IE object to get data from a dynamic web
page. I stopped using that method because it was unreliable across
different versions of IE and EXCEL. Since I only have the one version of
each, I couldn't possible test the add-in under all permutations if each
required different code.
As far as encoded stock symbols or ISINs, it all depends on how the website
works. Sometimes possible, sometimes not. In most cases, you need to learn
and use whatever tickers they do.
On Wed, Nov 6, 2013 at 3:52 AM, Andreas Kucher <andreas.kucher@yahoo.com>wrote:
>
> 2 quick questions:
>
> 1. I have opted out several times to receive e-mails from the SMF_addin
> Group on Yahoo but each time I update a spresdsheet with the smf_addin I am
> again on the distribution list!
> Therefore there must be a part in the code that sends out a message etc.
> Where is it exactly and how can I remove that function?
>
> 2. Is there meanwhile a way to get data from websites with dynamic html
> and websites the encode stock symbols or ISINs?
>
these last two "Attention&quo
There's nothing in the code of the add-in to put anyone on a distribution
list, or send a message.
You'd have to Interact with the IE object to get data from a dynamic web
page. I stopped using that method because it was unreliable across
different versions of IE and EXCEL. Since I only have the one version of
each, I couldn't possible test the add-in under all permutations if each
required different code.
As far as encoded stock symbols or ISINs, it all depends on how the website
works. Sometimes possible, sometimes not. In most cases, you need to learn
and use whatever tickers they do.
On Wed, Nov 6, 2013 at 3:52 AM, Andreas Kucher <andreas.kucher@
>
> 2 quick questions:
>
> 1. I have opted out several times to receive e-mails from the SMF_addin
> Group on Yahoo but each time I update a spresdsheet with the smf_addin I am
> again on the distribution list!
> Therefore there must be a part in the code that sends out a message etc.
> Where is it exactly and how can I remove that function?
>
> 2. Is there meanwhile a way to get data from websites with dynamic html
> and websites the encode stock symbols or ISINs?
>
Wed Nov 6, 2013 7:29 am (PST) . Posted by:
bushpilote
Hi,
f216b6e0642279a2e6046ac66cf35eb6 thanks for posting the FX function spreadsheet.
It worked well up until October 31,2013. Dates from November 1, 2013 to excel's today() function result in value errors.
Any help in getting it resolved would be greatly appreciated.
Thank you.
f216b6e0642279a2e60
It worked well up until October 31,2013. Dates from November 1, 2013 to excel's today() function result in value errors.
Any help in getting it resolved would be greatly appreciated.
Thank you.
Wed Nov 6, 2013 8:13 am (PST) . Posted by:
"Daniel Russell" udelfb92
Hi,
For some reason my name in the group is an extraordinarily long number.
Anyways, the data was partially restructured so I fixed the code and now it
should work. Hopefully this is helpful as FX data is hard to come by.
Best,
Danny Russell
OsoCapitalResearch.Com
For some reason my name in the group is an extraordinarily long number.
Anyways, the data was partially restructured so I fixed the code and now it
should work. Hopefully this is helpful as FX data is hard to come by.
Best,
Danny Russell
OsoCapitalResearch.
Wed Nov 6, 2013 9:21 am (PST) . Posted by:
dennismontegnies
Anyone know how to find the other parameters listed?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Problems with the AdvFN site have been the topic of many conversations here over the past few months. The conclusion can be found here:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24009 http://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24009
However, it appears the regular website is not being updated promptly, as they are working on a new "beta" format of their web page presentation. I won't update the add-in for that until they've put it into place and have it working properly.
On Tue, Nov 5, 2013 at 2:43 PM, <montegnies.dennis@... mailto:montegnies.dennis@...> wrote:
I get alot of errors lately on the ADvFN sources, any solution for that?
---In smf_addin@yahoogrou
Problems with the AdvFN site have been the topic of many conversations here over the past few months. The conclusion can be found here:
http://groups.
However, it appears the regular website is not being updated promptly, as they are working on a new "beta" format of their web page presentation. I won't update the add-in for that until they've put it into place and have it working properly.
On Tue, Nov 5, 2013 at 2:43 PM, <montegnies.
I get alot of errors lately on the ADvFN sources, any solution for that?
Thu Nov 7, 2013 12:28 am (PST) . Posted by:
dennismontegnies
Where to find the current updated model?
---In smf_addin@yahoogroups.com, <dan-carroll@...> wrote:
Fixed it. Apologies for that, I'm just crushed with work right now and didn't get time to check it all properly. THanks for the help, please flag anything else you find
---In smf_addin@yahoogroups.com, <kompiled@...> wrote:
The GuruFocus 10 Year Model is missing "Accounts Receivable" from the balance sheet's current assets section.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
There's probably still a bunch of other errors (EBITDA was pulling from the "per-share" which I fixed, so please help check and flag any errors. Thanks
---In smf_addin@yahoogroups.com, <dan-carroll@...> wrote:
Made a bunch of fixes for spaces etc, should work better
As for ROIC, I put the calculation back in but on the variations with ADVfn, I don't know how to tell you. It's one of those metrics where people play around a bit at the fringes. Do you use average capital from previous year and this? Include leases? Perhaps there are liabilities that GuruFocus doesn't capture?
I have used EBIT/(Equity + Debt), but feel free to suggest a modification. My personal experience has been as long as you're consistent in how you calculate it, it will give useful information on a relative basis. Sorry I can't help more.
---In smf_addin@yahoogroups.com, <lottidottigigliotti@...> wrote:
Thanks for the updated GuruFocus 10 Year Model!
I noticed that some of the data didn't populate because of extra spaces added to the names of various line items.
For example: "Cash And Cash Equivalents" now has two spaces before the name. After I added the two spaces before the name in the excel sheet, it worked.
Same thing can be done to fix other line item names.
I do have a question about ROCI (Return on Captial Invested). On your old GuruFocus spreadsheet, this ROCI item was calculated. I tried to calculate it the same way with the new spreadsheet, but the figure is coming up incorrect.
For example, the ROCI for Exxon (XOM) for the year 2003 calculates to 63.90%.
But in reality, it should be closer to 22.10% (according to the ADVFN website).
I calculated the ROCI from your GuruFocus spreadsheet by using the following formula:
"Operating Income" divided by "Invested Capital"
It appears that my "Invested Capital" amount is coming up incorrect.
My "Invested Capital" calculates to 88,834 for the year 2003.
But from the ADVFN website, it should be 94,671.
Any help in solving this would be greatly appreciated since ROCI is a great analysis item.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I found out about the issues with the model. GuruFocus added a lot of new 10 year data - especially in the Balance Sheet and Cash Flow sections, and changed a lot of the names of the various line items. As a result the old model stopped working.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
---In smf_addin@yahoogrou
Fixed it. Apologies for that, I'm just crushed with work right now and didn't get time to check it all properly. THanks for the help, please flag anything else you find
---In smf_addin@yahoogrou
The GuruFocus 10 Year Model is missing "Accounts Receivable" from the balance sheet's current assets section.
---In smf_addin@yahoogrou
There's probably still a bunch of other errors (EBITDA was pulling from the "per-share&quo
---In smf_addin@yahoogrou
Made a bunch of fixes for spaces etc, should work better
As for ROIC, I put the calculation back in but on the variations with ADVfn, I don't know how to tell you. It's one of those metrics where people play around a bit at the fringes. Do you use average capital from previous year and this? Include leases? Perhaps there are liabilities that GuruFocus doesn't capture?
I have used EBIT/(Equity + Debt), but feel free to suggest a modification. My personal experience has been as long as you're consistent in how you calculate it, it will give useful information on a relative basis. Sorry I can't help more.
---In smf_addin@yahoogrou
Thanks for the updated GuruFocus 10 Year Model!
I noticed that some of the data didn't populate because of extra spaces added to the names of various line items.
For example: "Cash And Cash Equivalents" now has two spaces before the name. After I added the two spaces before the name in the excel sheet, it worked.
Same thing can be done to fix other line item names.
I do have a question about ROCI (Return on Captial Invested). On your old GuruFocus spreadsheet, this ROCI item was calculated. I tried to calculate it the same way with the new spreadsheet, but the figure is coming up incorrect.
For example, the ROCI for Exxon (XOM) for the year 2003 calculates to 63.90%.
But in reality, it should be closer to 22.10% (according to the ADVFN website).
I calculated the ROCI from your GuruFocus spreadsheet by using the following formula:
"Operating Income" divided by "Invested Capital"
It appears that my "Invested Capital" amount is coming up incorrect.
My "Invested Capital" calculates to 88,834 for the year 2003.
But from the ADVFN website, it should be 94,671.
Any help in solving this would be greatly appreciated since ROCI is a great analysis item.
---In smf_addin@yahoogrou
I found out about the issues with the model. GuruFocus added a lot of new 10 year data - especially in the Balance Sheet and Cash Flow sections, and changed a lot of the names of the various line items. As a result the old model stopped working.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
Thu Nov 7, 2013 12:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The latest one is in the "Uploads by forum members" folder in the FILES
area of the group, dated Nov 3.
On Thu, Nov 7, 2013 at 1:24 AM, <dennismontegnies@yahoo.com> wrote:
> Where to find the current updated model?
>
area of the group, dated Nov 3.
On Thu, Nov 7, 2013 at 1:24 AM, <dennismontegnies@
> Where to find the current updated model?
>
Tidak ada komentar:
Posting Komentar