To place 3000 data files (15 folders) into database
Budget: £10 – £20 GBP
SPECIFICATION
Task one
place all the 3000 data files into a database so that they can be queried from my excel spreadsheet
The query will involve looking up Ticker, Date and Time and returning value Open, High Low, Close or Volume
I suggest the data is all in one table for ease of lookup
This would require adding the ticker to the front of each row in the table
The data will never be modified it is purely for lookup
task two
create an automated query to fill in the start and end price in the spreadsheet ie rows M and N
ideally this would be done with a single button on the sheet that when pressed fills in columns M and N
The query will unfortunately have to deal with missing Tickers
ie some Tickers we do not have data for so, the query will need to return a N/A or 0 when the ticker is not found without throwing an error and stopping the query from continuing
presently there is an issue in the spreadsheet that some of the dates are in date format and some are in text format
we will need to figure out how to edit them all to time format
Task one
place all the 3000 data files into a database so that they can be queried from my excel spreadsheet
The query will involve looking up Ticker, Date and Time and returning value Open, High Low, Close or Volume
I suggest the data is all in one table for ease of lookup
This would require adding the ticker to the front of each row in the table
The data will never be modified it is purely for lookup
task two
create an automated query to fill in the start and end price in the spreadsheet ie rows M and N
ideally this would be done with a single button on the sheet that when pressed fills in columns M and N
The query will unfortunately have to deal with missing Tickers
ie some Tickers we do not have data for so, the query will need to return a N/A or 0 when the ticker is not found without throwing an error and stopping the query from continuing
presently there is an issue in the spreadsheet that some of the dates are in date format and some are in text format
we will need to figure out how to edit them all to time format