Bridging Excel to Amibroker

[Ravi.V]

Hi Friends...
Greetings!!
I would like to know if it's possible to bridge Amibroker with Excel. If yes, could anyone please share relevant references or resources with me?
Thank you, well in advance.!

[nsm51]

explain in detail what you want to achieve.

[Ravi.V]

Hi @nsm51 ,

Thank you for your prompt response - I truly appreciate it.

Let me take a moment to explain my requirement in detail.

The above Excel file contains key data points that assist me in making trading decisions for the current day.

I would like to integrate this data into my Amibroker chart. The Excel file may provide one of the following data types on any given day: Number, Date, or Time.

Here's how I intend to use each type in Amibroker:

1. Number/Level: If the input is a numeric level, I want that level plotted directly on the intraday chart.
2. Date: If the value is a date, I’ll wait until the market closes (EOD at 15:30 IST). After that, I want to plot the day's High and Low levels on the chart.
3. Time: If the input is a specific time, I’d like to mark it on the chart using the GfxTextOut() function, just as a visual reference.

Additionally, I am also sharing with you my Amibroker chart so you can better understand how and where I’d like this data to appear.

I hope now I’ve explained my requirement clearly.

However, if you need any clarification or further details, please don’t hesitate to ask... I’d be happy to provide more information.

Thank you once again for your support!

[Ravi.V]

Hi Everyone!

Could someone please assist me with this?

Thank you!

[mmha]

Did you check this example from the library, might be helpful ?

AFL_Excel Formula

[beppe]

@Ravi.V both Excel and Amibroker use OLE so you can create interactions between them.

I suggest to look at these past threads to get started:

How to Read data from Excel in AFL

I have use cases where data are updated every 15mins into to excel sheet, from which I need to read it in AFL code and display it in Amibroker chart as text. But i could able to figure it out how to read excel in afl . kindly help me out. Thanks in advance.

How to query MACD parameters from Excel

Dear All, I have an excel file that contains list of MACD parameters for each of ticker name. Kindly need your help how to display this macd chart that automatically changes the parameters based on my excel. Thank you. Surya

How to run VBA macro from Amibroker Batch

Hey everyone, I am looking to find a way (preferably through Amibroker batch) to execute an excel macro, But I have not been able to find much on the subject. So far, I have been able to execute the excel file itself via batch ‘execute and wait’: cmd.exe /c start excel "C:\Program Files\AmiBroker\Formulas\Excel\example.xlsm" Any help to take the next step to run the VBA macro would be greatly appreciated!

How to output valume to Excel in afl

Hello !! How do i output data to another program like Excel in afl Any help would be greatly appreciated. Thank you!!!

I suggest to study both the OLE documentation of Amibroker and also the one of Excel

[nsm51]

@beppe I looked at the OPs 2nd post on that day, but I was not sure. The main direction is to send "data" from Excel to AB accessible via AFL.
OLE exports from AB are generally for its automation.

So I was looking at it with some workaround approach, like use OLE to import some custom ticker, and then read it from AFL

OR, excel writes to a file, AFL reads it.
The issue with this approach is AFL is super fast, but reading/checking if a file is modified every AFL run is an overkill. maybe some more code to do it periodically.

I'd still try using a custom ticker with some sort of flag or bit-flag in OI/Aux 1,2 saying what should be done using ohlc fields for the pivots.

With OPs static data, I'd just use the UI for such less data once a day unless its for many symbols.
Also, a question for OP, would the data not be able to generate in AFL instead of bringing Excel into the picture?

[beppe]

@nsm51, if the OP needs to work with multiple symbols and prepares his "daily" levels in Excel in advance, it would probably be simplest to arrange the external data in multiple columns on a single sheet. I’d recommend using a specific reserved cell to perform a VLOOKUP based on the AmiBroker ticker, which would locate the corresponding row and retrieve all relevant information from the desired cells (maybe adding some extra code to handle the case where the selected symbol is not present in Excel).

In this case, within AmiBroker, he would only need to detect a symbol change (e.g., using static variables) to trigger the Excel lookup.

[nsm51]

oh i see what you mean. It would be easier to export function from Excel and call from AB