Messages In This Digest (9 Messages)
- 1a.
- Re: Just started From: John Zman
- 1b.
- Re: Just started From: Randy Harmelink
- 2a.
- Program does not update From: ctwilliams4225
- 2b.
- Re: Program does not update From: Randy Harmelink
- 3a.
- rchgetyahooquotes array From: mic_peg
- 3b.
- Re: rchgetyahooquotes array From: mic_peg
- 3c.
- Re: rchgetyahooquotes array From: Randy Harmelink
- 3d.
- Re: rchgetyahooquotes array From: mic_peg
- 3e.
- Re: rchgetyahooquotes array From: Randy Harmelink
Messages
- 1a.
-
Re: Just started
Posted by: "John Zman" john.zman@yahoo.com john.zman
Thu Nov 3, 2011 3:32 am (PDT)
Thanks for the information. I tried smfGetOptionQuotes() but it didn't work. Can you point me to a site or source where I can get info on it along with arguments, etc?
Thanks
--- On Thu, 11/3/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Just started
To: smf_addin@yahoogroups.com
Date: Thursday, November 3, 2011, 2:32 AM
The Yahoo quotes interface, which is what RCHGetYahooQuotes() uses, hasn't supported option quotes since option symbols changed early last year. Take a look at the smfGetOptionQuotes( ) function.
You may be getting an option quote on their web page, but click on the "Download Data" link on that web page -- that's the interface that RCHGetYahooQuotes() uses, because it allows retrieval of multiple data items on up to 200 ticker symbols with a single internet access. But that link right now returns "N/A" for almost all data fields.
On Wed, Nov 2, 2011 at 6:45 PM, John Zman <john.zman@yahoo.com > wrote:
I just started using the rchgetyahooquotes. I am running XP with Excel 2007. Had no problem installing or using the add-in ( great description of add-ins here -> http://peltiertech.com/WordPress/ installing- an-add-in- in-excel- 2007/
I can get stock quotes easily, but not option quotes. I build the option symbol string using VBA, and if I copy/paste the option symbol directly to Yahoo Finance it gives me a quote. BUT, it won't work using the function call. Anyone have any ideas why this is? Am I failing to use this properly, or does it only accept shorter string
lengths?
- 1b.
-
Re: Just started
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Nov 3, 2011 4:36 am (PDT)
The "Documentation" folder of the files area contains function
documentation.
On Thu, Nov 3, 2011 at 3:32 AM, John Zman <john.zman@yahoo.com > wrote:
>
> Thanks for the information. I tried smfGetOptionQuotes() but it didn't
> work. Can you point me to a site or source where I can get info on it along
> with arguments, etc?
>
- 2a.
-
Program does not update
Posted by: "ctwilliams4225" ctwilliams4225@gmail.com ctwilliams4225
Thu Nov 3, 2011 7:52 am (PDT)
I have installed all Excel-Add-in and have the files in the proper c:\smf\ folder. However, it does not update the data in the excel sheet. I am obviously missing something. Help!
- 2b.
-
Re: Program does not update
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Nov 3, 2011 11:02 am (PDT)
Check out the "Links" area of the group, specifically items 0.2, 9.5, and
9.4.2.
Not all of us have the add-in in the same location, which means links can't
get resolved automatically because of how EXCEL processes them.
On Thu, Nov 3, 2011 at 7:35 AM, ctwilliams4225 <ctwilliams4225@gmail.com >wrote:
> I have installed all Excel-Add-in and have the files in the proper c:\smf\
> folder. However, it does not update the data in the excel sheet. I am
> obviously missing something. Help!
>
- 3a.
-
rchgetyahooquotes array
Posted by: "mic_peg" mic_peg@yahoo.com mic_peg
Fri Nov 4, 2011 12:03 am (PDT)
hi,
tried to use array for rchgetyahooquotes. not working..
B3 to B19 is AUD,CAD,CHF
C2 to E2 is AUD,CAD,CHF
C3 to E5 is formulated by {=RCHGetYahooQuotes($B3:$B5& C$2:E$2&" =X","l1d1" )}
how do i resolve to get above to work. thanks !
- 3b.
-
Re: rchgetyahooquotes array
Posted by: "mic_peg" mic_peg@yahoo.com mic_peg
Fri Nov 4, 2011 12:08 am (PDT)
sorry it should be b3 to b5 not b19.
--- In smf_addin@yahoogroups.com , "mic_peg" <mic_peg@...> wrote:
>
> hi,
>
> tried to use array for rchgetyahooquotes. not working..
>
> B3 to B19 is AUD,CAD,CHF
> C2 to E2 is AUD,CAD,CHF
> C3 to E5 is formulated by {=RCHGetYahooQuotes($B3:$B5& C$2:E$2&" =X","l1d1" )}
>
> how do i resolve to get above to work. thanks !
>
- 3c.
-
Re: rchgetyahooquotes array
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Nov 4, 2011 12:28 am (PDT)
This:
$B3:$B5&C$2:E$2&"=X"
...is basically just:
$B3&C$2&"=X"
You can't concatenate ranges of text -- it just uses the first cell in the
range. For a 3x3 array like that, you would need to do nine individual sets
of concatenations, all concatenated together.
On Fri, Nov 4, 2011 at 12:03 AM, mic_peg <mic_peg@yahoo.com > wrote:
>
> tried to use array for rchgetyahooquotes. not working..
>
> B3 to B19 is AUD,CAD,CHF
> C2 to E2 is AUD,CAD,CHF
> C3 to E5 is formulated by {=RCHGetYahooQuotes($B3:$B5& C$2:E$2&" =X","l1d1" )}
>
> how do i resolve to get above to work. thanks !
>
- 3d.
-
Re: rchgetyahooquotes array
Posted by: "mic_peg" mic_peg@yahoo.com mic_peg
Fri Nov 4, 2011 12:37 am (PDT)
thanks..
however if i tried to array the below, it works good:
{=$B3:$B5&C$2:e$2&"=X" }, it returns value in cell c3 to e5 as
AUDAUD=X AUDCAD=X AUDCHF=X
CADAUD=X CADCAD=X CADCHF=X
CHFAUD=X CHFCAD=X CHFCHF=X
so i was thinking if i could include the ($B3:$B5&C$2:e$2&"=X") as part of rchgetyahooquotes.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This:
>
> $B3:$B5&C$2:E$2&"=X"
>
> ...is basically just:
>
> $B3&C$2&"=X"
>
> You can't concatenate ranges of text -- it just uses the first cell in the
> range. For a 3x3 array like that, you would need to do nine individual sets
> of concatenations, all concatenated together.
>
> On Fri, Nov 4, 2011 at 12:03 AM, mic_peg <mic_peg@...> wrote:
>
> >
> > tried to use array for rchgetyahooquotes. not working..
> >
> > B3 to B19 is AUD,CAD,CHF
> > C2 to E2 is AUD,CAD,CHF
> > C3 to E5 is formulated by {=RCHGetYahooQuotes($B3:$B5& C$2:E$2&" =X","l1d1" )}
> >
> > how do i resolve to get above to work. thanks !
> >
>
- 3e.
-
Re: rchgetyahooquotes array
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Nov 4, 2011 1:11 am (PDT)
The first input to the function has to be either a string or a range. What
your calculation will return is an array of data -- which is not the same
thing as a range.
What you could do is create your 3x3 array below and then do:
=RCHGetYahooQuotes(C3:E5,"l1d1" )
...over a 9-row by 2-column range.
I'm curious what you were trying to do, since you were entering your
original formula over a 3 by 3 range, but asking the function to return 18
data items as a 9 by 2 array?
On Fri, Nov 4, 2011 at 12:37 AM, mic_peg <mic_peg@yahoo.com > wrote:
>
> however if i tried to array the below, it works good:
> {=$B3:$B5&C$2:e$2&"=X" }, it returns value in cell c3 to e5 as
> AUDAUD=X AUDCAD=X AUDCHF=X
> CADAUD=X CADCAD=X CADCHF=X
> CHFAUD=X CHFCAD=X CHFCHF=X
>
> so i was thinking if i could include the ($B3:$B5&C$2:e$2&"=X") as part of
> rchgetyahooquotes.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar