2 Messages

Digest #4369

smfPricesByDates Question by dan.smith33220@gmail.com

Re: smfPricesByDates Question by "Randy Harmelink" rharmelink

Messages

1a

I would like to use smfPricesByDates to reference a range of dates located in a column, so something like:

=smfPricesByDates(B$1, $A2:$A10)

and have the data returned in B3:B10.

It appears that date ranges must be in a single row and that data must also be returned in a row (as opposed to a column). Is that correct?

Also, please confirm that the priced data returned is adjusted closing prices.

The add-in is great. Thanks for all you do.

Dan

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

1b

Re: smfPricesByDates Question

Fri Jul 27, 2018 8:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There are two templates for the function, one returns data by row, the
other by column:

http://ogres-crypt.com/SMF/Templates/#smfPricesByDates()

All you would need to do is change your formula to transpose the returned
data:

=TRANSPOSE(smfPricesByDates(B$1, $A2:$A10))

The date parameters can be any combination of ranges, cells, and literal
values. For example, this would work:

=TRANSPOSE(smfPricesByDates(B$1, A2,A3,"7/27/18",DATE(2018,7,1),A6:A9,A10))

And, yes, the returned prices should be adjusted closing prices.

On Fri, Jul 27, 2018 at 8:01 PM, dan.smith33220@
....
wrote:

>
> I would like to use smfPricesByDates to reference a range of dates located
> in a column, so something like:
>
>
> =smfPricesByDates(B$1, $A2:$A10)
>
> and have the data returned in B3:B10.
>
>
> It appears that date ranges must be in a single row and that data must
> also be returned in a row (as opposed to a column). Is that correct?
>
>
> Also, please confirm that the priced data returned is adjusted closing
> prices.
>
>
>
>