Sabtu, 24 September 2011

[smf_addin] Digest Number 1964

Messages In This Digest (17 Messages)

Messages

1a.

Update Functions

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Fri Sep 23, 2011 2:18 pm (PDT)



How can I update all the functions in a file in the same time?

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

Re: Update Functions

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

Fri Sep 23, 2011 2:21 pm (PDT)



Run the smfForceRecalculation macro -- see the "Links" area of the group for
more info. But it will update all open workbooks.

On Fri, Sep 23, 2011 at 1:50 PM, dstange1978 <danielcs@floripa.com.br>wrote:

> How can I update all the functions in a file in the same time?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: Update Functions

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Fri Sep 23, 2011 6:16 pm (PDT)



Hi Randy - when I run the smfForceRecalculation macro, it asks me if I want to run it on "all the open workbooks" or in "this workbook". I always choose "this workbook". Are you saying that whatever I choose, it will always run the macro on "all open workbooks"?

And, Randy, the more I dig and learn about the SMF Add-in, the more grateful I am for your great contribution. Thank you very much!!  

Regards,
Jose L. Jacob

From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, September 23, 2011 5:19:09 PM
Subject: Re: [smf_addin] Update Functions

 
Run the smfForceRecalculation macro -- see the "Links" area of the group for more info. But it will update all open workbooks.

On Fri, Sep 23, 2011 at 1:50 PM, dstange1978 <danielcs@floripa.com.br> wrote:

How can I update all the functions in a file in the same time?
>

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

Re: Update Functions

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

Fri Sep 23, 2011 6:33 pm (PDT)



Hmmm. I've never seen that message. Are you running EXCEL 2010? I'm sure
I've had multiple workbooks open in EXCEL 2007 when I've run the macro.

The message must be coming from the VBA invocation of the full
recalculation. However, since all stored web pages have been purged, I'm not
sure what would happen to the data from the add-in function invocations in
the other open workbooks if you choose "this workbook". I think you should
always choose "all open workbooks".

On Fri, Sep 23, 2011 at 6:16 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Hi Randy - when I run the smfForceRecalculation macro, it asks me if I want
> to run it on "all the open workbooks" or in "this workbook". I always choose
> "this workbook". Are you saying that whatever I choose, it will always run
> the macro on "all open workbooks"?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1e.

Re: Update Functions

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Fri Sep 23, 2011 6:54 pm (PDT)



I am running EXCEL 2003.
 
I press ALT-F8, get a screen where I fill the macro name, smfForceRecalculation, and there is a place where I can choose to run the macro "this workbook", "all open workbooks" or I can select one of the open workbooks by name.
 
I have the suspicion that the macro runs on all open workbooks regardless of what I choose. I just wanted to confirm with you. 

Regards,
Jose L. Jacob

From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, September 23, 2011 9:32:59 PM
Subject: Re: [smf_addin] Update Functions

 
Hmmm. I've never seen that message. Are you running EXCEL 2010? I'm sure I've had multiple workbooks open in EXCEL 2007 when I've run the macro.

The message must be coming from the VBA invocation of the full recalculation. However, since all stored web pages have been purged, I'm not sure what would happen to the data from the add-in function invocations in the other open workbooks if you choose "this workbook". I think you should always choose "all open workbooks".

On Fri, Sep 23, 2011 at 6:16 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
>Hi Randy - when I run the smfForceRecalculation macro, it asks me if I want to run it on "all the open workbooks" or in "this workbook". I always choose "this workbook". Are you saying that whatever I choose, it will always run the macro on "all open workbooks"?
>
>

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

Re: Update Functions

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

Fri Sep 23, 2011 7:03 pm (PDT)



Ah. When you said "Ask", I though you meant a message popped up each time
you ran the macro. I have the macro assigned to my toolbar, so I never have
the choice you do. I'm not even sure what that option means on the alt-F8
menu? Does "all open workbooks" mean it would cycle between each open
workbook and then rerun the macro? No -- just tried that with a test macro,
but the macro only ran on the active workbook.

My GUESS would be that the choice doesn't matter for the
smfForceRecalculation macro.

On Fri, Sep 23, 2011 at 6:54 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> I am running EXCEL 2003.
>
> I press ALT-F8, get a screen where I fill the macro name,
> smfForceRecalculation, and there is a place where I can choose to run the
> macro "this workbook", "all open workbooks" or I can select one of the open
> workbooks by name.
>
> I have the suspicion that the macro runs on all open workbooks regardless
> of what I choose. I just wanted to confirm with you.
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Data import/download

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Fri Sep 23, 2011 3:36 pm (PDT)



Why my data is imported as "2145", instead of "21,45" as it should?

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

Re: Data import/download

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

Fri Sep 23, 2011 4:10 pm (PDT)



Because of regional settings, the add-in will never convert "21,45" as you
want it to. The VBA function it uses, CDEC(), converts "21,45" to 2145.

On Fri, Sep 23, 2011 at 3:36 PM, dstange1978 <danielcs@floripa.com.br>wrote:

> Why my data is imported as "2145", instead of "21,45" as it should?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: Data import/download

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Fri Sep 23, 2011 4:51 pm (PDT)





--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Because of regional settings, the add-in will never convert "21,45" as you
> want it to. The VBA function it uses, CDEC(), converts "21,45" to 2145.
>
> On Fri, Sep 23, 2011 at 3:36 PM, dstange1978 <danielcs@...>wrote:
>
> > Why my data is imported as "2145", instead of "21,45" as it should?
> >
>
But now I noticed that there is another error type. The AA high cote, for exemple, was imported as "103104", instead of "10,31". The open, low and close prices was properly imported.
If all the quotations were imported with the same error, I could fix it with a formula. But if just some cells are incorrectly imported, I can't use the Add-in.

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

Re: Data import/download

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

Fri Sep 23, 2011 4:56 pm (PDT)



I have no idea what "AA high cote" is.

On Fri, Sep 23, 2011 at 4:51 PM, dstange1978 <danielcs@floripa.com.br>wrote:

>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Because of regional settings, the add-in will never convert "21,45" as
> you
> > want it to. The VBA function it uses, CDEC(), converts "21,45" to 2145.
> >
> > On Fri, Sep 23, 2011 at 3:36 PM, dstange1978 <danielcs@...>wrote:
> >
> > > Why my data is imported as "2145", instead of "21,45" as it should?
> > >
> >
> But now I noticed that there is another error type. The AA high cote, for
> exemple, was imported as "103104", instead of "10,31". The open, low and
> close prices was properly imported.
> If all the quotations were imported with the same error, I could fix it
> with a formula. But if just some cells are incorrectly imported, I can't use
> the Add-in.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2e.

Re: Data import/download

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Fri Sep 23, 2011 5:20 pm (PDT)





--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I have no idea what "AA high cote" is.
>
> On Fri, Sep 23, 2011 at 4:51 PM, dstange1978 <danielcs@...>wrote:
>
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Because of regional settings, the add-in will never convert "21,45" as
> > you
> > > want it to. The VBA function it uses, CDEC(), converts "21,45" to 2145.
> > >
> > > On Fri, Sep 23, 2011 at 3:36 PM, dstange1978 <danielcs@>wrote:
> > >
> > > > Why my data is imported as "2145", instead of "21,45" as it should?
> > > >
> > >
> > But now I noticed that there is another error type. The AA high cote, for
> > exemple, was imported as "103104", instead of "10,31". The open, low and
> > close prices was properly imported.
> > If all the quotations were imported with the same error, I could fix it
> > with a formula. But if just some cells are incorrectly imported, I can't use
> > the Add-in.
> >
>
Sorry,
The "high" quotation of Alcoa (AA).

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

Re: Data import/download

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

Fri Sep 23, 2011 5:57 pm (PDT)



Why would the high quote for AA ever come in as "10,31"?

What function and parameters are you using?

On Fri, Sep 23, 2011 at 5:20 PM, dstange1978 <danielcs@floripa.com.br>wrote:

> > > But now I noticed that there is another error type. The AA high cote,
> for
> > > exemple, was imported as "103104", instead of "10,31". The open, low
> and
> > > close prices was properly imported.
> > > If all the quotations were imported with the same error, I could fix it
> > > with a formula. But if just some cells are incorrectly imported, I
> can't use
> > > the Add-in.
> > >
> >
> Sorry,
> The "high" quotation of Alcoa (AA).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3a.

question for Randy regarding RCHGetElementNumber(Ticker, 1421) formu

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

Fri Sep 23, 2011 8:25 pm (PDT)



Hello Randy.I just used the RCHGetElementNumber(ticker, 1421) formula for BAC (Banc of America) and get a number that cannot be right. 1421 is the recent dividend amount. Also, the values for 1425, 1429 and 1433 are also VERY wrong. BofA is only paying 1 cent a quarter at this time, so how does this formula retrieve quarterly dividends of .42, .41, 18.13 & 1.75. Something is wrong with this. Please advise. Thanks.

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

Re: question for Randy regarding RCHGetElementNumber(Ticker, 1421) f

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

Fri Sep 23, 2011 8:31 pm (PDT)



This formula is very wrong for several stocks..just tried it with stock fitb and got similar results. Pls advise..thanks.

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> Hello Randy.I just used the RCHGetElementNumber(ticker, 1421) formula for BAC (Banc of America) and get a number that cannot be right. 1421 is the recent dividend amount. Also, the values for 1425, 1429 and 1433 are also VERY wrong. BofA is only paying 1 cent a quarter at this time, so how does this formula retrieve quarterly dividends of .42, .41, 18.13 & 1.75. Something is wrong with this. Please advise. Thanks.
>

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

Re: question for Randy regarding RCHGetElementNumber(Ticker, 1421) f

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

Fri Sep 23, 2011 8:47 pm (PDT)



It's because the element just picks up the first row dividend amount.
However, earnings.com lists dividends for all companies related to the
ticker symbol. For the banks, you're getting dividends on their preferred
issues:

http://www.earnings.com/company.asp?client=cb&ticker=bac

I'd suggest using RCHGetYahooHistory() instead.

On Fri, Sep 23, 2011 at 8:25 PM, investor952 <investor952@yahoo.com> wrote:

> Hello Randy.I just used the RCHGetElementNumber(ticker, 1421) formula for
> BAC (Banc of America) and get a number that cannot be right. 1421 is the
> recent dividend amount. Also, the values for 1425, 1429 and 1433 are also
> VERY wrong. BofA is only paying 1 cent a quarter at this time, so how does
> this formula retrieve quarterly dividends of .42, .41, 18.13 & 1.75.
> Something is wrong with this. Please advise. Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.

Re: question for Randy regarding RCHGetElementNumber(Ticker, 1421) f

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

Fri Sep 23, 2011 11:24 pm (PDT)



How would I used RCHGetYahooHistory() to get the last 4 dividends and if possible, arranged in the spreadsheet from left to right rather than verticle? thx.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It's because the element just picks up the first row dividend amount.
> However, earnings.com lists dividends for all companies related to the
> ticker symbol. For the banks, you're getting dividends on their preferred
> issues:
>
> http://www.earnings.com/company.asp?client=cb&ticker=bac
>
> I'd suggest using RCHGetYahooHistory() instead.
>
> On Fri, Sep 23, 2011 at 8:25 PM, investor952 <investor952@...> wrote:
>
> > Hello Randy.I just used the RCHGetElementNumber(ticker, 1421) formula for
> > BAC (Banc of America) and get a number that cannot be right. 1421 is the
> > recent dividend amount. Also, the values for 1425, 1429 and 1433 are also
> > VERY wrong. BofA is only paying 1 cent a quarter at this time, so how does
> > this formula retrieve quarterly dividends of .42, .41, 18.13 & 1.75.
> > Something is wrong with this. Please advise. Thanks.
> >
>

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

Re: question for Randy regarding RCHGetElementNumber(Ticker, 1421) f

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

Fri Sep 23, 2011 11:46 pm (PDT)



Try something like:

=INDEX(TRANSPOSE(RCHGetYahooHistory(C15,,,,,,,"v",,0,,,4,2)),2)

On Fri, Sep 23, 2011 at 11:24 PM, investor952 <investor952@yahoo.com> wrote:

> How would I used RCHGetYahooHistory() to get the last 4 dividends and if
> possible, arranged in the spreadsheet from left to right rather than
> verticle? thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

Need traffic?

Drive customers

With search ads

on Yahoo!

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 03.16

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)