|
PureBytes Links
Trading Reference Links
|
Allen, thanks for giving this valuable addition to my earlier post. I
actually overlooked the "vol" vs "volume" issue, thanks for pointing this
out.
Nevertheless I keep having problems with the correct volume numbers.
On a "1 min" datacollection basis the volume data as displayed in the
"Realtime Quote" window are always shown correctly, but the volume or "last
size" saved in the AB Database are frequently a factor 2 higher.
Are you experiencing the same?
AB helpdesk seems unable to help on this issue...
Note: A very usefull tool to collect (Yahoo) data into Excel (and AB) is a
freeware utility "QuoteCat" (www.quotecat.com)
Highly recommendable
Fred
----- Original Message -----
From: "allan_brewster" <foxtrot4@xxxxxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, May 16, 2005 4:20 PM
Subject: [amibroker] Excel to AB via DDE. Required settings
> 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
>
>
>
>
>
>
>
>
>
> 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
>
>
>
>
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.10 - Release Date: 05-05-13
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/
|