Greetings,
I have read all posts but cannot figure out what I am doing wrong. Any
assistance would be greatly appreciated as my issue seems pretty simple. Sorry
for my naivety.
What I am trying to do:
Import weekly a cvs file using the Aux1 and Aux2 fields into my already
existing Amibroker database. I believe I have successfully imported this CVS
file as an ASCII file but cannot find where the data is located. It does not
show up in the data window.
Steps I have already taken:
1- Downloaded the CVS file to excel, for simplicity here is a small
example:
5/3/2010 hal 12000 200000
5/4/2010 hal 65555
5/5/2010 hal 57777
5/6/2010 hal 3345
5/7/2010 hal 43333 488888
2- Created a format definition file:
$FORMAT Date_DMY,Ticker,Aux1,Aux2
$SKIPLINES 0
$SEPARATOR ,
$DEBUG 1
$BREAKONERR 1
$AUTOADD 1
3- Created my file type; added the last line of the following code in the
import.types file:
Default ASCII (*.*)|*.*|default.format
Yahoo's CSV (*.csv)|*.csv|yahoo.format
AmiQuote Historical (*.aqh)|*.aqh|aqh.format
AmiQuote Historical (Funds) (*.aqh)|*.aqh|aqhfunds.format
AmiQuote Daily (*.aqd)|*.aqd|aqd.format
AmiQuote Historical (Google) (*.aqg)|*.aqg|aqg.format
AmiQuote Intraday (*.aqi)|*.aqi|aqi.format
AmiQuote Historical (MSN) (*.aqm)|*.aqm|aqm.format
AmiQuote Historical (eSignal) (*.aqe)|*.aqe|aqe.format
Metastock ASCII (*.txt)|*.txt|metastock.format
Omega SC ASCII (*.txt)|*.txt|omega.format
S-Files (s*.*)|s*.*|sfile.format
C-Files (c*.*)|c*.*|cfile.format
Sharenet DN (*.dn)|*.dn|sharenet.format
PRN Format with Ticker (*.prn)|*.prn|prnn.format
PRN Format without Ticker (*.prn)|*.prn|prnn2.format
Space separated Ticker,Date,OHLC (*.txt)|*.txt|ssv.format
Space separated Date,HLCV (*.txt)|*.txt|ssv2.format
Short Daily CSV (*.csv)|*.csv|daily.format
MST Format w/Ticker (*.mst)|*.mst|mst.format
StockWatch.com format (*.csv)|*.csv|stockwatch.format
TenBagger format (*.stk)|*.stk|stk.format
insider format (*.txt)|*.txt|insider.format
4- Imported while in a current database of Amibroker
file>import ASCII,
selected the data file, made sure it was the insider format, clicked okay,
received no errors but also don't have any data in the Aux1 or Aux2 fields?
I want to permanently keep this data and eventually backtest using it. Any
help or a new way to accomplished this would be fantastic.
Thanks,
Mike
--- In amibroker@yahoogroups.com, Tomasz Janeczko <gro...@...> wrote:
>
> Hello,
>
> See my previous response - you can't write composite to the very same
> symbol.
>
> With regards to temporary variables - you should definitely use STATIC
> variables instead for that purpose.
> They are much faster than composites.
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
>
> On 2010-04-23 11:50, Vladislav Titov wrote:
> >
> >
> > Yes, I can import it from ASCII without any problem.
> >
> >
> > I know that I can temporary assign OHLCVI and AUX1/2 in AFL as you
> > wrote. But result of the operation isn't stored in amibroker's database.
> >
> >
> > I want to realize following scenario:
> >
> > 1. Run "Scan" to calculate some value for every bar.
> >
> > 2. Store this calculated value into amibroker's database.
> >
> > 3. Use this value for plotting charts and other facilities without
> > re-calculation.
> >
> >
> > From Tomasz's statement I have understood that it is possible via
> > AddToComposite functions. But it doesn't work. See example of AFL code
> > in one of my previous mail in this thread...
> >
> >
> > >
> >
> >
> >
> >
> > Hello,
> >
> >
> > I know that these fileds should store data imported through ascii
> > files, butis it possible to store values to these fields during a the
> > first phase of the backtest backtest and access them in the second phase.
> >
> >
> > for example:
> >
> >
> > Aux1=ATR(14);
> >
> >
> > thanks
> >
> >
> >
> >
> >
> >
> >
>
