|
PureBytes Links
Trading Reference Links
|
Hi,
Sorry for the second post, but I missed seeing your post querying
Volume. At least your getting something to record. I was showing
nothing at all. Another problem I noticed is that the Quotations
Editor seems to refuse to delete intraday data. Useless if you have
bad ticks.
I'll set up a reference page in the near future with Open, High, Low,
Close and Volume for intraday and see if there's some trick to it that
I can blunder upon. I'm not feeling hopeful. As I said in the other
post for futures the workaround is to record the volume seperately and
apply it as an indicator. Useless for stocks, of course.
Cheers, Allan
--- In amibroker@xxxxxxxxxxxxxxx, "fred" <f.denys@xxxx> wrote:
> 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@xxxx>
> 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 --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/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/
|