Minggu, 25 September 2011

[smf_addin] Digest Number 1965

Messages In This Digest (10 Messages)

1a.
Re: Data import/download From: dstange1978
1b.
Re: Data import/download From: Randy Harmelink
1c.
Re: Data import/download From: dstange1978
2a.
Re: Update Functions From: Rick Bullen
2b.
Re: Update Functions From: Jacob Jose
2c.
Re: Update Functions From: Randy Harmelink
3a.
Update times for dividend yields From: bullenr
3b.
Re: Update times for dividend yields From: Randy Harmelink
4a.
Re: SMFLowBetween From: krisha_mehta
4b.
Re: SMFLowBetween From: Randy Harmelink

Messages

1a.

Re: Data import/download

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

Sat Sep 24, 2011 4:00 am (PDT)



I'm using: =RCHGetYahooQuotes(H1:H160;"sd1ohgl1")

In most of cases, the function returns two more decimal places that it should. If it was always, would be ok. But in some cases, the function returns (or invents) three or even four more decimal places. Like this:
Symbol Date Open High Low Close
AA 9/23/2011 1003 103104 995 1007

When the correct values should be:
Symbol Date Open High Low Close
AA 9/23/2011 10.03 10.31 9.95 10.07

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...>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 (9)
1b.

Re: Data import/download

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

Sat Sep 24, 2011 8:24 am (PDT)



This is what Yahoo returns:

"AA","9/23/2011",10.03,10.3104,9.95,10.07

So it must be that your regional settings are telling VBA to interpret those
decimal points differently than the U.S. definitions.

On Sat, Sep 24, 2011 at 4:00 AM, dstange1978 <danielcs@floripa.com.br>wrote:

> I'm using: =RCHGetYahooQuotes(H1:H160;"sd1ohgl1")
>
> In most of cases, the function returns two more decimal places that it
> should. If it was always, would be ok. But in some cases, the function
> returns (or invents) three or even four more decimal places. Like this:
> Symbol Date Open High Low Close
> AA 9/23/2011 1003 103104 995 1007
>
> When the correct values should be:
> Symbol Date Open High Low Close
> AA 9/23/2011 10.03 10.31 9.95 10.07
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
1c.

Re: Data import/download

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

Sat Sep 24, 2011 12:00 pm (PDT)



I did it!
I had already tried change the settings of Excel, but had not worked. Changing the settings of Windows, worked! (In here (Brazil), we use the comma as decimal separator)
Thanks a lot!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This is what Yahoo returns:
>
> "AA","9/23/2011",10.03,10.3104,9.95,10.07
>
> So it must be that your regional settings are telling VBA to interpret those
> decimal points differently than the U.S. definitions.
>
> On Sat, Sep 24, 2011 at 4:00 AM, dstange1978 <danielcs@...>wrote:
>
> > I'm using: =RCHGetYahooQuotes(H1:H160;"sd1ohgl1")
> >
> > In most of cases, the function returns two more decimal places that it
> > should. If it was always, would be ok. But in some cases, the function
> > returns (or invents) three or even four more decimal places. Like this:
> > Symbol Date Open High Low Close
> > AA 9/23/2011 1003 103104 995 1007
> >
> > When the correct values should be:
> > Symbol Date Open High Low Close
> > AA 9/23/2011 10.03 10.31 9.95 10.07
> >
>

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

Re: Update Functions

Posted by: "Rick Bullen" rick.bullen@gmail.com   bullenr

Sat Sep 24, 2011 8:19 am (PDT)



Alt F8 is the Run Macro dialog box. The selection you refer to, called
"Macros In:", controls what macros appear and are selectable in the list box
above it. It doesnt control the workbooks to which the macro that is run
applies to.
On Fri, Sep 23, 2011 at 9: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.
>
> 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"?
>
>
>
>
>
>

--
Rick Bullen
rick.bullen@gmail.com
914-330-6073 Cell
631-980-4071 Fax
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2b.

Re: Update Functions

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

Sat Sep 24, 2011 9:36 am (PDT)



Hmmm, it make sense, thank you very much. In my case I don't get any selectable macros in the list box. Do I have to do something special to have the macros in the list box, so I can select the one I want to run? I always have to type the macro name.

Regards,
Jose L. Jacob

From: Rick Bullen <rick.bullen@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 24, 2011 11:18:05 AM
Subject: Re: [smf_addin] Update Functions

 
Alt F8 is the Run Macro dialog box. The selection you refer to, called "Macros In:", controls what macros appear and are selectable in the list box above it. It doesnt control the workbooks to which the macro that is run applies to.

On Fri, Sep 23, 2011 at 9: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. 
>
>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"?
>>
>>
>
>
>

--
Rick Bullen
rick.bullen@gmail.com
914-330-6073 Cell
631-980-4071 Fax

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

Re: Update Functions

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

Sat Sep 24, 2011 10:30 am (PDT)



Macros from add-ins don't show up on the list. I added a button to my
toolbar for the macro.

On Sat, Sep 24, 2011 at 9:36 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Hmmm, it make sense, thank you very much. In my case I don't get any
> selectable macros in the list box. Do I have to do something special to have
> the macros in the list box, so I can select the one I want to run? I always
> have to type the macro name.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
3a.

Update times for dividend yields

Posted by: "bullenr" rick.bullen@gmail.com   bullenr

Sat Sep 24, 2011 8:38 am (PDT)



I am using the =RCHGetYahooQuotes function with the "y" code to get dividend yields. Is this data daily? It appears to be. Do you know what time of day the update occurs?

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

Re: Update times for dividend yields

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

Sat Sep 24, 2011 8:39 am (PDT)



Sounds like a question for Yahoo...

On Sat, Sep 24, 2011 at 8:38 AM, bullenr <rick.bullen@gmail.com> wrote:

> I am using the =RCHGetYahooQuotes function with the "y" code to get
> dividend yields. Is this data daily? It appears to be. Do you know what time
> of day the update occurs?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Re: SMFLowBetween

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

Sat Sep 24, 2011 1:52 pm (PDT)





Hi Randy,
After your suggestion I have been using smfPricesBetween(..), but that seems have similar issue
Ex -
smfPricesBetween("SLV",DATE("1/1/2010"), NOW(),"06") returns 14.37, but it should be something like 27.39. Again, I really need this work right since I am using it in multiple places. Maybe I am missing something?

Thanks in advance,
Maunang

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The smfPricesBetween() function came about because of that function...
>
> On Fri, Feb 18, 2011 at 7:25 AM, krisha_mehta <krisha_mehta@...>wrote:
>
> > Thanks once again Randy for prompt response. If the SMFLowBetween is not
> > supported, due you suggest any other function I should use. It's important
> > for me to get this information correctly - For a ticker the lowest value for
> > a given date range?
> >
>

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

Re: SMFLowBetween

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

Sat Sep 24, 2011 2:13 pm (PDT)



You can't be using what you have in your example -- DATE() requires three
numeric parameters.

In any case, $14.37 looks correct to me:

http://finance.yahoo.com/q/hp?s=SLV&a=01&b=5&c=2010&d=01&e=5&f=2010&g=d

Date Open High Low Close Volume Adj Close* Feb 5, 2010 14.87 14.94 14.37
14.90 31,691,600 14.90

On Sat, Sep 24, 2011 at 1:52 PM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

>
> After your suggestion I have been using smfPricesBetween(..), but that
> seems have similar issue
> Ex -
> smfPricesBetween("SLV",DATE("1/1/2010"), NOW(),"06") returns 14.37, but it
> should be something like 27.39. Again, I really need this work right since I
> am using it in multiple places. Maybe I am missing something?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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 02.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)