Đã hoàn thành

Retrieve Stock Market Data fromYahoo Finance using MS Excel 2016

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.

Kĩ năng: Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: data stock market data using, download data yahoo finance using vb6, programmer access stock market data, how to import stock prices into excel from google finance, download historical stock data into excel, download yahoo finance data into excel vba, get stock quotes in excel from google finance, how to get stock quotes in excel 2016, how to download historical data from yahoo finance to excel, real time stock quotes excel, how to import stock prices into excel from yahoo finance, stock market data feed mac, stock market data using aspnet, stock market data feed, actionscript stock market data, store stock market data sql server database, nse stock market data excel file, google stock market data format, market data google finance excel, stock market data last thirty years

Về Bên Thuê:
( 4 nhận xét ) Greenwood Village, United States

ID dự án: #18868327

Được trao cho:


Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$100 USD trong 3 ngày
(115 Đánh Giá)

6 freelancer đang chào giá trung bình $206 cho công việc này


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Thêm

$250 USD trong 4 ngày
(330 Nhận xét)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Thêm

$250 USD trong 7 ngày
(225 Nhận xét)

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 Thêm

$250 USD trong 1 ngày
(18 Nhận xét)

Hi Sir, I see you need to import Yahoo Finance historic data. I have a question. Do you want to import it directly and manipulate it automatically in excel or you'll import the data file like in CSV? I can use VB Thêm

$234 USD trong 7 ngày
(3 Nhận xét)

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.

$150 USD trong 5 ngày
(3 Nhận xét)