Re: thoughts on how difficult this database would be to make?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 santus@xxxxxxxxx

Steve


"Jack" <a@xxxxx> wrote in message
news:13ump4hsk2fjcb7dhjhc05lol1lqp6mdcu@xxxxxxxxxx
On Tue, 17 Feb 2009 21:04:05 -0500, Jack <a@xxxxx> wrote:

On Tue, 17 Feb 2009 22:01:32 +0000, Philip Herlihy
<bounceback@xxxxxxx> wrote:

Jack wrote:
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!

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!
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.


.

Relevant Pages

  • Re: thoughts on how difficult this database would be to make?
    ... If you need to build the database some time soon, ... how (we'll use stock for this purpose) behaved each day at the open. ... Often that gap will be filled, meaning the price will go back ... You might like to watch a brief video I suggested here earlier (and ...
    (microsoft.public.access.gettingstarted)
  • Re: create a small stock control and sales database
    ... "Inventory control" sample database doesn't really "fit the bill". ... My comments also apply to the Northwind Traders database. ... Description, type of container, weight, Price, and Purchase price.This table will rarely be changed, the "changing tables" are stock in and stock out. ... But you might also want to copy it to a new field in [Product sold] to reflect what the unit price was at the time of a specific sale. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do i set up an access program to help with stock control
    ... monitor stock ... Like all database design projects, you will sit down and work out what ... you can link them all together in *data modeling* relationships. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: create a small stock control and sales database
    ... keeping a running total of stock, both in and out, So... ... > Northwind Traders database. ... > You might want to also include a primary key in [Product sold], ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Thoughts on if this database would be too hard for me (newbie) to do?
    ... Good luck! ... If you want to get the best use of a relational database like Access, ... If you already have experience working in Excel, ... How much of the gap got filled?" ...
    (microsoft.public.access.tablesdbdesign)