thoughts on how difficult this database would be to make?

[Jack]

I'm a newbie, and while I wouldn't mind learning access at some point,
for now I need it for one purpose, which takes precedence time-wise I
trade stocks (futures, actually), and would like to go back and track
how (we'll use stock for this purpose) behaved each day at the open.

Let me explain my purpose: A stock may "gap up" or "gap down", meaning
it's price opens at a price different from where it closed the day
before. Often that gap will be filled, meaning the price will go back
down (if it was a gap up) to the previous day's close. I want to track
how often it did that, how often it went only 1/2 way, how much it
went up before doing it, what day of the week it was, etc., with
several different criteria

I had started to compile it in excel, but quickly had an AHA moment
and realized this was a database I needed. Here are the categories I
have that I want to track, and then be able to search based on several
criteria. I imagine I want to creat several different tables, but it
seems to me the hardest part, and hardest to learn, is how I want it
organized. Which categories in which/how many tables. Is this more
daunting than I initially imagined (which was thinking it wouldn't
take long). Here are the categories:

DATE AMOUNT OF GAP UP DOWN % Filled Minutes it took
to Fill How Much Up before Filling, etc., etc.

I hope that's clear. TIA!

 

[Jack]

Thanks for the great feedback. As I was creating the columns in excel
I realized what you're pointing out - the Creeping Feature Syndrome
had come upon me. There are a few other things I'm looking for that I
didn't include in my post, as I simply wanted some "for instances".
I was hoping there might be a template out there, to which I'd have to
simply add some fields or more tables, because as you say, knowing how
it all should be organized will be a big aspect, and that's where a
template - or ideally, a developer, would come into play. And I
imagine where some "how-to" articles on the net won't really cut it.

I'm actually not planning on this being as all-encompassing as you
might imagine. The intent is simply for one type of trade, a gap play,
wherein you "fade" the gap, but the liklihood of that occurring is
affected by several variables, which are the things I was planning on
including: size of gap, day of week, whether on options expiration or
not, first or last day of the month (those are all things that have
been identified by a previous study, but which is a few years old) and
I wanted to add in: how large of a stop one needs to allow for prior
to the gap filling (your risk-reward aspect), how its affected by what
type of day it was the day before, if the gap was caused by a news
announcement at 8:30AM, an hour before the open. And I was only
looking at using it on the DOW and S&P, no stocks. Just didn't know
what terminology to use here for possible non-traders. Wasn't
considering seasonality or trends, either. But your points are very
well-taken, and indeed, outside help may be the answer. Thanks again
for taking the time and effort in your response!

 

[Jack]

You're right - this is a natural application for Access, or any
"relational" database. The essential step is to get your tables right.
I'd guess one Stock could have many Gaps? A classic one-to-many
relationship, suggesting a table for Stocks, and a table for Gaps which
would contain a reference to a specific stock.

A bit of terminology: A table has a fixed number of fields (e.g. DATE)
and an arbitrary number of records.

You might like to watch a brief video I suggested here earlier (and
which apparently went down well):
http://www.lynda.com/home/Player.aspx?lpk4=13150
(I've no connection with this site, other than as a satisfied customer).

Suggest you think about what tables you might need, and post back.

Phil, London

Thanks much for the response! Will check out the video, and together
with the other excellent response, will decide whether this is within
my scope or not. I was just planning on using this for one trade per
day, per instrument (actually the DOW and S&P futures, not any
stocks). So fairly narrow in application, but a lot of variables.
Thanks again!

 

[Jack]

Thanks much for the response! Will check out the video, and together
with the other excellent response, will decide whether this is within
my scope or not. I was just planning on using this for one trade per
day, per instrument (actually the DOW and S&P futures, not any
stocks). So fairly narrow in application, but a lot of variables.
Thanks again!

Fascinating video (boy, I bet THAT pegs me as a fun party guest!)
Okay, now I'm hooked on learning to do this. Either I'm
organizatinoally anal, or I'm just trying to avoid tradiing. Thanks
again, and will post back after I get further along.

 

[Steve]

Hello Jack,

If you need to build the database some time soon, I can help you. I provide
help with Access, Excel and Word applications for a reasonable fee. I could
work with you to create your database and get it up and running in a short
time. I'm sure your gains from the stock would easily cover my fees. If you
would like my help, contact me at (e-mail address removed).

Steve

 

[Douglas J. Steele]

Please stop abusing these newsgroups, Steve.

 

[John... Visio MVP]

Hello Jack,

If you need to build the database some time soon, I can help you. I
provide help with Access, Excel and Word applications for a reasonable
fee. I could work with you to create your database and get it up and
running in a short time. I'm sure your gains from the stock would easily
cover my fees. If you would like my help, contact me at (e-mail address removed).

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified professionals who gladly help for FREE.
Stevie is not one of them. He is not highly qualified, professional or
willing to help for free. If he was any good, his past customers would be
drowning him in repeat business, but it appears, for them, once was more
than enough.


John... Visio MVP

 

[Keith Wilby]

If you would like my help, contact me

But before you do that, read this:

http://home.tiscali.nl/arracom/whoissteve.html

 

[Jack]

But before you do that, read this:

http://home.tiscali.nl/arracom/whoissteve.html

Funny... The guy merits his own web page! Pretty impressive. Thanks
for the heads-up. I'd take it on myself, anyway. Even if he knew what
he were doing, and it legitimately could pay for itself after awhile,
I don't have the money to do that. To paraphrase Dudley Moore in
Arthur, "Not all people who trade are rich. Some trade because they
aren't rich."