Connecting Excel Real-Time Stock Data to Amibroker: Is it Possible?

[PaterMike]

Hello, I have an Excel file containing real-time stock quotes. Is it possible to connect this Excel file to Amibroker and import the data into Amibroker?

Michael

[Huynq99]

fxshrat posted.

How to Read data from Excel in AFL

Set path to Excel file in code below Set Excel cell to read from Open your Excel file Run Explorer (or click ParamTrigger of chart pane). EnableScript ( "vbscript" ); <% Function GetXLSfile( file ) Err.Clear On Error resume next Set Obj = GetObject( file ).Application If Err.Number <> 0 then GetXLSfile = 0 Else Set GetXLSfile = Obj End If End Function %> /// 1. Set path to Excel file below /// 2. Set Excel cell to read from /// 3. Open your Excel file /// 4. Run Explorer (or click P…

[PaterMike]

Thanks for the feedback! Let me explain in a bit more detail what I am trying to do. My goal is to import data from an Excel spreadsheet into Amibroker, analogous to a real-time data stream. Is there a way to insert the data from my Excel spreadsheet into Amibroker via such a data stream? I hope this clarifies my intention a bit more. Thank you very much for your help!

[empottasch]

i never done it myself but I think you can use the DDE plugin for that, see

AmiBroker - DDE real time feed

Real time data feeds for Amibroker using Link to Excel Feature for FREE

[PaterMike]

"Thank you very much for the helpful hint! It seems like this could be the solution. I'll give it a try in the coming days and truly appreciate your assistance."