By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Help-Access database that I update daily with new spreadsheet

P: 2
I have data that I need to save over time. Each day I get a spreadsheet of products. First one has 300 products and now 100's of spreadsheets later its has 1400 products.

Each spreadsheet is named by date. It is comprised of position 1-1400 (ranked by total $$ worth of inventory), name, symbol, market price, total inventory, inventory cap in pounds(can change over time-but slowly), last 24 hr change in price (by %) and last 7 day change in price (by %)

example:
date 1-3-18
1, cherries, chr, $1.19, $27,387, 35200, +1.91%, -6.22%
2, blue berries, blb, $2.76, $25,139, 125500, -.27%, -1.47%
3, strawberries, stb, $2.12, $25,005, 45750, +3.97%, +9.36%

I want to go back 4 years and input 1 spreadsheet a week. Once I get this thing populated to the current week I will update it daily.

I need to see how a product's position, price, total inventory and inventory cap changes by day, week, month and year. Products may be added at any time and removed at anytime. I don't want to delete any past data. So this needs to keep track of all products ever added. Yesterdays spreadsheet had 1379 products, today's 1386 and tomorrow could be 1384.

This may be a lot, I have no idea where to start.
Jan 4 '18 #1
Share this Question
Share on Google+
2 Replies


gnawoncents
100+
P: 214
First, welcome to Bytes!

We want to help you along your path to success, but can't/won't build a database for you, so we'll need you to provide some more information, then we can guide you along the correct path.

When you say you "need to see how a product's position, price, total inventory, and inventory cap changes by day, week, month and year," what do you envision? Are you going to build a report that displays all this data at once? Will it be user-selectable fields (e.g. select change by day/week/month/year and display the results)?

You likely already have an idea of what this will look like, but it's hard for us to give you advice on where to begin until you let us know where you want to end up.
Jan 4 '18 #2

P: 2
Thank you for your input. I will work up what the visual display of what the data should look like.
Jan 4 '18 #3

Post your reply

Sign in to post your reply or Sign up for a free account.