To place 3000 data files (15 folders) into database
£10-20 GBP
Abgeschlossen
Veröffentlicht vor mehr als 2 Jahren
£10-20 GBP
Bezahlt bei Lieferung
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
Hi,
Can you please send all these data files. I have a solution in hand, but I need to adjust the macro and see how it works with your data.
Best Regards,
Serdar Yalcin
Hi
I can do it for you free just because I have to get first good comment in my freelancer profile
You are so lucky.
If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible.
Thanks! Mojtaba
£10 GBP in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0
4 Freelancer bieten im Durchschnitt £15 GBP für diesen Auftrag
Hi there,
I will do To place 3000 data files (15 folders) into database within a short time frame. can start right away.
I have read through your project description. I have done several similar jobs.
You can check my profile here for details at https://www.freelancer.com.bd/u/ibrahimstk 890+++ project done perfectly.
I am ready to do some free samples for you. Message me so we can discuss more.
Click on the "CHAT" button so we will discuss it in detail.
Thanks
Ibrahim
Greetings Sir, I am Muhammad Faisal and i totally understood what exactly you need and i am willing to help you out and do the project accordingly to your requirements !!!
Please come inbox and we can start working on your project immediately !!!
Thanks