2 Messages
Digest #4609
Messages
Mon Sep 2, 2019 2:03 pm (PDT) . Posted by:
nautilustech
When using the smfPricesByDates() template:, I can't seem to array-enter the sheet. Array entering each line works fine. Here's the formula I'be been using: =smfPricesByDates(B4:B10,c$3:k$3)
Where column B are the stock symbols & Row 3 are dates. When I try this, the sheet is populated with #VALUE.
Many thanks for putting up with an old man's ignorance.
Where column B are the stock symbols & Row 3 are dates. When I try this, the sheet is populated with #VALUE.
Many thanks for putting up with an old man's ignorance.
Mon Sep 2, 2019 5:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It only accepts multiple dates, not multiple tickers. So you can only do a
row at a time, for one ticker symbol.
On Mon, Sep 2, 2019 at 2:03 PM nautilustech@... wrote:
>
> When using the smfPricesByDates() template:, I can't seem to array-enter
> the sheet. Array entering each line works fine. Here's the formula I'be
> been using: =smfPricesByDates(B4:B10,c$3:k$3)
>
> Where column B are the stock symbols & Row 3 are dates. When I try this,
> the sheet is populated with #VALUE.
>
> Many thanks for putting up with an old man's ignorance.
>
>
>
row at a time, for one ticker symbol.
On Mon, Sep 2, 2019 at 2:03 PM nautilustech@
>
> When using the smfPricesByDates(
> the sheet. Array entering each line works fine. Here's the formula I'be
> been using: =smfPricesByDates(
>
> Where column B are the stock symbols & Row 3 are dates. When I try this,
> the sheet is populated with #VALUE.
>
> Many thanks for putting up with an old man's ignorance.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar