|
PureBytes Links
Trading Reference Links
|
On your import of data you did not mention a ticker column. I
assume the ticker is a composite. AB has to know what file to update
on import.
First, you can not have negative volume or issues data. I have a
file that I use for advances and declines and I use Excel to change
the high and low depending on whether the open is higher than the
close or not.
These are my excel fields
A, B, C, D, E, F, G and H
ticker, date, open, high, low, close, volume and oi
~NASD, 1/3/07, 1200, =IF(C2>F2,C2,F2), =IF(C2<F2,C2,F2), 1100, up
vol, down vol
~NASD, 1/3/08, 1300, =IF(C2>F2,C2,F2), =IF(C2<F2,C2,F2), 1500, up
vol, down vol
the logic in columns D and E will cause the columns to have this
following data in them
~NASD, 1/3/07, 1200, 1200, 1100, 1100, up vol, down vol
~NASD, 1/3/08, 1300, 1500, 1300, 1500, up vol, down vol
AB will import that into your composite file and when you plot that
data is will have bars just as it should. The data will not have
negative numbers in it.
Barry
--- In amibroker@xxxxxxxxxxxxxxx, "sebastiandanconia"
<sebastiandanconia@xxx> wrote:
>
>
> I'm importing NYSE breadth numbers into AB using a csv file with 7
> columns in the format "Date Open High Low Close Volume Open
Interest."
>
> The order of the data is "Date Advances Declines Highs Lows
Upvolume
> Dnvolume."
>
> The problem I'm having is that the Open and the High are the same
number
> (the Advances) and I'm not getting the Declines. I'm checking
the "no
> quotation data" box.
>
> Any ideas where I've gone wrong?
>
>
>
> Luck to all and TIA for any responses,
>
>
>
> Sebastian
>
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.10/624 - Release Date: 1/12/2007 2:04 PM
|