|
PureBytes Links
Trading Reference Links
|
Hi TJ and All,
I wish to export my entire AB database MINUS those tickers whose:
Volume on the Last Date of the DB is less than 25000 shares,
Whose price is less than $5
Or more than $50.
After reading the instructions in the AB Help, Explore Tutorial, I did
what was stated but not knowing what to expect, I pushed the Explore
button and waited and waited and waited!
I finally stopped the process after 35 minutes as I learned that:
1.) Each day occupied one line of the AB spread sheet display.
2.) I was after around 625 days of each of 2500 tickers (less those
kicked out by the filter), and felt that maybe I was running out of the
limit for the program.
In looking critically at the data I found that for some tickers I
had only 4 entries on others many more --- I then thought that I'd better
look at the filter again -- and to the best of my copying ability, it was
correct....but what happened was.
The filter was being applied to each date entry, -- if ANY DAILY
entry dipped below/above any of the thresholds in the database then those
DAILY entries would be deleted from the database, leaving the remainder
alone.... this surely screws up data - in no time flat!!
So the reason for this e-mail was to inquire if there was a way to have
the filtering apply to just the last day and accept or reject the entire
ticker data based on that time period?
The only work around that I find is that I filter the tickers with
a "daily" run and save those tickers as a LIST.
Then use those LIST tickers as the "master" list to
export the database.
I'd appreciate any thoughts or assistance.
Best Regards,
Hal
P.S. My e-mail program (Eudora) allows me to view mail entirely across my
screen width. I have my TOOLS / OPTIONS / VIEWING MAIL / MESSAGE
WINDOW / WIDTH, set for 150 characters per line and 30 vertical
lines.
This message was written using the full width of my screen (except those
obvious indentations and columns I chose to insert). This addition is
sent because the majority of the messages I view occupy less than half a
line length when I view them. I investigated this a bit and I came to the
conclusion that the SENDER controls the display width on the receivers'
screen. I would appreciate some feedback regarding how this message
appears on your screen. If it is NOT full width than maybe I can adjust,
or you can adjust the "Message Window Width and Number of lines.
Since this is Off-Topic, a personal message would be most
suitable. hal
|