4 New Messages
Digest #2345
| |
Messages
Thu Sep 13, 2012 5:27 am (PDT) . Posted by:
"dguillett1" donaldb36
Try this.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: ds5ec
Sent: Thursday, September 13, 2012 3:06 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into an array
Yes, there wasn't the data on Yahoo. It didn't occur to me that the amount of history wasn't the same for each symbol. Thanks very much for your help.
--- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That looks like it should work to me. I suspect the issues you're having
> troubles with only have that much history on Yahoo...
>
> On Mon, Sep 10, 2012 at 11:23 AM, ds5ec <ds5ec@...> wrote:
>
> > Hello, firstly I'd like to says thanks for providing such a useful set of
> > functions.
> > I'm not sure if RCHGetYahooHistory was intended to be read into an array
> > but it has been working. I have a loop that runs once for each stock I'm
> > interested in. The data is read into the array in the line below:
> >
> > SP500Array = RCHGetYahooHistory(StockName, _
> > pResort:=0, _
> > pNames:=0, _
> > pItems:="DOHLCAV", _
> > pAdjust:=1, _
> > pDim1:=270, _
> > pDim2:=7)
> >
> > The array is dimensioned as Public SP500Array() As Variant. The data is
> > processed for each StockName and stored, then StockName is updated and the
> > process repeated. I recently increased the number of stocks and found that
> > at the 70th stock the function return no data in all elements from 238
> > (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred
> > on the 75th stock.
> > Should I not use the function this way or would you expect it to work.
> >
>
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: ds5ec
Sent: Thursday, September 13, 2012 3:06 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into an array
Yes, there wasn't the data on Yahoo. It didn't occur to me that the amount of history wasn't the same for each symbol. Thanks very much for your help.
--- In mailto:smf_addin%
>
> That looks like it should work to me. I suspect the issues you're having
> troubles with only have that much history on Yahoo...
>
> On Mon, Sep 10, 2012 at 11:23 AM, ds5ec <ds5ec@...> wrote:
>
> > Hello, firstly I'd like to says thanks for providing such a useful set of
> > functions.
> > I'm not sure if RCHGetYahooHistory was intended to be read into an array
> > but it has been working. I have a loop that runs once for each stock I'm
> > interested in. The data is read into the array in the line below:
> >
> > SP500Array = RCHGetYahooHistory(
> > pResort:=0, _
> > pNames:=0, _
> > pItems:="DOHLCAV"
> > pAdjust:=1, _
> > pDim1:=270, _
> > pDim2:=7)
> >
> > The array is dimensioned as Public SP500Array() As Variant. The data is
> > processed for each StockName and stored, then StockName is updated and the
> > process repeated. I recently increased the number of stocks and found that
> > at the 70th stock the function return no data in all elements from 238
> > (data in 1 to 237 is there). I reduced pDim1 to 182 and the issue occurred
> > on the 75th stock.
> > Should I not use the function this way or would you expect it to work.
> >
>
Attachments with this message:
1 of 1 File(s)
Thu Sep 13, 2012 8:58 am (PDT) . Posted by:
"Ron Spruell" hashky
Very Nice!
Ron Spruell
>________________________________
> From: dguillett1 <dguillett1@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, September 13, 2012 7:27 AM
>Subject: Re: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into an array [1 Attachment]
>
>
>
>[Attachment(s) from dguillett1 included below]
>Try this.
>
>Don
Guillett
>Microsoft Excel Developer
>SalesAid
Software
>dguillett1@gmail.com
>
>From: ds5ec
>Sent: Thursday, September 13, 2012 3:06 AM
>To: smf_addin@yahoogroups.com
>Subject: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into
an array
>
>
>Yes, there wasn't the data on Yahoo. It didn't occur to me that the amount of
history wasn't the same for each symbol. Thanks very much for your
help.
>
>--- In mailto:smf_addin%40yahoogroups.com,
Randy Harmelink <rharmelink@...> wrote:
>>
>> That looks like it
should work to me. I suspect the issues you're having
>> troubles with only
have that much history on Yahoo...
>>
>> On Mon, Sep 10, 2012 at
11:23 AM, ds5ec <ds5ec@...> wrote:
>>
>> > Hello, firstly
I'd like to says thanks for providing such a useful set of
>> >
functions.
>> > I'm not sure if RCHGetYahooHistory was intended to be
read into an array
>> > but it has been working. I have a loop that runs
once for each stock I'm
>> > interested in. The data is read into the
array in the line below:
>> >
>> > SP500Array =
RCHGetYahooHistory(StockName, _
>> > pResort:=0, _
>> >
pNames:=0, _
>> > pItems:="DOHLCAV", _
>> > pAdjust:=1,
_
>> > pDim1:=270, _
>> > pDim2:=7)
>> >
>> >
The array is dimensioned as Public SP500Array() As Variant. The data is
>>
> processed for each StockName and stored, then StockName is updated and
the
>> > process repeated. I recently increased the number of stocks and
found that
>> > at the 70th stock the function return no data in all
elements from 238
>> > (data in 1 to 237 is there). I reduced pDim1 to
182 and the issue occurred
>> > on the 75th stock.
>> > Should I
not use the function this way or would you expect it to work.
>>
>
>>
>
>
>
>
>
Ron Spruell
>___________
> From: dguillett1 <dguillett1@gmail.
>To: smf_addin@yahoogrou
>Sent: Thursday, September 13, 2012 7:27 AM
>Subject: Re: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into an array [1 Attachment]
>
>
>
>[Attachment(
>Try this.
>
>Don
Guillett
>Microsoft Excel Developer
>SalesAid
Software
>dguillett1@gmail.
>
>From: ds5ec
>Sent: Thursday, September 13, 2012 3:06 AM
>To: smf_addin@yahoogrou
>Subject: [smf_addin] Re: Using VBA to read RCHGetYahooHistory into
an array
>
>
>Yes, there wasn't the data on Yahoo. It didn't occur to me that the amount of
history wasn't the same for each symbol. Thanks very much for your
help.
>
>--- In mailto:smf_addin%
Randy Harmelink <rharmelink@
>>
>> That looks like it
should work to me. I suspect the issues you're having
>> troubles with only
have that much history on Yahoo...
>>
>> On Mon, Sep 10, 2012 at
11:23 AM, ds5ec <ds5ec@...> wrote:
>>
>> > Hello, firstly
I'd like to says thanks for providing such a useful set of
>> >
functions.
>> > I'm not sure if RCHGetYahooHistory was intended to be
read into an array
>> > but it has been working. I have a loop that runs
once for each stock I'm
>> > interested in. The data is read into the
array in the line below:
>> >
>> > SP500Array =
RCHGetYahooHistory(
>> > pResort:=0, _
>> >
pNames:=0, _
>> > pItems:="DOHLCAV"
>> > pAdjust:=1,
_
>> > pDim1:=270, _
>> > pDim2:=7)
>> >
>> >
The array is dimensioned as Public SP500Array() As Variant. The data is
>>
> processed for each StockName and stored, then StockName is updated and
the
>> > process repeated. I recently increased the number of stocks and
found that
>> > at the 70th stock the function return no data in all
elements from 238
>> > (data in 1 to 237 is there). I reduced pDim1 to
182 and the issue occurred
>> > on the 75th stock.
>> > Should I
not use the function this way or would you expect it to work.
>>
>
>>
>
>
>
>
>
Thu Sep 13, 2012 8:07 am (PDT) . Posted by:
"rr76012" rr76012
Hello Randy,
Do you think Yahoo will fix this anytime soon? Many fields are returning "N/A" or "0".
thanks,
rr76012
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's what Yahoo is sending on the CSV file...
>
> On Sat, Sep 8, 2012 at 9:50 AM, charles <chasjohn02@...> wrote:
>
> > Many Target Prices (t8) are yielding N/A for S&P 500 stocks.
> >
>
Do you think Yahoo will fix this anytime soon? Many fields are returning "N/A" or "0".
thanks,
rr76012
--- In smf_addin@yahoogrou
>
> That's what Yahoo is sending on the CSV file...
>
> On Sat, Sep 8, 2012 at 9:50 AM, charles <chasjohn02@
>
> > Many Target Prices (t8) are yielding N/A for S&P 500 stocks.
> >
>
Thu Sep 13, 2012 8:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I haven't a clue...
On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@yahoo.com > wrote:
>
> Do you think Yahoo will fix this anytime soon? Many fields are returning
> "N/A" or "0".
>
On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@yahoo.
>
> Do you think Yahoo will fix this anytime soon? Many fields are returning
> "N/A" or "0".
>
Tidak ada komentar:
Posting Komentar