I retrieve data on about 40 companies using the template file called SMF-Template-Yahoo-Key-Statistics. I use a macro which copies tickers in Column A into the template and then copies the page into a new page titled with the corresponding ticker.

Until today this macro has been running quickly and successfully on Excel 2007. I updated to Excel 2010 today and its now running very slow and most of the time stalling before completion. Have you come across this problem before? any advice would be much appreciated.

File attached.

Thanks and regards, Andrew

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: SMF-Template-Yahoo-Key-Statistics

Tue Aug 28, 2012 5:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Most likely a temporary issue with Yahoo. Were you just running it? This
time of morning can be sporadic with Yahoo, because of maintenance and
updates that they do overnight.

Given the nature of what you're doing, I would think the
smfUpdateDownloadTable macro might be a better way to go (see the LINKS
area of the group for more info).

On Tue, Aug 28, 2012 at 4:56 AM, andrewhills97 <andrewhills97@yahoo.com>wrote:

> I retrieve data on about 40 companies using the template file called
> SMF-Template-Yahoo-Key-Statistics. I use a macro which copies tickers in
> Column A into the template and then copies the page into a new page titled
> with the corresponding ticker.
>
> Until today this macro has been running quickly and successfully on Excel
> 2007. I updated to Excel 2010 today and its now running very slow and most
> of the time stalling before completion. Have you come across this problem
> before? any advice would be much appreciated.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: SMF-Template-Yahoo-Key-Statistics

Tue Aug 28, 2012 7:47 am (PDT) . Posted by:

"zarathustra_winced@yahoo.com" zarathustra_winced

What kind of processor do you have? Go to the File tab, Options, Advanced in Excel 2010 and make sure the Enable Multi Threaded Calculation setting is appropriate for your processor. When I used to run excel 2010 on an old pentium IV, it would bog down to a crawl when multi-threaded calc was enabled. For multi-core, make sure the settings make sense. This has helped me in the past, but your problem may be something different.

K
Sent via BlackBerry by AT&T

-----Original Message-----
From: "andrewhills97" <andrewhills97@yahoo.com>
Sender: smf_addin@yahoogroups.com
Date: Tue, 28 Aug 2012 11:56:33
To: <smf_addin@yahoogroups.com>
Reply-To: smf_addin@yahoogroups.com
Subject: [smf_addin] SMF-Template-Yahoo-Key-Statistics

I retrieve data on about 40 companies using the template file called SMF-Template-Yahoo-Key-Statistics. I use a macro which copies tickers in Column A into the template and then copies the page into a new page titled with the corresponding ticker.

Until today this macro has been running quickly and successfully on Excel 2007. I updated to Excel 2010 today and its now running very slow and most of the time stalling before completion. Have you come across this problem before? any advice would be much appreciated.

File attached.

Thanks and regards, Andrew

------------------------------------

Yahoo! Groups Links

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

problem to fix

Tue Aug 28, 2012 9:14 am (PDT) . Posted by:

"nikosv72" nikosv72

hi,

how can a find the followings...

5-Year Annual Revenue Growth
1-Year Revenue Growth
Gross Margin
Net Margin
Debt to Equity
Current Ratio
Return on Equity
Normalized P/E
Current Yield
5-Year Dividend Growth

if anybody can help me with these

many thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: problem to fix

Tue Aug 28, 2012 9:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do a few filters on the XLS file that was distributed in the add-in ZIP
file. You should find elements for most of those in there.

On Tue, Aug 28, 2012 at 8:47 AM, nikosv72 <nikosv72@yahoo.com> wrote:

>
> how can a find the followings...
>
> 5-Year Annual Revenue Growth
> 1-Year Revenue Growth
> Gross Margin
> Net Margin
> Debt to Equity
> Current Ratio
> Return on Equity
> Normalized P/E
> Current Yield
> 5-Year Dividend Growth
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

SMF addin giving error with "#VALUE!"

Tue Aug 28, 2012 9:14 am (PDT) . Posted by:

"d3vil" d3vil

Hi Randy

I'm trying to use your addin in excel 2010, but am getting this error.
#VALUE!

See screenshot of the error i'm getting
http://s13.postimage.org/yxpzc9w3r/smfaddin.jpg

I installed it via options -> addins..
Created a new workbook and followed the steps here:

http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/

Any ideas?

Thanks!

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: SMF addin giving error with "#VALUE!"

Tue Aug 28, 2012 9:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're using the wrong characters for the double quotes on the string...

On Tue, Aug 28, 2012 at 7:41 AM, d3vil <d3vil@yahoo.com> wrote:

>
> I'm trying to use your addin in excel 2010, but am getting this error.
> #VALUE!
>
> See screenshot of the error i'm getting
> http://s13.postimage.org/yxpzc9w3r/smfaddin.jpg
>
> I installed it via options -> addins..
> Created a new workbook and followed the steps here:
>
>
> http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/
>
> Any ideas?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4a

1000 input tickers worksheet

Tue Aug 28, 2012 9:15 am (PDT) . Posted by:

"grfreem" grfreem

I've been using the "1000 tickers" worksheet for a couple of months now with no issues. Late last week when I hit the "Refresh Data" button, I received the error message "Automation Error Unspecified Error". Has anyone run into this issue before?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4b

Re: 1000 input tickers worksheet

Tue Aug 28, 2012 9:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've not seen it...

On Tue, Aug 28, 2012 at 6:17 AM, grfreem <gfreem@acxiom.com> wrote:

> I've been using the "1000 tickers" worksheet for a couple of months now
> with no issues. Late last week when I hit the "Refresh Data" button, I
> received the error message "Automation Error Unspecified Error". Has
> anyone run into this issue before?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

5a

ADVFN - RCHGetHTMLTable not working for me

Tue Aug 28, 2012 7:20 pm (PDT) . Posted by:

"cdtrad123" cdtrad123

Hi Randy (and all others),

Great addin you have here, truly impressed.

I'm currently trying to use the RCHGetHTMLTable function to retrieve information from ADVFN, namely the key ratios. This website seems to have most ratios in an easy to review format. However I'm having all sorts of problems getting the function to work. An example of the function is below:

-----------------------------------------------------
=RCHGetHTMLTable("http://au.advfn.com/p.php?pid--=financials&symbol=NASDAQ%AAPL", "Yesterday's Close",-1,"",1)
----------------------------------------------------

I've tried variations of the above with very little success.

Any ideas?!

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

5b

Re: ADVFN - RCHGetHTMLTable not working for me

Tue Aug 28, 2012 8:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your URL is totally hosed. The two hyphens destroy it, and the percentage
in the middle of the ticker symbol makes it invalid. Try:

=RCHGetHTMLTable("
http://au.advfn.com/p.php?pid=financials&symbol=NASDAQ:AAPL", "Yesterday's
Close",-1,"",1)

On Tue, Aug 28, 2012 at 7:20 PM, cdtrad123 <clinton.hofman@gmail.com> wrote:

>
> I'm currently trying to use the RCHGetHTMLTable function to retrieve
> information from ADVFN, namely the key ratios. This website seems to have
> most ratios in an easy to review format. However I'm having all sorts of
> problems getting the function to work. An example of the function is below:
>
> -----------------------------------------------------
> =RCHGetHTMLTable("
> http://au.advfn.com/p.php?pid--=financials&symbol=NASDAQ%AAPL",
> "Yesterday's Close",-1,"",1)
> ----------------------------------------------------
>
> I've tried variations of the above with very little success.
>
> Any ideas?!
>