|
PureBytes Links
Trading Reference Links
|
hi Allan
Thanks for sharing such a valuable data
I hope you wont mind if any querry arises
Regards
--- In amibroker@xxxxxxxxxxxxxxx, "allan_brewster" <foxtrot4@xxxx>
wrote:
> 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/
|