2 Messages
Digest #4142
Messages
Sun Sep 10, 2017 1:16 pm (PDT) . Posted by:
"Philip Manning" pmanning54
When gathering Yahoo historical stock prices, they appear in rows with the appropriate number of rows. Using TRANSPOSE, I am able to make them appear in the appropriate number of columns. Now, however, I would like to order the array in chronological order with the oldest date in column B (rather than the newest) and the newest date in the last column (be it H or Z or whatever). How can I do this?
Sun Sep 10, 2017 3:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to use the "pSort" parameter of the function. For example,
array-entering this over a 10-column by 2-row range:
=TRANSPOSE(smfGetYahooHistory("MMM",,,,"dc",0,1,10,2))
2017-08-25 2017-08-28 2017-08-29 2017-08-30 2017-08-31 2017-09-01 2017-09-05
2017-09-06 2017-09-07 2017-09-08
$202.13 $202.46 $202.92 $203.69 $204.32 $203.56 $200.98 $202.05 $204.46
$205.69
You also need to use the "pRows" and "pCols" parameters, because otherwise
the function defaults them to the size of your array-entered range.
On Sun, Sep 10, 2017 at 1:11 PM, Philip Manning pmanning54
...
wrote:
>
> When gathering Yahoo historical stock prices, they appear in rows with the
> appropriate number of rows. Using TRANSPOSE, I am able to make them appear
> in the appropriate number of columns. Now, however, I would like to order
> the array in chronological order with the oldest date in column B (rather
> than the newest) and the newest date in the last column (be it H or Z or
> whatever). How can I do this?
>
array-entering this over a 10-column by 2-row range:
=TRANSPOSE(smfGetYa
2017-08-25 2017-08-28 2017-08-29 2017-08-30 2017-08-31 2017-09-01 2017-09-05
2017-09-06 2017-09-07 2017-09-08
$202.13 $202.46 $202.92 $203.69 $204.32 $203.56 $200.98 $202.05 $204.46
$205.69
You also need to use the "pRows" and "pCols" parameters, because otherwise
the function defaults them to the size of your array-entered range.
On Sun, Sep 10, 2017 at 1:11 PM, Philip Manning pmanning54
...
wrote:
>
> When gathering Yahoo historical stock prices, they appear in rows with the
> appropriate number of rows. Using TRANSPOSE, I am able to make them appear
> in the appropriate number of columns. Now, however, I would like to order
> the array in chronological order with the oldest date in column B (rather
> than the newest) and the newest date in the last column (be it H or Z or
> whatever). How can I do this?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar