need help getting started, or whether I should

[Jack]

And sorry for cross-posting, but I wasn't able to tell if the same
people were checking each of the groupls.

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. I
wouldn't mind spending some time on it; just not an inordinant amount.

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!

 

[Jeff Boyce]

Already responded to in another newsgroup.

By posting separately to each newsgroup, you have to look many places to see
if you get any responses. And the folks who volunteer their time here in
the 'groups unnecessarily duplicate each others efforts.

It is rarely necessary to post to more than one newsgroup ... just pick the
one that best fits your topic. If you are absolutely convinced that your
situation fits in more than one newsgroup, when you post, post to the one or
two that apply, using the "Newsgroups:" field to add the others.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jack]

Sorry for the cross-post, as I acknowledged when I did so; I'm aware
that it makes a bit more work for me to check for responses, and tried
to keep it from being more work for others by announcing that it was
at the beginning of the other messages.

But not knowing Access, and clearly not having a firm grasp as to the
differences between the different groups (and knowing that sometimes
they overlap, but some people check one and not another), I decided to
try to solicit different responses. I understand if there were one
firm answer, but given my question - not being a cut-and-dried "this
is how it's done" question, I thought (no offense intended) that yours
might not be the consensus of all Access users, so that I wasn't
causing responders to unnecessarily duplicate each other's work.

So, sorry if I was wrong and I'm violating too much netiquette.

Having said all that... Any chance that there's a commonly used
template out there that would apply to my usage, that I'd just have to
change the fields? Just askin'...

 

[Mark Han[MSFT]]

Hi Jack,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to track the
requirment data to do some analyze.
If I have misunderstood, please let me know.

SInce the shema of the table is based on the bussness, the suggestion might
not perfect to you. in order to address your concern, we might need to
create a table like below:
Table 1 have the following column
stock_ID, stock_name, Price_open, Price_close, data, the
amount of GAP
1234 microsoft 11 12
2009/02/18 10
Table 2
stock_ID, stock_name, data UP, Down, time,
price
1234 microsoft 2009/02/18 1 0
2009/02/18 9:00 11
1234 microsoft 2009/02/18 0 1
2009/02/18 10:00 9

Hope the above helpful.

Besides, generally our newgroup focus on a detail break/fix issue.
Regarding to the requirement, it seems to be a "project". So it is better
to turn to our advanture team for help.Advisory Services is an hourly
fee-based, consultative support option that provides proactive support
beyond your break-fix product maintenance needs. This support option
includes working with the same technician for assistance with issues like
product migration, code review, or new program development. This service is
typically used for shorter engagements, and is designed for developers and
IT professionals who do not require the traditional onsite consulting or
sustained account management services that are available from other
Microsoft support options. To acquire this service, please refer to MCS,
Essential Support or Premier Support options on
http://www.microsoft.com/asia/services/microsoftservices/supp.mspx.

Have a nice day!

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

 

[Jack]

Thanks, Mark, but I'm not looking to hire someone. If I can't do it
myself, I'll just be passing on it. What you posted appears to be what
I started with in excel, and from what i understand so far, I need to
break up a lot of the data into separate tables, not group them all
together. But maybe I misunderstand it. I got some dvd's on access
from the library and will go through them, and understand it a lot
better then ( I hope! )

 

[Mark Han[MSFT]]

Hi Jack,

Thank you for the reply.

How the data is broken into different table is based on your bussiness
requirment. and what relationship those tables should have is also based on
the bussiness role.

Besides, since generally, we only focus on break/fix issue regarding to our
policy, if you have a detail error or issue when your design the
database/tables, it is welcome that you post them here. we will try our
best to help to resolve it.

Have a nice day.


Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================