[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Re[2]: [amibroker] Auto-refresh displayed csv file



PureBytes Links

Trading Reference Links

Title: Re[2]: [amibroker] Auto-refresh displayed csv file
Hi Hermen,
 
I use the latest Office 12 suite w/SP1. The connection property window has a checkbox to do refresh in every x minutes. It does not lock the file. I could edit it w notepad+
I don't do it through ODBC! Directly from Excel.
 
the line of code you need to call if want to do it manually:
 
ActiveWorkbook.Connections("test").Refresh
 
(Replace test w/ your conn name)
 
Y

From: Herman
Sent: Tuesday, March 24, 2009 10:16 PM
To: Yofa
Subject: Re[2]: [amibroker] Auto-refresh displayed csv file

Thanks Y, i have been doing exactly that but am stuck with the last step.


1) how do i make excel refresh the data automatically, i.e. how do i use the 'refresh method' of excel?

2) how do i prevent Excel from locking the file so that afl can modify it? Right now whenever i load the file it locks it.


thanks,

herman



Tuesday, March 24, 2009, 11:51:37 AM, you wrote:


>

Hi Herman,

 

Write your data from AFL to a csv file. 

Create an Excel workbook. 

In on of the worksheets import data from the text file.

Create your charts etc. based on the data area of the import worksheet on a new worksheet.

Create a  button on the new that executes the data refresh method of Excel (VBA).

 

Regards,

 

Y


From: Herman 

Sent: Tuesday, March 24, 2009 9:21 AM

To: AmiBroker User Group 

Subject: [amibroker] Auto-refresh displayed csv file


I want to display system status/performance in real-time, preferably in Excel, and display a table and some some charts that refresh automatically.


It seems that whenever i load data in Excel it locks the file and i can no longer modify it. Also it doesn't refresh automatically to display real-time info.


Any suggestions will be much appreciated!


herman






__._,_.___


**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/





Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___