2 Messages

Digest #4022

Re: Replace RCHGetYahooHistory call by "Randy Harmelink" rharmelink

Re: Report Yahoo null data by richqw

Messages

1a

Re: Replace RCHGetYahooHistory call

Sun May 21, 2017 6:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

With your version of the function, you still need to supply the pRows and
pCols parameters.

On Sun, May 21, 2017 at 5:14 PM, Yahoo! lewglenn@
...wrote:

>
> I'm still getting the type mismatch error with:
>
> Range("A1:B20000") = smfGetYahooHistory("TLT", "1/1/1970", , "d", "dc", 0)
>
> Where could that be coming from?
> On Sunday, May 21, 2017, 4:41:33 PM PDT, Randy Harmelink
> rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The "pRows" and "pCols" parameters of smfGetYahooHistory() are the
> equivalent of the "pDim1" and "pDim2" parameters you were using with
> RCHGetYahooHistory(). In your version of smfGetYahooHistory(), you need to
> tell the function how many rows and columns of data to return, because they
> are otherwise set to the size of the range you are array-entering the
> formula over. And you aren't array-entering the formula over a range if you
> are calling it from VBA.
>
> Your new code will not contain the date field. I think you want "dc"
> instead of "c". Also, you will default to a year's worth of data without
> specifying the date parameters. Just shove a "1/1/1970"; in as your starting
> date, and you should get all available data. I just hope TLT isn't one of
> those with "null" values, which will cause it to error out when it hits one.
>
> I am changing smfGetYahooHistory() so that it will default to the
> "1/1/1970"; beginning date, as well as set the default # of rows and columns
> for a VBA call based on the starting date and ending date it ends up asking
> for from Yaho..
>
> In my version of the function, this returns dates and adjusted closing
> prices back to 7/30/02, without a header line:
>
> Range("A1:B20000") = smfGetYahooHistory("TLT", , , "d", "dc", 0)
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

2a

Re: Report Yahoo null data

Sun May 21, 2017 6:52 pm (PDT) . Posted by:

richqw

I also found SWZ has nulls for 6/29/16.This creates an error and the resort option is skipped. It would be helpful to have the function skip that date.