|
PureBytes Links
Trading Reference Links
|
Well ... here is a PERL script which will split Excel file saved as .CSV file into
individual .CSV files one per ticker. One needs to have ActiveState (freeware) PERL
to run the script I've written. No no ... this isn't JScript or VB Script that will
do the job end to end ... I am not (yet) familier enough with either to code in
that. But eventually I'll get there. *smile*
I'm attaching screen-shot which shows how the program ran, what the input was and
what output was produced. I'm also attaching 'abc.csv' and of course 'CSVsplit.pl'
alongwith.
Regards,
- Salil V Gangal
--- Salil V Gangal <salil_gangal@xxxxxxxxx> wrote:
> mickeyamelinckx,
>
> Right ! Post by "d" does sound like 'Flame'.
>
> I was inquiring if someone has code to share for automating making
> CSVs out of Excel, so that they can be imported into AmiBroker. It
> was amusing to suddenly see D's comment (I'd be more inclined to help
> you if you were to return some of the kindnesses shown you).
>
> Anyways ... most likely I'll get at how to automate making of CSVs,
> with out without any inclination from "d".
>
> Regards,
> - Salil V Gangal
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "mickeyamelinckx" <mickeyA@xxxx>
> wrote:
> > "Friend",
> > gee it really amazes me that some people´s mentality can be shown
> so
> > clear even on boards. And it comes clear in what state of mind SOME
> > people are thinking on the net. I thought especially this group
> with
> > great people like Herman and many others had a far higher level of
> > education and age then this post. Sorry but this blows me away and
> > had to say something about it and hope I´m not starting a comotion
> on
> > this one, so I will not react to any possible comments on this.
> >
> > Sorry this is not personal because you are probably not to blame
> > personally !
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "dingo" <dingo@xxxx> wrote:
> > > "Friend",
> > >
> > > I suggest you buy "Excel For Dummies". It has a lot of good
> > examples of what
> > > you're trying to do vis-a-vis the spreasheet.
> > >
> > > Why not post some of the stuff you've written for commentary
> > automation? I
> > > for one would like to see it. I'd be more inclined to help you if
> > you were
> > > to return some of the kindnesses shown you.
> > >
> > > d
> > >
> > >
> > > _____
> > >
> > > From: Salil V Gangal [mailto:salil_gangal@x...]
> > > Sent: Sunday, March 14, 2004 11:31 AM
> > > To: amibroker@xxxxxxxxxxxxxxx
> > > Subject: [amibroker] Excel Spread-sheet to AmiBroker ... Code ?
> > >
> > >
> > > Friends,
> > >
> > > Hmmm ... anyone has any code to post for this sort of
> automation ?
> > >
> > > Say I have Dates running across (Column B, C, D, E , F ... ) and
> I
> > > have Tickers running down (Row 1, 2, 3, 4, 5 ...) At the cross of
> > Col-
> > > n-Row I have 'price' value for the ticker. Any code to automate
> > the
> > > extracting of data from such a spread-sheet and making .CSVs out
> of
> > > them ?
> > >
> > > A 'data plug-in' that allows one to define the rage from Excel SS
> > to
> > > be used as data range for importing 'live' into AmiBroker will be
> > > nice to have ...
> > >
> > > Regards,
> > > - Salil V Gangal
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx, "Salil V Gangal"
> > > <salil_gangal@xxxx> wrote:
> > > > Graham,
> > > >
> > > > Nice to know. So as I wrote below >>>and is willing to post the
> > > code ?
> > > > <<< ... So will pls post the code ?
> > > >
> > > > Regards,
> > > > - Salil V Gangal
> > > >
> > > >
> > > > --- In amibroker@xxxxxxxxxxxxxxx, "Graham" <gkavanagh@xxxx>
> wrote:
> > > > > Yes I did a few weeks ago, or so. You can use the fget etc
> > > functions
> > > > >
> > > > > Cheers,
> > > > > Graham
> > > > > http://e-wire.net.au/~eb_kavan/
> > > > >
> > > > > -----Original Message-----
> > > > > From: Salil V Gangal [mailto:salil_gangal@x...]
> > > > > Sent: Sunday, March 14, 2004 10:34 AM
> > > > > To: amibroker@xxxxxxxxxxxxxxx
> > > > > Subject: [amibroker] Excel Spread-sheet to AmiBroker
> Automation
> > > > >
> > > > > Friends,
> > > > >
> > > > > Has anyone done any automation where the data from Excel
> Spread-
> > > > sheet
> > > > > is imported into AmiBroker and is willing to post the code ?
> > > > >
> > > > > The approach is to save Excel data in CSV format and then
> > import
> > > > into
> > > > > AmiBroker ... I'm looking for some examples of Automation
> which
> > > > > extract data from different columns and make CSV files.
> > > > >
> > > > > ... The best approach will be to have some sort of a live-
> link
> > > > > between Excel-source and AmiBroker-target, similar to what
> one
> > > can
> > > > do
> > > > > using Excel and Word. The idea is that chart/data in
> AmiBroker
> > > > will
> > > > > keep changing as and when data in Excel changes. (But I'll be
> > > glad
> > > > to
> > > > > settle for just the Automation.)
> > > > >
> > > > > Regards,
> > > > > - Salil V Gangal
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Send BUG REPORTS to bugs@xxxx
> > > > > Send SUGGESTIONS to suggest@xxxx
> > > > > -----------------------------------------
> > > > > Post AmiQuote-related messages ONLY to:
> > amiquote@xxxxxxxxxxxxxxx
> > > > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > > > --------------------------------------------
> > > > > Check group FAQ at:
> > > > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > > Yahoo! Groups Links
> > >
> > >
> > >
> > > Send BUG REPORTS to bugs@xxxx
> > > Send SUGGESTIONS to suggest@xxxx
> > > -----------------------------------------
> > > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > > --------------------------------------------
> > > Check group FAQ at:
> > > http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > >
> > >
> > >
> > > Yahoo! Groups Sponsor
> > >
> > > ADVERTISEMENT
> > >
> > >
> > >
> > >
> >
> <http://rd.yahoo.com/SIG=12cgrul3p/M=276465.4309739.5546025.1261774/D=
> > egroup
> > >
> >
> web/S=1705632198:HM/EXP=1079368240/A=1854145/R=2/id=noscript/SIG=11r3i
> > km62/*
> > > http://autos.yahoo.com?refsrc=onnetwork/ads/Q4/lrec/stock>
> > >
> > > <http://us.adserver.yahoo.com/l?
> > M=276465.4309739.5546025.1261774/D=egroupweb
> > > /S=:HM/A=1854145/rand=652834037>
> > >
> > >
> > > _____
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > > * To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/amibroker/
> > >
> > >
> > > * To unsubscribe from this group, send an email to:
> > > amibroker-unsubscribe@xxxxxxxxxxxxxxx
> > > <mailto:amibroker-unsubscribe@xxxxxxxxxxxxxxx?
> subject=Unsubscribe>
> > >
> > >
> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service
> > > <http://docs.yahoo.com/info/terms/> .
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> 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/
Attachment:
csvsplit.pl
Description: csvsplit.pl
Attachment:
Description: "Description: abc.csv"
Attachment:
Description: "abc.csv"
Attachment:
Description: "Attachment:"
|