Rabu, 19 Oktober 2011

[smf_addin] Digest Number 1990

Messages In This Digest (9 Messages)

Messages

1a.

SMF Add-in Funktions don't run from USB

Posted by: "stuermer001" stuermer@bigmir.net   stuermer001

Tue Oct 18, 2011 5:11 am (PDT)



Hallo,

I have an Excel file with AddIn fuctions in cells. If I open this file on drive C the function run, but if I copy the file to USB Flash-Drive and open it from there, they don't run. What could be the reason?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.

Re: SMF Add-in Funktions don't run from USB

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Tue Oct 18, 2011 9:20 am (PDT)



The AddIn function should be in C:\Program Files\SMF Add-In.  When you copy the file to the USB Flash Drive, it is looking for the AddIn to be on the USB Flash Drive.

Click on Edit/Links in Excel to correct the Link.

Ron

P.S.  I am sure that Randy has a more descriptive explanation. 

>________________________________
>From: stuermer001 <stuermer@bigmir.net>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, October 18, 2011 7:11 AM
>Subject: [smf_addin] SMF Add-in Funktions don't run from USB
>
>
> 
>Hallo,
>
>I have an Excel file with AddIn fuctions in cells. If I open this file on drive C the function run, but if I copy the file to USB Flash-Drive and open it from there, they don't run. What could be the reason?
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: SMF Add-in Funktions don't run from USB

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Oct 18, 2011 10:08 am (PDT)



I'd need a better description of "they don't run".

I suspect you just have unresolved links that you need to fix, but I'm not
sure why that would occur if you move the EXCEL workbook to the USB drive.
Unresolved links usually occur when the add-in is located in a different
location from when the workbook was saved.

On Tue, Oct 18, 2011 at 5:11 AM, stuermer001 <stuermer@bigmir.net> wrote:

>
> I have an Excel file with AddIn fuctions in cells. If I open this file on
> drive C the function run, but if I copy the file to USB Flash-Drive and open
> it from there, they don't run. What could be the reason?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Is there a parameter for a stock's Beta for the RCHGetYahooQuotes fu

Posted by: "pjwdoyle" pjwdoyle@yahoo.com   pjwdoyle

Tue Oct 18, 2011 9:37 am (PDT)



Beta is available on the Yahoo! finance "Key Statistics" page, but I can't figure out how to import it into a cell.

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: Is there a parameter for a stock's Beta for the RCHGetYahooQuote

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Oct 18, 2011 10:16 am (PDT)



As far as I know, Yahoo doesn't carry beta on it's CSV quotes file
processing. You can pick it up with either the RCHGetElementNumber() or
RCHGetTableCell() function. However, that could be significantly slower than
an array-entered RCHGetYahooQuotes() function, because you'd need to
retrieve a new web page for each ticker symbol.

On Tue, Oct 18, 2011 at 8:13 AM, pjwdoyle <pjwdoyle@yahoo.com> wrote:

> Beta is available on the Yahoo! finance "Key Statistics" page, but I can't
> figure out how to import it into a cell.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: Extracting data from Google Finance

Posted by: "skml88" skml88@gmail.com   skml88

Tue Oct 18, 2011 7:59 pm (PDT)



OK. I got the utilities after removing the older version and re-installing the latest one. Thanks so much for your help. You're the greatest!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> smfWord() and smfJoin() should be in the 2.1.2011.04.03 version of the
> add-in. They were added to the add-in on 2011-02-16, and are still there in
> my version of the add-in. In general, you wouldn't use smfConvertData(), as
> it is a utility routine for other add-in functions.
>
> On Mon, Oct 17, 2011 at 7:31 PM, skml88 <skml88@...> wrote:
>
> >
> > I can't find the smfWord utility (along with others like smfJoin and
> > smfConvertData). I am using the latest Version 2.1.2011.04.03 of the add-in.
> >
> > Is it a problem with my PC, or have these utilities been removed?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4a.

Trouble with pulling Google data elements

Posted by: "smaduck" smaduck@yahoo.com   smaduck

Tue Oct 18, 2011 9:36 pm (PDT)



Hi,

I am having trouble using RCHGetElementNumber to pull Google elements. I read through some older posts and I tried running the smfForceRecalculation macro, but I am still having the same issue. The formula seems to work fine for Yahoo and MSN elements, but Google always returns a "Error" message. Do you have any suggestions, or can you lead to me any specific posts where you may have covered this in the past?

Thanks so much for your help.

Sean

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4b.

Re: Trouble with pulling Google data elements

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Oct 18, 2011 9:52 pm (PDT)



You probably just need the updated element definitions, which you can find
in the "Works in Progress" folder of the files area.

On Tue, Oct 18, 2011 at 9:36 PM, smaduck <smaduck@yahoo.com> wrote:

>
> I am having trouble using RCHGetElementNumber to pull Google elements. I
> read through some older posts and I tried running the smfForceRecalculation
> macro, but I am still having the same issue. The formula seems to work fine
> for Yahoo and MSN elements, but Google always returns a "Error" message. Do
> you have any suggestions, or can you lead to me any specific posts where you
> may have covered this in the past?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
4c.

Re: Trouble with pulling Google data elements

Posted by: "smaduck" smaduck@yahoo.com   smaduck

Tue Oct 18, 2011 10:24 pm (PDT)



Thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You probably just need the updated element definitions, which you can find
> in the "Works in Progress" folder of the files area.
>
> On Tue, Oct 18, 2011 at 9:36 PM, smaduck <smaduck@...> wrote:
>
> >
> > I am having trouble using RCHGetElementNumber to pull Google elements. I
> > read through some older posts and I tried running the smfForceRecalculation
> > macro, but I am still having the same issue. The formula seems to work fine
> > for Yahoo and MSN elements, but Google always returns a "Error" message. Do
> > you have any suggestions, or can you lead to me any specific posts where you
> > may have covered this in the past?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! News

Fashion News

What's the word on

fashion and style?

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 01.52

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)