|
PureBytes Links
Trading Reference Links
|
Hi,
No problems. I hope that the info is of use. After I posted I had a
closer look today at Volume and it was showing up ok live in the
Realtime Quotes, but it wasn't showing in the Quotations Editor using
a 1 min base time interval??
I use the Professional AB as an adjunct to Tradestation to chart
custom calculations in Excel for futures trading and use the "R1C1"
style of refence from my Master Excel sheet. I've never had the need
to record volume as such. I must have a closer look in the near
future. If anyone has got Volume to record into the Intraday database
from Excel I'd be interested to hear. A workaround would be to record
it seperately and apply it as an indicator using the "Foreign"
function. Very easy to do in 4.7.
Cheers, Allan
--- In amibroker@xxxxxxxxxxxxxxx, "iascool" <sai20_2000@xxxx> wrote:
> 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 --------------------~-->
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/
|