Seems what you have is a combination of tick data and fundamental data.. The tick data is somewhat easy.
Tick example:
Name, Fullname, Open, High, Low, Close...etc.
Fundamental example ( see User Guide > fundamental ):
DIV_PAY_DATE
EX_DIV_DATE
LAST_SPLIT_DATE
LAST_SPLIT_RATIO
EPS
EPS_EST_CUR_ YEAR
EPS_EST_NEXT_ YEAR
EPS_EST_NEXT_ QTR
FORWARD_EPS
PEG_RATIO
BOOK_VALUE (requires SHARES_OUT to be specified as well)
BOOK_VALUE_PER_ SHARE
EBITDA
PRICE_TO_SALES (requires CLOSE to be specified as well)
PRICE_TO_EARNINGS (requires CLOSE to be specified as well)
PRICE_TO_BV (requires CLOSE to be specified as well)
FORWARD_PE (requires CLOSE to be specified as well)
REVENUE
SHARES_SHORT
DIVIDEND
ONE_YEAR_TARGET
MARKET_CAP (requires CLOSE to be specified as well - it is used to calculate shares outstanding)
SHARES_FLOAT
SHARES_OUT
PROFIT_MARGIN
OPERATING_MARGIN
RETURN_ON_ASSETS
RETURN_ON_EQUITY
QTRLY_REVENUE_ GROWTH
GROSS_PROFIT
QTRLY_EARNINGS_ GROWTH
INSIDER_HOLD_ PERCENT
INSTIT_HOLD_ PERCENT
SHARES_SHORT_ PREV
FORWARD_DIV
OPERATING_CASH_ FLOW
FREE_CASH_FLOW
BETA
--- In
amibroker@xxxxxxxxx ps.com, "engrfaruk@x .." <engrfaruk@x ..> wrote:
>
> Hi/Assalamualiekum every1,
>
> I am in problem to import ASCII files of Amiquote Histirical esignal aqe formated file. First 2lines of the file shown below:
> 1. Trading Code,Company, Last Trade,Open Price,52 Weeks Range,Face Value,Market Lot,Last AGM,Bonus Issues,Right Issue,Market Category,Market Cap,Authorized Cap,Outstanding Cap,Business Segment,Nos Securities,Year End,Reserve Surplus,HY End,HY Net
Turnover,HY Net Profit,HY EPS,DSE PE,EPS 2007,NAV 2007,Profit 2007,Dividend 2007,Dividend Yield 2007,EPS 2008,NAV 2008,Profit 2008,Dividend 2008,Dividend Yield 2008,Electronic Share,Share % Director,Share % Govt.,Share % Institute,Share % Foreign,Share % Public
> 2. ABBANK,AB Bank Limited,699.. 75,690.0, 390.0 - 4420.0,100.0, 5,16/07/2008, "200% 2007, 30% 2006, 10% 2005, 5% 2003 & 2004, 15% 2002, 1B:","n/a",A, 15218.285, 3000.0,2230. 0,Bank,22297854, 200712,2281. 8,200806, 3141.3,1302. 72,58.42, 8.2,85.37, n/a,1903. 49,"200%B" ,-,n/a,n/ a,n/a,"n/ a",n/a,Y, 50,0.57,0, 0,49.43
>
> First1 are header and other1 is data.
>
> Pls any1 help me to write aqe.format file that fullfill all hearer without skip.[$FORMAT ..,..,..,]
>
> Thanks in advance.
>