15 New Messages
Digest #2841
Messages
Tue Nov 5, 2013 6:10 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Hello Everyone,
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
Tue Nov 5, 2013 7:11 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Yes, you can
I find the best way to determine if the ADDIN supports something is to search the element definition file.
Or check the files section of the group. It contain a ton of useful spreadsheets.
You can get quarterly EPS for multiple quarter. For sales there are hundreds of elements to choose from.
You might check previous message for uploads of excel files for 10 years of fundamental data.
Plus, if it isn't in the ADDIN, just tell Randy EXACTLY what you want and the URL and there is a good chance he will add it in less than a day.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of johkouf@hotmail.com
Sent: Tuesday, November 05, 2013 9:10 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Quarterly Eps - sales
Hello Everyone,
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
I find the best way to determine if the ADDIN supports something is to search the element definition file.
Or check the files section of the group. It contain a ton of useful spreadsheets.
You can get quarterly EPS for multiple quarter. For sales there are hundreds of elements to choose from.
You might check previous message for uploads of excel files for 10 years of fundamental data.
Plus, if it isn't in the ADDIN, just tell Randy EXACTLY what you want and the URL and there is a good chance he will add it in less than a day.
Kermit
From: smf_addin@yahoogrou
Sent: Tuesday, November 05, 2013 9:10 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Quarterly Eps - sales
Hello Everyone,
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
Tue Nov 5, 2013 8:50 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
There is this Url that has past quarterly Eps
http://www.zacks.com/stock/research/IBM/earnings-announcements
How can I ask Randy to get element number ?
Thanks
---In smf_addin@yahoogroups.com, <kermitp@...> wrote:
Yes, you can
I find the best way to determine if the ADDIN supports something is to search the element definition file.
Or check the files section of the group. It contain a ton of useful spreadsheets.
You can get quarterly EPS for multiple quarter. For sales there are hundreds of elements to choose from.
You might check previous message for uploads of excel files for 10 years of fundamental data.
Plus, if it isn't in the ADDIN, just tell Randy EXACTLY what you want and the URL and there is a good chance he will add it in less than a day.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of johkouf@...
Sent: Tuesday, November 05, 2013 9:10 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Quarterly Eps - sales
Hello Everyone,
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
http://www.zacks.
How can I ask Randy to get element number ?
Thanks
---In smf_addin@yahoogrou
Yes, you can
I find the best way to determine if the ADDIN supports something is to search the element definition file.
Or check the files section of the group. It contain a ton of useful spreadsheets.
You can get quarterly EPS for multiple quarter. For sales there are hundreds of elements to choose from.
You might check previous message for uploads of excel files for 10 years of fundamental data.
Plus, if it isn't in the ADDIN, just tell Randy EXACTLY what you want and the URL and there is a good chance he will add it in less than a day.
Kermit
From: smf_addin@yahoogrou
Sent: Tuesday, November 05, 2013 9:10 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Quarterly Eps - sales
Hello Everyone,
Anyone know how if I could download past quarterly eps and sales with smf ??
Thanks
John
Tue Nov 5, 2013 12:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, not an easy extraction. The data isn't in a table, but
located in JavaScript code and put onto the web page dynamically. That
means extracting it out of that JavaScript code.
I'm looking at replacing the earnings.com quarterly earnings items with
data from this page. Stay tuned.
On Tue, Nov 5, 2013 at 9:50 AM, <johkouf@hotmail.com> wrote:
> There is this Url that has past quarterly Eps
>
> http://www.zacks.com/stock/research/IBM/earnings-announcements
>
> How can I ask Randy to get element number ?
>
located in JavaScript code and put onto the web page dynamically. That
means extracting it out of that JavaScript code.
I'm looking at replacing the earnings.com quarterly earnings items with
data from this page. Stay tuned.
On Tue, Nov 5, 2013 at 9:50 AM, <johkouf@hotmail.
> There is this Url that has past quarterly Eps
>
> http://www.zacks.
>
> How can I ask Randy to get element number ?
>
Tue Nov 5, 2013 7:29 am (PST) . Posted by:
indinvestor111
Hi,
When loading the new version of the add-in from Works-in-Progress, are we to delete the smf-AdvFN-Prefix text file that Randy proposed as a work around for earlier AdvFn issues?
Thanks
When loading the new version of the add-in from Works-in-Progress, are we to delete the smf-AdvFN-Prefix text file that Randy proposed as a work around for earlier AdvFn issues?
Thanks
Tue Nov 5, 2013 11:18 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't know how alternate prefixes are affected by the new web site. Or
will be when they go to their "beta" data format.
On Tue, Nov 5, 2013 at 8:29 AM, <elandry@bmlcapital.com> wrote:
> When loading the new version of the add-in from Works-in-Progress, are
> we to delete the smf-AdvFN-Prefix text file that Randy proposed as a work
> around for earlier AdvFn issues?
>
will be when they go to their "beta" data format.
On Tue, Nov 5, 2013 at 8:29 AM, <elandry@bmlcapital.
> When loading the new version of the add-in from Works-in-Progress, are
> we to delete the smf-AdvFN-Prefix text file that Randy proposed as a work
> around for earlier AdvFn issues?
>
Tue Nov 5, 2013 8:14 am (PST) . Posted by:
domellner
Hello, my template is now updating again thanks to the new add-in. Thank you!!
However, I'm finding that for a number of tickers (e.g. "VG") the quarterly indicator for FQ1 ("8006") returns 2013/03 when finance.yahoo.com provides income statement data through Q2'13. I've also seen this for AT&T (T) and Verizon (VZ).
Is anyone else having this problem? Is there a way to remedy?
Thank you...
Dominique
However, I'm finding that for a number of tickers (e.g. "VG"
Is anyone else having this problem? Is there a way to remedy?
Thank you...
Dominique
Tue Nov 5, 2013 11:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think they're putting their efforts into the upcoming "beta" format. They
have this note on their web pages:
"Newest quarter's financials are not updating correctly. Visit our beta
financials to view latest financial statement."
On Tue, Nov 5, 2013 at 9:14 AM, <dominique.ellner@gmail.com> wrote:
>
> However, I'm finding that for a number of tickers (e.g. "VG") the
> quarterly indicator for FQ1 ("8006") returns 2013/03 when
> finance.yahoo.com provides income statement data through Q2'13. I've
> also seen this for AT&T (T) and Verizon (VZ).
>
> Is anyone else having this problem? Is there a way to remedy?
>
have this note on their web pages:
"Newest quarter'
financials to view latest financial statement."
On Tue, Nov 5, 2013 at 9:14 AM, <dominique.ellner@
>
> However, I'm finding that for a number of tickers (e.g. "VG"
> quarterly indicator for FQ1 ("8006"
> finance.yahoo.
> also seen this for AT&T (T) and Verizon (VZ).
>
> Is anyone else having this problem? Is there a way to remedy?
>
Tue Nov 5, 2013 1:26 pm (PST) . Posted by:
domellner
Thanks Randy. I guess there's no way at this time to source the beta financials in an automated manner?
Thanks again for everything...
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I think they're putting their efforts into the upcoming "beta" format. They have this note on their web pages:
"Newest quarter's financials are not updating correctly. Visit our beta financials to view latest financial statement."
On Tue, Nov 5, 2013 at 9:14 AM, <dominique.ellner@... mailto:dominique.ellner@...> wrote:
However, I'm finding that for a number of tickers (e.g. "VG") the quarterly indicator for FQ1 ("8006") returns 2013/03 when finance.yahoo.com http://finance.yahoo.com provides income statement data through Q2'13. I've also seen this for AT&T (T) and Verizon (VZ).
Is anyone else having this problem? Is there a way to remedy?
Thanks again for everything..
---In smf_addin@yahoogrou
I think they're putting their efforts into the upcoming "beta" format. They have this note on their web pages:
"Newest quarter'
On Tue, Nov 5, 2013 at 9:14 AM, <dominique.
However, I'm finding that for a number of tickers (e.g. "VG"
Is anyone else having this problem? Is there a way to remedy?
Tue Nov 5, 2013 1:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Possible, but it's likely the process will change again before it's
official.
They are going to a completely different format, so it's going to be a huge
task to convert elements, even if it can be done. There may be a
possibility that all of the old elements will just get tossed, and a
completely new set defined. In any case, I wouldn't want to do the
re-mapping task twice.
I think there is a template that someone put together in the "Uploads by
Forum Members" folder in the FILES area, if you want to take a look at it.
On Tue, Nov 5, 2013 at 2:26 PM, <dominique.ellner@gmail.com> wrote:
> Thanks Randy. I guess there's no way at this time to source the beta
> financials in an automated manner?
>
>
>
official.
They are going to a completely different format, so it's going to be a huge
task to convert elements, even if it can be done. There may be a
possibility that all of the old elements will just get tossed, and a
completely new set defined. In any case, I wouldn't want to do the
re-mapping task twice.
I think there is a template that someone put together in the "Uploads by
Forum Members" folder in the FILES area, if you want to take a look at it.
On Tue, Nov 5, 2013 at 2:26 PM, <dominique.ellner@
> Thanks Randy. I guess there's no way at this time to source the beta
> financials in an automated manner?
>
>
>
Tue Nov 5, 2013 8:39 am (PST) . Posted by:
hamishthedenizen
Just want to add my thanks - you continue to be a life saver.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Done. I just uploaded new copies of:
smf-elements-6.txt
SMF-Template-Zacks-Data.xls
...with these new elements:
# Usage Source Element 13895 S Zacks Estimated Long-Term Growth Rate 13896 S Zacks Sector
I decided to pick up that growth rate from the quotes pages because it was expressed as a percentage.
Thanks for the formulas. It made them easy to add.
The "Usage" column above is something new I'm adding to the element definition workbook. It will have "S" for stocks, "E" for ETFs, and "F" for mutual funds. So the above elements apply to stocks only. If the element worked for all three types of equities, it would show "SEF".
On Mon, Nov 4, 2013 at 9:29 PM, <altaclip@... mailto:altaclip@...> wrote:
You asked about any other possible elements. I like Zacks est long-term earnings growth:
=RCHGetTableCell("http://www.zacks.com/stock/research/~~~~~/company-reports http://www.zacks.com/stock/research/~~~~~/company-reports",1,"estimated long-term eps growth rate")
I also like Zacks sector classifications.
RCHGetTableCell("http://www.zacks.com/stock/research/~~~~~/company-reports http://www.zacks.com/stock/research/~~~~~/company-reports",1,"sector")
---In smf_addin@yahoogrou
Done. I just uploaded new copies of:
smf-elements-
SMF-Template-
...with these new elements:
# Usage Source Element 13895 S Zacks Estimated Long-Term Growth Rate 13896 S Zacks Sector
I decided to pick up that growth rate from the quotes pages because it was expressed as a percentage.
Thanks for the formulas. It made them easy to add.
The "Usage" column above is something new I'm adding to the element definition workbook. It will have "S" for stocks, "E" for ETFs, and "F" for mutual funds. So the above elements apply to stocks only. If the element worked for all three types of equities, it would show "SEF"
On Mon, Nov 4, 2013 at 9:29 PM, <altaclip@
You asked about any other possible elements. I like Zacks est long-term earnings growth:
=RCHGetTableCell(
I also like Zacks sector classifications.
RCHGetTableCell(
Tue Nov 5, 2013 12:38 pm (PST) . Posted by:
"Ken Sieracki" ksiera
Thanks for your updates. Your efforts to keep everything running smoothly is always much appreciated. I enjoy using this addin and it's always nice to know that it is professionally maintained.
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Mon, 4 Nov 2013 16:47:54 -0800
Subject: [smf_addin] Attention -- Zacks updates
Zacks made a number of changes to their website this weekend. They not only rearranged which web pages some elements were on, but also changed the labeling on many elements. As a result, I had to redefine almost all Zacks elements.
I uploaded a new smf-elements-6.txt to the "Works in Progress" folder of the FILES area of the group. It contains all the new element definitions. To install the updates, replace the smf-elements-6.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.
I also uploaded a new version of the SMF-Template-Zacks-Data.xls workbook.
I had to obsolete four elements that I couldn't find on any of their web pages (if you see them, let me know), and added four new elements:
Status
#
Source
Element
Obsoleted
852
Zacks
Rank Within Industry
Obsoleted
13879
Zacks
Sales
Obsoleted
13880
Zacks
Net Income
Obsoleted
13890
Zacks
Average Broker Recommendation -- Rank Within Industry
Addition
13891
Zacks
Beta
Addition
13892
Zacks
Forward P/E
Addition
13893
Zacks
Next Earnings Date
Addition
13894
Zacks
Earnings Expected Surprise Prediction
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Mon, 4 Nov 2013 16:47:54 -0800
Subject: [smf_addin] Attention -- Zacks updates
Zacks made a number of changes to their website this weekend. They not only rearranged which web pages some elements were on, but also changed the labeling on many elements. As a result, I had to redefine almost all Zacks elements.
I uploaded a new smf-elements-
I also uploaded a new version of the SMF-Template-
I had to obsolete four elements that I couldn't find on any of their web pages (if you see them, let me know), and added four new elements:
Status
#
Source
Element
Obsoleted
852
Zacks
Rank Within Industry
Obsoleted
13879
Zacks
Sales
Obsoleted
13880
Zacks
Net Income
Obsoleted
13890
Zacks
Average Broker Recommendation -- Rank Within Industry
Addition
13891
Zacks
Beta
Addition
13892
Zacks
Forward P/E
Addition
13893
Zacks
Next Earnings Date
Addition
13894
Zacks
Earnings Expected Surprise Prediction
Tue Nov 5, 2013 9:45 am (PST) . Posted by:
analyst101010
Hi there
Thanks again to Randy for fixing the Zacks data. All my templates are working nicely again.
As a side note = has anyone looked into how to pull down the High-Low price target ranges published by Yahoo (here)? =
http://finance.yahoo.com/q/ao?s=QCOR+Analyst+Opinion
Mean Target: 84.44 Median Target: 85.00 High Target: 93.00 Low Target: 73.00
Zacks publishes "Analyst consensus" which is roughly in line with the quoted "averages"; (normally! they may be a bit off sometimes)... but I can't seem to find the Hi-Low split anywhere... its always been useful for me to see the spread of POV on the 12mo outlook for a name...
Anyway, thanks for any feedback.
p.s. Does anyone else find the new Yahoo Groups format to completely *suck*? I can hardly use their page with any browser except Chrome.... IE9 is impossible... just a side observation...
Cheers,
john
Thanks again to Randy for fixing the Zacks data. All my templates are working nicely again.
As a side note = has anyone looked into how to pull down the High-Low price target ranges published by Yahoo (here)? =
http://finance.
Mean Target: 84.44 Median Target: 85.00 High Target: 93.00 Low Target: 73.00
Zacks publishes "Analyst consensus" which is roughly in line with the quoted "averages"
Anyway, thanks for any feedback.
p.s. Does anyone else find the new Yahoo Groups format to completely *suck*? I can hardly use their page with any browser except Chrome.... IE9 is impossible..
Cheers,
john
Tue Nov 5, 2013 10:50 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Yes, the new group format sucks.
But It is not going to change for the better.
Yahoo received over 250,000 complaints which they have chosen to ignore.
But its FREE.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of jfgilmore@gmail.com
Sent: Tuesday, November 05, 2013 12:45 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Yahoo/Thompson PT Ranges
Hi there
Thanks again to Randy for fixing the Zacks data. All my templates are working nicely again.
As a side note = has anyone looked into how to pull down the High-Low price target ranges published by Yahoo (here)? =
http://finance.yahoo.com/q/ao?s=QCOR+Analyst+Opinion
Mean Target:
84.44
Median Target:
85.00
High Target:
93.00
Low Target:
73.00
Zacks publishes "Analyst consensus" which is roughly in line with the quoted "averages"; (normally! they may be a bit off sometimes)... but I can't seem to find the Hi-Low split anywhere... its always been useful for me to see the spread of POV on the 12mo outlook for a name...
Anyway, thanks for any feedback.
p.s. Does anyone else find the new Yahoo Groups format to completely *suck*? I can hardly use their page with any browser except Chrome.... IE9 is impossible... just a side observation...
Cheers,
john
But It is not going to change for the better.
Yahoo received over 250,000 complaints which they have chosen to ignore.
But its FREE.
From: smf_addin@yahoogrou
Sent: Tuesday, November 05, 2013 12:45 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Yahoo/Thompson PT Ranges
Hi there
Thanks again to Randy for fixing the Zacks data. All my templates are working nicely again.
As a side note = has anyone looked into how to pull down the High-Low price target ranges published by Yahoo (here)? =
http://finance.
Mean Target:
84.44
Median Target:
85.00
High Target:
93.00
Low Target:
73.00
Zacks publishes "Analyst consensus" which is roughly in line with the quoted "averages"
Anyway, thanks for any feedback.
p.s. Does anyone else find the new Yahoo Groups format to completely *suck*? I can hardly use their page with any browser except Chrome.... IE9 is impossible..
Cheers,
john
Tue Nov 5, 2013 11:17 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You just need something like:
=RCHGetTableCell("http://finance.yahoo.com/q/ao?s=QCOR",1,">Low Target")
They will be slightly different than Zacks because Zacks and Thomson
probably have a different mix of analysts.
On Tue, Nov 5, 2013 at 10:45 AM, <jfgilmore@gmail.com> wrote:
>
> As a side note = has anyone looked into how to pull down the High-Low
> price target ranges published by Yahoo (here)? =
>
> http://finance.yahoo.com/q/ao?s=QCOR+Analyst+Opinion
>
> Mean Target: 84.44 Median Target: 85.00 High Target: 93.00 Low Target:
> 73.00
>
>
>
>
> Zacks publishes "Analyst consensus" which is roughly in line with the
> quoted "averages"; (normally! they may be a bit off sometimes)... but I
> can't seem to find the Hi-Low split anywhere... its always been useful for
> me to see the spread of POV on the 12mo outlook for a name...
>
>
=RCHGetTableCell(
They will be slightly different than Zacks because Zacks and Thomson
probably have a different mix of analysts.
On Tue, Nov 5, 2013 at 10:45 AM, <jfgilmore@gmail.
>
> As a side note = has anyone looked into how to pull down the High-Low
> price target ranges published by Yahoo (here)? =
>
> http://finance.
>
> Mean Target: 84.44 Median Target: 85.00 High Target: 93.00 Low Target:
> 73.00
>
>
>
>
> Zacks publishes "Analyst consensus" which is roughly in line with the
> quoted "averages"
> can't seem to find the Hi-Low split anywhere... its always been useful for
> me to see the spread of POV on the 12mo outlook for a name...
>
>
Tidak ada komentar:
Posting Komentar