2 New Messages
Digest #2615
Messages
Sun May 12, 2013 9:25 pm (PDT) . Posted by:
"hjreed@swbell.net" hjreed@swbell.net
Randy
Is there a way to only bring in the last 100 entries/lines from a .cvs file using smfGetCSVFile? I want to build Elder's New High/New Low and want to use the last 100 days from http://unicorn.us.com/advdec/NYSE_newhi.csv. This data starts back in 2005 and I would like to reduce the amount of data I have to handle.
Thanks in advance for looking at my question.
Is there a way to only bring in the last 100 entries/lines from a .cvs file using smfGetCSVFile? I want to build Elder's New High/New Low and want to use the last 100 days from http://unicorn.
Thanks in advance for looking at my question.
Sun May 12, 2013 9:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There's nothing there that would allow such a restriction of the output...
You could retrieve the entire array in one workbook, and then use the
OFFSET() function to pull the last 100 rows of data from it.
On Sun, May 12, 2013 at 9:25 PM, hjreed@swbell.net <hjreed@swbell.net >wrote:
>
> Is there a way to only bring in the last 100 entries/lines from a .cvs
> file using smfGetCSVFile? I want to build Elder's New High/New Low and
> want to use the last 100 days from
> http://unicorn.us.com/advdec/NYSE_newhi.csv. This data starts back in
> 2005 and I would like to reduce the amount of data I have to handle.
>
You could retrieve the entire array in one workbook, and then use the
OFFSET() function to pull the last 100 rows of data from it.
On Sun, May 12, 2013 at 9:25 PM, hjreed@swbell.
>
> Is there a way to only bring in the last 100 entries/lines from a .cvs
> file using smfGetCSVFile? I want to build Elder's New High/New Low and
> want to use the last 100 days from
> http://unicorn.
> 2005 and I would like to reduce the amount of data I have to handle.
>
Tidak ada komentar:
Posting Komentar