|
PureBytes Links
Trading Reference Links
|
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
------------------------ 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/
|