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

[amibroker] Excel to AB via DDE. Required settings



PureBytes Links

Trading Reference Links

There are 2 ways to collect data into AB from Excel. You either
define a single cell eg. "R2C2" for cell B2 to collect data from, or 
use the method mentioned in a previous post a few days ago where you 
use a text symbol and define the name of each cell in Excel.

Firstly , to use the "text" symbol method for an Excel Workbook named 
"Master.xls" using a sheet name of "Data"...

In "Database Settings" > "Configure" each field to be collected from 
"Data" would have the entry "[MASTER.xls]Data{ticker}_"field"

So.."DDE server" enter "EXCEL"
"Open" enter "[MASTER.xls]Data{ticker}_Open"
"Last" enter "[MASTER.xls]Data{ticker}_Last"
"Volume" enter "[MASTER.xls]Data{ticker}_Volume" etc. for the various 
data cells you have in the "Data" sheet. Follow AB's naming protocol 
exactly. No using "Vol" for "Volume".

Due to a limitation in the "Naming" of cells in Excel the fields
"Last Size, Ask Size and Bid Size" will not work as Excel will not 
accept a name with a space. 

The secret to get this to actually work is to enter in the "Req*" 
field..."[MASTER.xls]Data{ticker}". If you don't have this it won't 
link. This field entry will establish the link in any vacant cell 
apart from "Time" and you can actually combine the Single cell 
reference such as "R2C2" with text Symbol entries. 

Eg. the "R2C2" symbol will come up as a bid if "[MASTER.xls]
Data{ticker}" is entered for the Bid Field definition, regardless of 
the other "_field" definitions entered as above at the same time for 
"Configure DDE plugin". That is, the two protocols can be combined.

If you are only using AB to act as a database for any sort of live 
data in Excel...this could apply to scientific data mapping for 
instance, as well as trading data or custom calculations in Excel...
then a cell entry only requires the field to have the entry "[MASTER.
xls]Data{ticker}." 

This can be placed in "Last", "Open", "Low" or whatever apart from
the "Time or "Req*" fields.

As mentioned in the previous post, if you are using the "text" symbol 
method each cell in Excel must have it's "Name" defined. The actual 
position of the cell in the sheet in not significant as such, but in 
the interest of good housekeeping an orderly arrangement of columns
is preferable, obviously.

So, repeating the earlier post to name the cell...
Click on the cell>Insert>Name>Define>Add

The cell for "High" for symbol "ABC" would be defined as "ABC_High", 
for "Last" "ABC_Last". When the cell is clicked on this name will
come up in the name box in Excel, rather than the cell no. if you have
done it properly. Spaces in the name are not accepted.

I hope this info is useful. More than a few hours of trial and error 
have got me this far with DDE. AB can actually be a very powerful DDE 
database. 

Cheers, Allan Brewster, Australia



 	




------------------------ Yahoo! Groups Sponsor --------------------~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~-> 

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.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/