Excel Uploading S&P 500 Stock Prices
Budget: $30 – $250 USD
This is a relatively easy project.
Need:
1. Spreadsheet goes to yahoo finance, brings in the prices BUT either yahoo finance changed or MS VB, the prices in the spreadsheet MUST be in descending order.
For example: 1/27/2023 thru 1/28/2022
AND NOT 1/28/2022 thru 1/27/2023
2. To upload "Daily" "1 minute" S&P stock prices. Need a new option in suggestion box for 1 minute
3. Leave Option for up to 9,000 stocks selected.
4. Data is dumped on Historical Prices tab
5. Macro updates other sheets - Might need to be updated
Need:
1. Spreadsheet goes to yahoo finance, brings in the prices BUT either yahoo finance changed or MS VB, the prices in the spreadsheet MUST be in descending order.
For example: 1/27/2023 thru 1/28/2022
AND NOT 1/28/2022 thru 1/27/2023
2. To upload "Daily" "1 minute" S&P stock prices. Need a new option in suggestion box for 1 minute
3. Leave Option for up to 9,000 stocks selected.
4. Data is dumped on Historical Prices tab
5. Macro updates other sheets - Might need to be updated