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 [email protected], "engrfa...@..." <engrfa...@...> 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. >
