[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] datenum() function



PureBytes Links

Trading Reference Links

Hi
Tomasz and Jason thanks for your replies.

Unfortunately I did not present the question sufficiently deep.

I have looked into AMi group  files section and there are files 
convinient for NEW SP500 database creation. That led me half way to 
the next.

My CURRENT database is already full of realtime eSignal EOD quotes on 
200 and some more symbols ( some belonging to US SP500 some not,some 
are indices) and neither of them are in right sector-industry . 
Bottom line, I have half tickers loaded   and half are needed to be 
added. Everything with right industry  code.
 
Thus Workspace deletion ( for new recreation of "my correct" pre 
formated  broker.industry and broker.sector files  )is no no because 
trendlines and notes are there. 
Its similar with  ASCII database import, because real time database 
is controled by eSignal and old data could be biased via import 
fields. Ami docs suggested  caution in that case. Correct  me if I m 
wrong please !

I have found AFL function CategoryAddSymbol that might be useful.  
 
The stock data  and  industry code that I wish to apply to old 
ESignal database is regulated by Standard  and Poors with GISC code 
and the data  look like this:

Fields:
Ticker, Company Name, Sector Code, Sector Name, Industry Group Code, 
Industry Group Name, Industry Code, 
Industry Group Name, Sub Industry Code, Sub Industry Name

Data:
MMM, 3M Company, 20,         Industrials, 2010,                  
Capital Goods,          201050,       Industrial Conglomerates,      
20105010,  Industrial Conglomerates

( here is presented in word wrap form with added commas ...actually 
they are  500 long line rows, 10 fields in each row ) 


My question is .. should the new symbols be added first into "half 
populated" database   and then category manipulation be executed  ?  
Or shoud  I use ASCII impoprter  OR  industry.js ? 

Suggestions are appreciated

Drazen  






 



--- In amibroker@xxxxxxxxxxxxxxx, Jason Hart <jhart_1972@xxxx> wrote:
> Drazen, which market do the stocks that you want to add trade on?  
You can download a list from the support area which will 
automatically assign the stocks into sectors for you.
> 
> dstricek12@xxxx wrote:Hi
> 
> how could I assign 500 new symbols each in his appropriate sector 
ID ?
> Assume we have 9 sectors in SPX500 . It seems easy to add so much 
symbols
> in to Watchlist group in one or dozen takes, but even then there is 
a
> problem how to shift them back to appropriate sectors or markets.
> 
> By deafault Amibroker forces all new symbols to be placed in NYSE 
market.
> I read some tips but I m not handy with java scripts.
> It seems that very long night is before me.
> 
> Thank you, I hope someone could help.
> 
> Drazen
> 
> 
> 
> 
> Send BUG REPORTS to bugs@xxxx
> Send SUGGESTIONS to suggest@xxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at: 
http://groups.yahoo.com/group/amibroker/files/groupfaq.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/ 
> 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free web site building tool. Try it!



Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx 
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.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/