|
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/
|