DESIGN NOTES - Retrieving stock market historical data from Yahoo Finance
Compatible with Microsoft Excel 2016.
Data comes from Yahoo Finance.
Use a command button to initiate the program.
Must run for as few as 2 trading days, maximum up to 1,000 trading days.
Maintain header row A of "Date/Open/High/Low/Close/Volume", in this order. This will be a data file to be automatically imported to an Excel spreadsheet, so format matters. See attached file.
Read input fields of "Ticker, Oldest Date, Newest Date". "Ticker" should not be case sensitive.
Error check & message: "Ticker not found"
Error check & message: "Invalid date order" (Oldest date & newest date reversed)
Error check & message: "Invalid end date" (Newest Date must be today or older)
Clear all previous output, potentially 1,000 days.
Write new output. Oldest at the top, newest at the bottom.
Format "Date": m/d/yy, Arial 8
Format "Open/High/Low/Close": commas, 2 decimal places, Arial 8
Format "Volume": commas, no decimal, Arial 8
Audible alert and "OK" button up completion.
OK to turn off screen updates while running.
I want to learn from the application and possibly improve. Include an explaination how I get into the code to make changes. If it is locked, then provide the passcode. In exchange for final payment I receive unconditional rights to possess, modify and use for any purpose.
Propose milestones of 1/3 acceptance, 1/3 first submittal, 1/3 fully operational/close out.
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
Bu iş için 6 freelancer ortalamada $206 teklif veriyor
hi, I am very good in data entry having good typing speed as well and also very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the Daha Fazla
I can do what you need. I'm expert using Excel VBA for scrapping purposes. Don't hesitate to contact me so we can discuss the details of your project.