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

[amibroker] Re: Using Jim's tickers... with some cutomization



PureBytes Links

Trading Reference Links

You don't have to worry about sectors - the sector ID is 
automatically assigned to the symbol by the Industry ID (it is setup 
when the database is created - it uses the broker.sector and 
broker.industries files on a one off basis) - have a look at Symbols 
>> cAtegories >> Industries and you will see the assigned sector, 
relative to the industry, in a dialog box on that tabbed pane.

--- In amibroker@xxxxxxxxxxxxxxx, "brian_z111" <brian_z111@xxx> wrote:
>
> Louis,
> 
> I will write a better explanation at the UKB at some stage because 
> the subject is obviously of general interest to a secton of users.
> 
> I might not write up the US-Stocks database as it is too big and 
also 
> I am reluctant to post files that will become obsolete and need 
> ongoing updates.
> 
> I try to give enough of an explanation so that people have the 
skills 
> to make their own updated files.
> 
> Ami is (for me) a rather unique program and, amongst other things 
it 
> is a hybrid spreadsheet/database.
> 
> Perhaps you are not familiar with databases.
> 
> A database can store info on say, Brian and Louis.
> 
> B&L would be the names in the KeyField (column) == the main 
> identifier.
> B&L's individual attributes can be stored in additional fields 
> (columns) e.g. age, nationality, gender etc
> This information can be stored as text or as a number, so:
> 
> Louis, Canada, M
> Brian, Australia, M 
> 
> would become:
> 
> Louis, 2, 2
> Brian, 1, 2 
> 
> (alphabetically Aus == 1, Canada == 2 etc)
> 
> That is all you need to do - add numerical ID's to Jim's XL file in 
> place of the text ID's (ASCII loves number ID's - look on the ASCII 
> help section and you will see that the $Market command uses 
<number> 
> as it's argument)
> 
> Instructions for step b)&c):
> 
> STep 1:
> 
> i)Open AB with US-Stocks as the database
> ii)Look in AB >> symbols >> categories >> Markets and you will see 
> something like this (without the numbers after the names):
> 
> Unassigned
> NYSE
> AMEX
> Nasdaq
> OTC
> Market 5
> Market 6
> 
> The first 4 ID's have been used by Jim's setup, as Market 
categories, 
> and they have been replaced by a name.
> 
> You need to manually enter the corresponding ID numbers into a 
column 
> in your US-Stocks XL file so that you can import the Category ID's 
> when you import the suffix free symbols - tehn you do that for all 
> Categories (Market.Group,Sector, Industry - you can do 
> Watchlsits,Favs and INdexes too but US-stiocks doesn't ahve them).
> 
> To help do this here is a formula that exports the ID names/ID 
> numbers so that you can print them and cross check as you manually 
> enter them.
> 
> Step2:
> 
> i) make a new "Files" folder in the AmiBroker directory (text files 
> will be auto saved there).
> 
> ii)Copy/paste/save the formula and run it as a scan in US-Stocks 
> database
> 
> iii) change the inputs to get a text file for all categories
> iv) prnt them 
> 
> The AA window will be open and empty but you will find the text 
file 
> in the Files folder (if you repeat the exercise it will overwrite 
the 
> exisiting file without warning).
> 
> //S_ExportCategories_v4
> 
> //tested OK
> //run with Scan current symbol and n = 1 datapoints
> //first create a "Files" folder in the AmiBroker directory (using 
> your OS file manager)
> //input == change the text filename AND the categoryParameter for 
> each category
> //input number == change to 63 for sectors, unlimited for WL's.... 
> //........ignore for Favorites/Indexes AND 255 for all other 
> Categories
> 
> Buy = 0;
> 
> fh = fopen( "C:\\Program 
> Files\\AmiBroker\\Files\\ExportMarkets.txt", "w");//input 
> if( fh ) 
> { 
> 
> 	for (i = 0; i <= 255; i++)//inputnumber
> 
> 	{
>  		
> 		ID = CategoryGetName(categoryMarket,i); //input 
> 		fputs(ID + " " + i + "," + "\n", fh );
> 
> 	}
> 
> 	fclose( fh );  
> 
> } 
> else 
> { 
>    printf("Error opening file"); 
> } 
> 
> 
> For the US-Stocks market you will see this:
> 
> Unassigned 0,
> NYSE 1,
> AMEX 2,
> Nasdaq 3,
> OTC 4,
> Market 5 5,
> Market 6 6,
> Market 7 7,
> 
> Step 3:
> 
> i) Open US-Stocks XL
> ii) Sort by Markets
> iii) add a new column for Market ID (beside Markets column)
> iv) manually enter (copy/paste or fill down) a 0 beside all stocks 
> that are sorted as unassigned (enter the zero in the MarketID 
column.
> v) carry on to do this using 1 beside all NYSE sorted stock and 
> repeat for all other named Market ID's
> 
> Step 4, 5 etc
> 
> repeat step 3 by sorting for Groups and entering the corresponding 
ID 
> number to a Groups ID column.
> 
> When you have done that for all the categories you want to import 
> then you make up a corresponding (ASCII) formats file and use that 
to 
> import the fields you want from the modified XL file.
> 
> Note: it is a bit tedious (120+ industries) but it is actually not 
> difficult to implement.
> 
> The only possible trouble will be if you try to import Names with 
it -
>  aB might not like it if the names already exist (not sure about 
> that) - to get around that either - delete the stocks you don't 
want 
> first or don't add the names to the suffix free symbol import (you 
> can add them later if needed).
> 
> Also, if you read PaulHo's posts on ALIASES you might become 
> interested in importing the .OB symbols as the ALIAS for the IQ 
> symbol (suffix free).
> 
> Don't worry too much about the last part - I will put an example at 
> the UKB.
> 
> BTW you can actually use the formula above to help make 
broker.sector 
> and broker.industries files then put them in the AB directory then 
> create a new database (US_Stocks_DTN?) and then ASCII import the 
> whole database structure using JIms EXcel file (if you add all of 
the 
> categories ID numbers to his master XL).
> 
> brian_z
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine" 
> <rockprog80@> wrote:
> >
> > Hi Brian,
> > 
> > I am sorry...  I really don't understand points b) and c).  I 
> copied all the
> > .OB tickers to a new .XLS file but I am not sure what you mean by 
> entering
> > columns for sector, industry, etc.
> > 
> > I'm sorry if I sound like I am too slow to understand, but really 
> this thing
> > puzzles me.  I am thinking about changing my real-time provider 
> because of
> > this... I just can't figure out how to delete the .OB.  I am 
> seriously
> > considering removing manually 50 per day and in a month or two 
that 
> would be
> > over...
> > 
> > Louis
> > 
> > 2008/3/29, brian_z111 <brian_z111@>:
> > >
> > >   Louis,
> > >
> > > Dick is quite right.
> > >
> > > It is easier to work with the sorted list of .OB stocks by 
> themselves.
> > >
> > > Try this:
> > >
> > > a) sort by .OB and copy all OB rows to a new file US-
Stocks_OB.xls
> > > b) enter columns for sector ID, industry ID, market ID, and 
Group 
> ID
> > > c) manually enter ID numbers into each column (the numbers 
should
> > > align to the 0 based count in AB >> symbols >> categories
> > > d) save a copy as US-Stocks_OB.csv
> > > e) write a formats file to suit and save it in 
> Programs/AB/Formats as
> > > US-Stocks.format (allow for adding new symbols)
> > > f) open a spare copy of US-Stocks and ASCII import US-
> Stocks_OB.csv
> > > using US-Stocks.format as file type
> > >
> > > The suffix free symbols should now be in the database in their
> > > correct categories (if so you can delete the old symbols that 
have
> > > suffexes)
> > >
> > > brian_z
> > >
> > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
> 40yahoogroups.com>, "Louis
> > > Préfontaine"
> > > <rockprog80@> wrote:
> > > >
> > > > Hi Dick,
> > > >
> > > > I am not sure to understand how you would do that. I know how 
to
> > > eliminate
> > > > the .OB from the Excel file provided by Jim, but I don't know 
> how
> > > to put the
> > > > files back.
> > > >
> > > > I think I understand your point: there is no need for me to 
> start
> > > again from
> > > > scratch. I can use Jim database, but still, I am stuck with 
the
> > > same
> > > > problem at the end: the pink sheets tickers are from different
> > > categories,
> > > > industries, sectors, so how would I enter them at the correct 
> place
> > > if not
> > > > manually?
> > > >
> > > > Thanks,
> > > >
> > > > Louis
> > > >
> > > >
> > > >
> > > > 2008/3/28, areehoi <areehoi@>:
> > > > >
> > > > > Louis,
> > > > > There is no need to convert the XL files to ASCII. Jim has 
> already
> > > > > done this by providing the US-Stocks database. To simplify 
> take
> > > the
> > > > > US-Stocks database (intact) and copy then paste in the 
> Amibroker
> > > > > Program files (be sure to rename the existing one to 
another 
> name
> > > ie
> > > > > ...US-Stocks1). When you open AB go to open database and 
pick 
> the
> > > new
> > > > > US-Stocks. It should work. To eliminate the "OB,s" and "Pink
> > > Sheet"
> > > > > go to the Excel spreadsheet and sort on the column that 
> carries
> > > them.
> > > > > Copy them and put in word (unformated) so you can make a 
coma
> > > > > delimitated ascii file. Put that file in a blank Watch list 
> from
> > > which
> > > > > you can delet all.
> > > > >
> > > > > Dick H
> > > > >
> > > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
> 40yahoogroups.com><amibroker%
> > > 40yahoogroups.com>, "Louis
> > > > > Préfontaine" <rockprog80@>
> > > > > wrote:
> > > > > >
> > > > > > Hi Brian,
> > > > > >
> > > > > > Even with the precedent method, it does not work. It 
works 
> fine
> > > the
> > > > > first
> > > > > > time with the first group, but then whatever the number 
of 
> the
> > > > > industry I
> > > > > > choose, the tickers go in the first one.. or even one in 
the
> > > fourth
> > > > > group,
> > > > > > with no particular reason. This looks to me like a 
strange 
> bug
> > > if it is
> > > > > > one!
> > > > > >
> > > > > > Louis
> > > > > >
> > > > > > 2008/3/18, brian_z111 <brian_z111@>:
> > > > > > >
> > > > > > > Try this:
> > > > > > >
> > > > > > > a) convert CSV lists >> text file
> > > > > > > b) import to Watchlists
> > > > > > > c) use categoryAddSymbol to move from WL to
> > > Markets/Groups/Sectors
> > > > > > >
> > > > > > > (as per "SetUp A Custom Database/Nasdaq" at the UKB
> > > > > > >
> > > > > > > I think it is also possible using AFL (even within AB) 
but
> > > others
> > > > > > > could help you more with that than yours truly.
> > > > > > >
> > > > > > > brian_z
> > > > > > >
> > > > > > > --- In amibroker@xxxxxxxxxxxxxxx <amibroker%
> 40yahoogroups.com><amibroker%
> > > 40yahoogroups.com><amibroker%40yahoogroups.com>, "Louis
> > > > > > > Préfontaine"
> > > > > > > <rockprog80@> wrote:
> > > > > > > >
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > I really enjoyed using Jim's tickers
> > > > > > > >
> > > > > http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
> az.com/icc%<http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
> az.com/icc%25>
> > > <http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
az.com/icc%
> 25>
> > > > > <http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
> az.com/icc%<http://icc-az.com/icc%2Daz/default.html?http%3A//icc-
> az.com/icc%25>
> > > 25>
> > > > > > > 252Daz/
> > > > > > > >
> > > > > > > > However, I see that this is Yahoo's formatting with 
e.g.
> > > AAAA.OB
> > > > > > > for pink
> > > > > > > > sheets while my provider would prefer simply AAAA. I 
> tried
> > > to
> > > > > > > remove the
> > > > > > > > .OB with Excel, and did it correctly, but then I 
don't 
> know
> > > how to
> > > > > > > import
> > > > > > > > the files WITH the categories/industries as Jim 
setted 
> them
> > > up. In
> > > > > > > the
> > > > > > > > import wizard, there are no options for those 
> categories,
> > > so would
> > > > > > > there be
> > > > > > > > another way to do this?
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > >
> > > > > > > > Louis
> > > > > > > >
> > > > > > > >
> > > > > > > > p.s. I will try to redownload Amiquote to use Yahoo 
with
> > > those, but
> > > > > > > would
> > > > > > > > enjoy using my intraday data if possible.
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >  
> > >
> >
>



------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/