|
PureBytes Links
Trading Reference Links
|
You can open large files with Notepad and Wordpad. I have done that
to break them into smaller files that will fit on an Excel sheet.
That is a pain to do.
Another thing you can do is modify my AFL formula to dump data out in
any size block you need then import them into individual Excel
sheets. I put an export program in the AFL library that will export
EOD and intraday data to a csv file. You could add a counter in the
for loop to break that into smaller files, 63K lines or so, close and
then open a new file with an extension, a, b, c... and so on.
Barry
--- In amibroker@xxxxxxxxxxxxxxx, "J. Biran" <jbiran@xxx> wrote:
>
> UltraEdit will open CSV file with no limits. But, it is not
> free either.
>
>
>
> Joseph Biran
> ____________________________________________
>
> From: amibroker@xxxxxxxxxxxxxxx
> [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of Ken Close
> Sent: Friday, August 01, 2008 7:44 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Reading and Writing Large CSVs
>
>
>
> I did an explore which wound up having 432,830 rows (8900+
> symbols, monthly, from 2004 to present. It took it 5 min 0
> sec to save to disk.
>
>
>
> Can someone confirm the following for me:
>
>
>
> I assume that the resulting csv file will have 432,830 rows
> in it--is that correct?
>
> I discovered that I can only "see" 65536 rows because that
> is all that my Excel 2002 will open.
>
> Does anyone know if there is a reader anywhere that will
> open or allow viewing of all 432,830 rows. I am aware that
> Excel 2007 can open over 1 million rows but I am looking for
> a way to avoid the cost of upgrading.
>
> A related question is whether since I own Excel 2002,
> whether I am eligible for an upgrade price on 2008 vs
> purchase entire new program; the details on some of the web
> pages are ambiguous.
>
>
>
> Any comments?
>
>
>
> Thanks,
>
> Ken
>
------------------------------------
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|