Selasa, 10 Juni 2014

[smf_addin] Digest Number 3088

15 Messages

Digest #3088
1a
Estimize by infinityholdings@ymail.com
1b
Re: Estimize by "Randy Harmelink" rharmelink
1c
Re: Estimize by infinityholdings@ymail.com
2.2
Re: New file uploaded to smf_addin by "अनन्त:" ritchemie
2.3
Re: New file uploaded to smf_addin by "Randy Harmelink" rharmelink
3b
Re: Error from Morningstar RCHGetElementNumber by "Randy Harmelink" rharmelink
4c
4e
5
Thank You Randy! by ultimatestockfinder

Messages

Tue Jun 10, 2014 5:07 am (PDT) . Posted by:

infinityholdings@ymail.com

Randy
Is there a way to pull the EPS and Revenue data from their sites tables


Here is a link
EBAY (eBay Inc.) – Q1 2014 http://www.estimize.com/ebay/fq1-2014#chart=table


EBAY (eBay Inc.) – Q1 2014 http://www.estimize.com/ebay/fq1-2014#chart=table Reported Earnings 0.70 4,300 04/29/14 Estimize Consensus 0.68 4,233 04/29/14 72 estimates included in consensus Select Consensus - - 04/29/14 35 estimates included in consensus WS Consensus 0.67 4,224



View on www.estimize.com http://www.estimize.com/ebay/fq1-2014#chart=table
Preview by Yahoo



Thank you for the help

Tue Jun 10, 2014 8:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not easily. It needs to be extracted from JavaScript code. For example:

=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),3,"estimize_eps_mean"),2,":"),"~",","))

...varying that "3" parameter from 3 to 11 for the various columns of the
table, and varying the "2" parameter as 2, 3, 4, 5, 10, 11, 16, 17, and 18
for the various rows of data. Note that the "3" parameter needs to be
decremented by 1 for "2" value of 16 thru 18. So:

*3* *4* *5* *6* *7* *8* *9* *10* *11* *16* FQ2 2012 FQ3 2012 FQ4 2012 FQ1
2013 FQ2 2013 FQ3 2013 FQ4 2013 FQ1 2014 FQ2 2014 *2* $0.57 $0.56 $0.70
$0.63 $0.64 $0.64 $0.81 $0.68 $0.71 *4* $0.55 $0.55 $0.68 $0.62 $0.63 $0.63
$0.80 $0.67 $0.69 *17* $0.56 $0.55 $0.70 $0.63 $0.63 $0.64 $0.81 $0.70 null
*10* 16.67% 14.58% 16.67% 14.55% 12.50% 16.36% 15.71% 11.11% null
*16* FQ2 2012 FQ3 2012 FQ4 2012 FQ1 2013 FQ2 2013 FQ3 2013 FQ4
2013 FQ1 2014 FQ2 2014 *3* $3,404 $3,451 $3,992 $3,776 $3,905 $3,908 $4,558
$4,233 $4,399 *5* $3,358 $3,407 $3,970 $3,759 $3,886 $3,902 $4,556 $4,224
$4,387 *18* $3,398 $3,404 $3,992 $3,748 $3,877 $3,892 $4,530 $4,300 null
*11* 23.10% 14.78% 18.11% 14.34% 14.10% 14.34% 13.48% 14.73% null
The formulas in that first column of data:

=SUBSTITUTE(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23-1,"estimize_eps_mean"),$D24,":"),"~",","),"""","")
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D25,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D26,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23-1,"estimize_eps_mean"),$D27,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D28,":"),"~",","))

=SUBSTITUTE(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23-1,"estimize_eps_mean"),$D30,":"),"~",","),"""","")
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D31,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D32,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23-1,"estimize_eps_mean"),$D33,":"),"~",","))
=smfConvertData(smfstrExtr(smfWord(smfWord(RCHGetWebData("
http://www.estimize.com/ebay/fq1-2014
","estimize_eps_mean",5000),E$23,"estimize_eps_mean"),$D34,":"),"~",","))

On Tue, Jun 10, 2014 at 5:07 AM, coons_adam@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a way to pull the EPS and Revenue data from their sites tables
>
> Here is a link
>
> EBAY (eBay Inc.) – Q1 2014
> <http://www.estimize.com/ebay/fq1-2014#chart=table>
>

Tue Jun 10, 2014 7:00 pm (PDT) . Posted by:

infinityholdings@ymail.com

Thank you Randy I really appreciate it

Tue Jun 10, 2014 9:11 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/BTMA Stock Analyzer (free for smf_addin group)
Uploaded by : g_oudreva <lottidottigigliotti@hotmail.com>
Description : This commercially-sold stock analyzer usually sells for $69, but you can get it for free here. It's all automated and can analyze, compare, and sort the entire S&P 500, or thousands of other stocks with a click of a button. It seems to pull info from ADVFN and Yahoo Finance, etc. and uses the smf_addin. It's saved me a great deal of time in analyzing. You need to enter this password: OpenSesame
on this webpage: http://www.beatthemarketanalyzer.com/blog/btma-full-version-stock-analyzer3

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/BTMA%20Stock%20Analyzer%20%28free%20for%20smf_addin%20group%29%20

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

g_oudreva <lottidottigigliotti@hotmail.com>

Tue Jun 10, 2014 4:39 pm (PDT) . Posted by:

"अनन्त:" ritchemie

my personal opinion, this is not a simple spreadsheet. it will ask you
delete esisiting SMF add and runs an installer.
then when you finish all the it will ask you to open the file created as
shortcut on your desktop.
once you click on that it will give you activation code, you have to copy
that code and go to his website. Enter the code, first name, last name and
e-mail ID.
then it will generate another code which you have to enter the spreadsheet
pop up to activate it.
then you will get a mail asking to confirm you e-mail subscription with
this subject "
"stockspreadsheetclass3month"

this appears like a free 3 month trial and as such spreadsheet is very slow
and crashes few times and not the greatest to use.

other templates on SMF site are far better and intuitive than this one

On Tue, Jun 10, 2014 at 12:11 PM, <smf_addin@yahoogroups.com> wrote:

>
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Uploads by forum members/BTMA Stock Analyzer (free for smf_addin
> group)
> Uploaded by : g_oudreva <lottidottigigliotti@hotmail.com>
> Description : This commercially-sold stock analyzer usually sells for $69,
> but you can get it for free here. It's all automated and can analyze,
> compare, and sort the entire S&P 500, or thousands of other stocks with a
> click of a button. It seems to pull info from ADVFN and Yahoo Finance, etc.
> and uses the smf_addin. It's saved me a great deal of time in analyzing.
> You need to enter this password: OpenSesame
> on this webpage:
> http://www.beatthemarketanalyzer.com/blog/btma-full-version-stock-analyzer3
>
> You can access this file at the URL:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/BTMA%20Stock%20Analyzer%20%28free%20for%20smf_addin%20group%29%20
>
> To learn more about file sharing for your group, please visit:
>
> https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
>
> Regards,
>
> g_oudreva <lottidottigigliotti@hotmail.com>
>
>

Tue Jun 10, 2014 4:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because it's an installer, and not a workbook, I've deleted it from the
files area. I was already considering deleting it because it was
advertising a commercial product.

Thanks for letting me know.

On Tue, Jun 10, 2014 at 4:39 PM, अनन्त: 1998chemie@... wrote:

>
> my personal opinion, this is not a simple spreadsheet. it will ask you
> delete esisiting SMF add and runs an installer.
> then when you finish all the it will ask you to open the file created as
> shortcut on your desktop.
> once you click on that it will give you activation code, you have to copy
> that code and go to his website. Enter the code, first name, last name and
> e-mail ID.
> then it will generate another code which you have to enter the spreadsheet
> pop up to activate it.
> then you will get a mail asking to confirm you e-mail subscription with
> this subject "
> "stockspreadsheetclass3month&quot;
>
> this appears like a free 3 month trial and as such spreadsheet is very
> slow and crashes few times and not the greatest to use.
>
> other templates on SMF site are far better and intuitive than this one
>
>

Tue Jun 10, 2014 9:25 am (PDT) . Posted by:

michalemory

I'm getting an error message when I try bring in any of data from 14311 to 14343. I'm able to bring in other data from Morningstar so I know I'm connected properly to their website but I get an error for this data. The formula I'm using is: =RCHGetElementNumber(TICKER,14342)


Any ideas as to why? Thanks.

Tue Jun 10, 2014 9:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just opened up the "SMF-Template-Morningstar-Key-Ratios.xls" template
from the website, entered ticker symbol MMM, and everything looks fine to
me.

Do you have the current element definitions? Those were last updated in
November of last year.

On Tue, Jun 10, 2014 at 9:25 AM, michalemory@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm getting an error message when I try bring in any of data from 14311
> to 14343. I'm able to bring in other data from Morningstar so I know I'm
> connected properly to their website but I get an error for this data. The
> formula I'm using is: =RCHGetElementNumber(TICKER,14342)
>
> Any ideas as to why? Thanks.
>

Tue Jun 10, 2014 11:29 am (PDT) . Posted by:

michalemory

I didn't have the current smf-elements. Thanks.

Tue Jun 10, 2014 1:08 pm (PDT) . Posted by:

friedman_steve

I've been an avid & happy user of this Add-in for a couple of years.
I recently updated my computer to Windows 7 Pro and Office 2013 (previously used Vista and Office 2007)


Everything working great....Except....


I have one spreadsheet with LOTS of data that takes a long time to update. While it updates I typically work on other stuff.
For Excel: I discovered I can open a true new window of Excel and am able to work on it (using excel.exe /x)


But, For Word: it freezes.
So, while the Excel sheet is updating, Word 2013 is frozen. can't do anything.
I'm not sure if this relates to the Addin or just Microsoft, but was hoping someone might have a solution. (note, I never used to have this problem with Vista / Office 2007 setup)

I did figure out that Opening a SAFE version of Word gets around this (winword /safe).... which apparently prevents addins from opening (perhaps this is the best work around solution, but doesn't have all the normal Word features).




Thanks,
Steve

Tue Jun 10, 2014 1:13 pm (PDT) . Posted by:

friedman_steve

actually, just to clarify, the winword /safe command line is able to open a safe version of Word, but still freezes up when trying to work on files [again, only when the Excel Add-in is busy updating data]

Tue Jun 10, 2014 1:50 pm (PDT) . Posted by:

"andrei radulescu-banu" iubica2

I think this may be caused by the RCHGetURLData1() routine in modUtilities
- it is doing a blocking XMLHTTP Open.

One possible fix is highlighted in yellow. Just be sure you back up
your RCH_Stock_Market_Functions.xla before modifying this routine. I've
tested this on Excel 2007.

Regards,
Andrei

Public Function RCHGetURLData1(pURL As String, _
Optional ByVal pType As String = "GET") As String

'---------------------------------------------------------->
Version 2.0i
' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
' 2009.01.26 -- Allow "GET" or "POST" requests

'----------------------------------------------------------*
On Error GoTo ErrorExit
Dim oHTTP As New XMLHTTP
oHTTP.Open pType, pURL, True
oHTTP.Send

Do Until oHTTP.ReadyState = 4
DoEvents
Loop

Select Case oHTTP.Status
Case 0: RCHGetURLData1 = oHTTP.responseText
Case 200: RCHGetURLData1 = oHTTP.responseText
Case Else: GoTo ErrorExit
End Select
Exit Function
ErrorExit:
RCHGetURLData1 = vError
End Function

On Tue, Jun 10, 2014 at 4:12 PM, friedman_steve@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> actually, just to clarify, the winword /safe command line is able to open
> a safe version of Word, but still freezes up when trying to work on files
> [again, only when the Excel Add-in is busy updating data]
>
>

--
==================================
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.com, bitdribble.com
==================================

Tue Jun 10, 2014 2:03 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

When I was playing with Asynchronous calls, I made a similar change. I was
surprised at how much more freedom there was in navigation of the workbooks
while the macro was running.

Of course, true asynchronous processing would require a massive change.

On Tue, Jun 10, 2014 at 1:50 PM, andrei radulescu-banu bitdribble@... wrote:

>
> I think this may be caused by the RCHGetURLData1() routine in modUtilities
> - it is doing a blocking XMLHTTP Open.
>
> One possible fix is highlighted in yellow. Just be sure you back up
> your RCH_Stock_Market_Functions.xla before modifying this routine. I've
> tested this on Excel 2007.
>
> Regards,
> Andrei
>
> Public Function RCHGetURLData1(pURL As String, _
> Optional ByVal pType As String = "GET") As String
>
> '---------------------------------------------------------->
> Version 2.0i
> ' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include zero
> ' 2009.01.26 -- Allow "GET" or "POST" requests
>
> '----------------------------------------------------------*
> On Error GoTo ErrorExit
> Dim oHTTP As New XMLHTTP
> oHTTP.Open pType, pURL, True
> oHTTP.Send
>
> Do Until oHTTP.ReadyState = 4
> DoEvents
> Loop
>
> Select Case oHTTP.Status
> Case 0: RCHGetURLData1 = oHTTP.responseText
> Case 200: RCHGetURLData1 = oHTTP.responseText
> Case Else: GoTo ErrorExit
> End Select
> Exit Function
> ErrorExit:
> RCHGetURLData1 = vError
> End Function
>
>
>
> On Tue, Jun 10, 2014 at 4:12 PM, friedman_steve@...
> <friedman_steve@yahoo.com>wrote:
>
>>
>>
>> actually, just to clarify, the winword /safe command line is able to open
>> a safe version of Word, but still freezes up when trying to work on files
>> [again, only when the Excel Add-in is busy updating data]
>>
>
>

Tue Jun 10, 2014 2:30 pm (PDT) . Posted by:

"andrei radulescu-banu" iubica2

One thing that would be really cool, but seems impossible in VBA, is to
parallelize some of the URL downloads.

I have been lately looking at Python, which has similar ability to download
stock data from web pages (albeit I could not find a package as neatly
maintained as SMF). In Python, it's possible to spawn a pool of background
threads doing the page download in parallel. There's even a Python module
called 'pandas' that mimicks Excel table functionality.

In Excel, however, parallelism is limited - there's no API for multi
threading. At best, threads can be mimicked, but that indeed requires
radical redesign - and may not be portable to all versions of Excel.

Where Excel shines is in ease of spreadsheet setup, and graphing
capabilities. In Python, that has to be all coded on the back end, and
that's not as flexible as dragging and dropping formulas across rows and
colums in Excel. So perhaps Excel is still the simplest and most effective
of the two.

Andrei

On Tue, Jun 10, 2014 at 5:03 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> When I was playing with Asynchronous calls, I made a similar change. I was
> surprised at how much more freedom there was in navigation of the workbooks
> while the macro was running.
>
> Of course, true asynchronous processing would require a massive change.
>
> On Tue, Jun 10, 2014 at 1:50 PM, andrei radulescu-banu bitdribble@...
> wrote:
>
>>
>> I think this may be caused by the RCHGetURLData1() routine in
>> modUtilities - it is doing a blocking XMLHTTP Open.
>>
>> One possible fix is highlighted in yellow. Just be sure you back up
>> your RCH_Stock_Market_Functions.xla before modifying this routine. I've
>> tested this on Excel 2007.
>>
>> Regards,
>> Andrei
>>
>> Public Function RCHGetURLData1(pURL As String, _
>> Optional ByVal pType As String = "GET") As String
>>
>> '---------------------------------------------------------->
>> Version 2.0i
>> ' 2008.07.18 -- Expand oHTTP.Status selections for "OK" to include
>> zero
>> ' 2009.01.26 -- Allow "GET" or "POST" requests
>>
>> '----------------------------------------------------------*
>> On Error GoTo ErrorExit
>> Dim oHTTP As New XMLHTTP
>> oHTTP.Open pType, pURL, True
>> oHTTP.Send
>>
>> Do Until oHTTP.ReadyState = 4
>> DoEvents
>> Loop
>>
>> Select Case oHTTP.Status
>> Case 0: RCHGetURLData1 = oHTTP.responseText
>> Case 200: RCHGetURLData1 = oHTTP.responseText
>> Case Else: GoTo ErrorExit
>> End Select
>> Exit Function
>> ErrorExit:
>> RCHGetURLData1 = vError
>> End Function
>>
>>
>>
>> On Tue, Jun 10, 2014 at 4:12 PM, friedman_steve@...
>> <friedman_steve@yahoo.com>wrote:
>>
>>>
>>>
>>> actually, just to clarify, the winword /safe command line is able to
>>> open a safe version of Word, but still freezes up when trying to work on
>>> files [again, only when the Excel Add-in is busy updating data]
>>>
>>
>>
>
>

--
==================================
Andrei Radulescu-Banu
86 Cedar St, Lexington MA
617.216.8509 (m), 781.862.5854 (h)
lex-wiki.org, lex4lang.org,
andrei4schools.com, bitdribble.com
==================================

Tue Jun 10, 2014 10:00 pm (PDT) . Posted by:

ultimatestockfinder

Randy,
I have been successfully using your SMF Add-in formulas for the past 4 months to populate 17 data fields for over 3,500 stocks in my StockEvaluator.xls spreadsheet, and for over 1,500 mutual funds in my MutualFundEvaluator.xls spreadsheet. I run macros with DO loops that re-calculate the values of each cell one by one in both of my spreadsheets.


I refresh all the data on the weekend and post both spreadsheets to my free website Ultimate Stock Finder Home http://www.ultimatestockfinder.com/ . I have 200 followers to my free weekly Investment Idea Sharing newsletter.


This would not be possible without your wonderful and POWERFUL Stock Market Functions Add-in .


Thank you very much!! Your work is appreciated!!
John DeCamp
UltimateStockFinder.com


http://www.ultimatestockfinder.com/

Ultimate Stock Finder Home http://www.ultimatestockfinder.com/ Use our free spreadsheets to screen, evaluate and compare financial values and performance for stocks and mutual funds



View on www.ultimatestockfi... http://www.ultimatestockfinder.com/
Preview by Yahoo



Diposting oleh EXCEL FEED LEARNING di 22.00

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)