Pull Financial Data from Yahoo into an excel sheet from a program – Upwork


I want someone to develop a script for me that is able to pull the daily returns from NASDAQ 100 stocks and prints from the last month to 9/1/2005

The monthly API uses https://query1.finance.yahoo.com/v7/finance/download/IDXX?period1=1122872400&period2=1509512400&interval=1mo&events=history&crumb=udqaOarbBkF

Daily period =
https://query1.finance.yahoo.com/v7/finance/download/VOD?period1=1127797200&period2=1512021600&interval=1d&events=history&crumb=udqaOarbBkF

The script then puts it into an excel. I need an excel sheet having the closing price of the day and of the month

I need another excel also showing the daily and monthly returns. Please find attached how the excel sheet should look like

If the script can be in MATLAB, it will be preferred but if not any other program will work

Budget: $200

Posted On: June 02, 2018 19:17 UTC
Category: Web, Mobile & Software Dev > Web Development

Country: United States
click to applyPosted on Upwork.com