Find Jobs
Hire Freelancers

Access Database for stock analysis

$30-250 USD

Closed
Posted over 9 years ago

$30-250 USD

Paid on delivery
I download spreadsheets of stock data daily. I need to import these spreadsheets into access 2010, or be able to search them, and retrieve certain data daily. Also currently the data is colored using conditional formatting. I would like this to be preformed by Access depending on the data type and values. This will be a small project at first but will grow in scope. Attached is an example of what I have been doing manually with excel. The attached spreadsheet is a collection of independent spreadsheets that have manually been combined, color coded and then compared.
Project ID: 6984552

About the project

31 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
31 freelancers are bidding on average $142 USD for this job
User Avatar
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ ______________________________________ For some reason I was not able to see any conditional formatting in the excel that you have attached. Basically the sheet called "compair" is aggregating the various data from different dates and comparing the previous rank with the current one. I think this could be easily accomplished in Access. Conditional formatting is also possible in MS Access. The first sheet "ABCD" is not very cleat though. I look forward to hearing from you with more details. regards Rajiv
$100 USD in 3 days
4.9 (154 reviews)
6.9
6.9
User Avatar
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$98 USD in 3 days
4.8 (83 reviews)
7.3
7.3
User Avatar
Hi, I can do this job for you, i.e.: 1. Import conditions of coloring into MS Access 2010 table (for example, tblConditions) 2. Add form for import process of these spreadsheets into tables tblCompanies, tblTracking 3. Add report rptTracking 4. Add report rptCompare 5. Add main form frmSwitchboard Regards, programmer Aleks
$66 USD in 3 days
5.0 (49 reviews)
6.1
6.1
User Avatar
Hi, I have gone through your project requirement in detail and feel comfortable in taking up the project to provide required solution. In the solution, I can provide you MS Access database which will have following features : * form to import daily stock data * query/macro to format output based on descending comp rating of given day excel * report to show results on daily basis as shown in "Compair" sheet of attached excel. More details we can discuss on the chat to plan out work and start the project activity. Waiting for your response on the same. Thanks.
$138 USD in 5 days
4.7 (121 reviews)
6.1
6.1
User Avatar
Hello, I am interesting in your project. I have about 15 years of experience with VBA in MS Access and all MS Office products. Best Regards, Dorel Jucuti
$100 USD in 3 days
5.0 (19 reviews)
4.6
4.6
User Avatar
Hello, I am certain I can help you out with your project request. I do have a few questions: 1. From where do you source your daily stock information? 2. Is your list of ticker symbols static or does it change? If it does change how frequently does that occur? Assuming your list does change, would you be OK with maintaining an Excel table of current symbols you wish to see data for that would be used to drive daily updates? 3. Do you ever stop tracking a stock? And if so, do you wish to keep or purge the history from those? 4. Do you only deal in the US markets or are there also foreign exchanges and currencies involved? 5. How proficient with Access are you? Would you be OK with simple macro that produce any reports or queries that you need? If you have any questions please feel free to reach out to me at any time. Thank you for your consideration.
$150 USD in 3 days
5.0 (1 review)
3.5
3.5
User Avatar
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$55 USD in 3 days
4.8 (4 reviews)
2.9
2.9
User Avatar
How do you want these sheets to appear in ms access? Do you want them as individual tables or would you want it to append all those sheets plus any future import into one master table. We could have a form with a drop down list and filter to the data you want to see. Let me know if this interests you or if you have something else in mind?
$155 USD in 3 days
5.0 (1 review)
3.0
3.0
User Avatar
Dear Sir/Madam, I have +7 year experiences in MS Access Database. To Provide Quality,Modular , Object Oriented and User Friendly Development. Thanks & Regards
$155 USD in 5 days
4.8 (3 reviews)
2.0
2.0
User Avatar
Hi I am expert in Access Databases. I can do this data analysis in Access from data in Excel. I can add conditional formating and analysis as you require. Ready to start. Thanks.
$55 USD in 3 days
3.8 (1 review)
1.3
1.3
User Avatar
Features that would be implemented: * Application would be import excel to access * Do conditional formatting based on data type and values Technology : C#
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Over 14 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application (OSS & BSS Rating and Billing), Financial Application, ERP-Application, and School Application, Central and State Govt. Offices application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, MVC, Entity Framework, Visual Basic, Crystal Report, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, DurandalJS, KendoUI etc all advanced technologies. I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$287 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have experience of 2 year in data entry.I will enter all your data in to access file which data you have in excel file
$222 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm an IT student with good knowledge in desktop app, excel and access. I can create vb.net app to download your excel file automatically and then run access and command it to feed excel in appropriate table. Check my review and my portfolio and send me p.m to send you details. regards
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I will do it. I have experience working with Exsel &VB & database more than 10 years. Wrote a lot of tools to help office workers.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir I am an experienced freelancer and have the ability to do what you have demanded. I almost finished my current project that was wanted in excel but I convinced the employer to get it done in access and he is satisfied. So hope you will let me do this project................. regards
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I specialize in solutions for stock markets and trading. I am ready to implement a web app to track stocks and quotes, highlight certain cells, auto update data etc. Can you please contact me to discuss the requirements of this project in more detail? My background: I am a professional web developer with more than 7 years of extensive hands-on experience in PHP, HTML, CSS, Java, JavaScript, JQuery, MySQL and other web technologies. I look forward to working with you on this project. Thanks, Alexey
$249 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$133 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
White Haven, United States
0.0
0
Member since Jan 16, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.