|
PureBytes Links
Trading Reference Links
|
Try this quick method to delete them.
1) make a spare copy of the database with some data in it (say at
least 5days).
2) delete all of the .OB stock in that database PLUS any other stock
symbols that don't have data in them.
2a) leave AB open with the above database as the current database
2b) open a plain text editor (like NotePad)
2c) form within NotePad open ProgramFiles/AmiBroker/Scripts
then set file type to "All Files"
then select CleanupScript.js
2d) alter the detection threshold in days to 4
/* detection threshold (in days) */
var Threshold = 4; // one month for example
2e) save and close
2f) Now that you have the correct setting in your cleanup.js file
(for this job) go to Windows Explorer (or your OS file browser) and
double click on ProgramFiles/AmiBroker/Scripts/CleanupScript.js
It is like a mini program (written bt Tomasz) and it will find and
delete all of the symbols that don't have any data in them (that will
mainly be .OB stock since DTN doesn't support that suffix)
Follow the prompts and the job will get done.
If you elect not to delete immediately you can choose to save the
list to a text file and edit the list there, before deleting them (in
a round about way later).
brian_z
2d) change--- In amibroker@xxxxxxxxxxxxxxx, "Louis Préfontaine"
<rockprog80@xxx> 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@xxx>:
> >
> > 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/
|