|
PureBytes Links
Trading Reference Links
|
I was gonna mention this function this morning but figured must
already know about it ...
I think you'll find that even by doing this you'll still want to copy
the file from where AB creates it to where XL wants it ... The reason
is that if Excel is trying to import the file at the same time that
AB is creating it you'll have problems.
Not in conjunction w/AB, but I've done this sort of thing and it
works fine.
--- In amibroker@xxxxxxxxxxxxxxx, "Herman van den Bergen"
<psytek@xxxx> wrote:
> Just realized that in Excel we can import a csv file ->
GetExternalData ->
> ImportTextFile -> (pick file) -> ExternalDtatRangeProperties ->
Refresh -> 1
> Minute.
>
> so that it will automatically Refresh. Still have to test this but
I suspect
> that a Refresh will not lock the file for updating by another
program, so
> essentially we can maintain logs in AB and have it automatically
refreshed
> in Excel.
>
> not bad...:-) i think i am in business.
>
> herman.
> -----Original Message-----
> From: Herman van den Bergen [mailto:psytek@x...]
> Sent: Tuesday, March 23, 2004 4:19 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: RE: [amibroker] Auto-updating Excel from AmiBroker
> Importance: High
>
>
> Clever :-)
>
> never thought of that.
>
> h
> -----Original Message-----
> From: dingo [mailto:dingo@x...]
> Sent: Tuesday, March 23, 2004 2:24 PM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: RE: [amibroker] Auto-updating Excel from AmiBroker
> Importance: High
>
>
> Here's a simple trick: write a small macro in XL to copy
(using another
> name/location of course) the file emitted from AB. Then use that
file. That
> way AB can go on its way without worrying about XL glomming onto
the file.
>
> d
>
>
>
> --------------------------------------------------------------------
------
> From: Herman van den Bergen [mailto:psytek@x...]
> Sent: Tuesday, March 23, 2004 8:11 AM
> To: AmiBroker YahooGroups
> Subject: [amibroker] Auto-updating Excel from AmiBroker
>
>
> Has anybody been able to update an Excel worksheet
automatically from
> AmiBroker?
>
> I would like to keep trading records in Excel and would like
the
> Worksheet to automatically refresh from a text file generated by
AmiBroker
> whenever the text file changes. This was discussed some time ago
but at the
> time there was no solution.
>
> The above mechanism makes it much easier to maintain records
when
> trading portfolios as well as would allow us to automate report
analysis in
> the AA.
>
> TIA for an solutions you may have. Perhaps a major problem
would be
> that Excel locks files when in use?
>
> best regards,
> herman.
>
>
> 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
>
>
>
>
> 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
>
>
>
>
>
> 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
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/amibroker/
>
> b.. To unsubscribe from this group, send an email to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
------------------------ 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/
|