2 New Messages
Digest #2344
| |
Messages
Wed Sep 12, 2012 6:10 pm (PDT) . Posted by:
"Christopher LaPointe" tennisking03
Thu Sep 13, 2012 1:06 am (PDT) . Posted by:
"ds5ec" ds5ec
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 smf_addin@yahoogroups.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.
> >
>
--- In smf_addin@yahoogrou
>
> 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.
> >
>
Tidak ada komentar:
Posting Komentar