Feedback by UserVoice

Andrew Sinclair

My feedback

  1. 1,110 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Huge progress update toward historical data! We have released our preview of the StockHistory function! https://support.microsoft.com/en-us/office/stockhistory-function-1ac8b5b3-5f62-4d94-8ab8-7504ec7239a8

    However, this is only available to our Beta Channel at the moment, so when it is rolled out to General Availability, I will be sure to update the status to completed.

    If you are able to use the feature in preview and have feedback, please send-a-frown for us to review.

    —Kaycee Reineke
    Excel PM

    An error occurred while saving the comment
    Andrew Sinclair commented  · 

    Looking through the comments and I can see many people are looking for something to use with the non Office365 versions of Excel as well as retrieve historic data etc.

    I’ve built an Excel Add-In (https://www.excelpricefeed.com) which retrieves financial prices/data via simple formulas. It also includes a search function so you can easily find stock codes. It currently connects to Yahoo Finance, I am working on adding other data providers.

    For example to populate a cell with the latest Apple stock price: =EPF.Yahoo.Price(“AAPL”)

    You can also grab prices on dates using a formula like this: =EPF.Yahoo.Historic.Close("TSLA", "1 May 2019") Which populates the cell with the historic close price of Tesla on 1 May 2019.

    The Add-in works with all versions of Excel.

    An error occurred while saving the comment
    Andrew Sinclair commented  · 

    I’ve built an Excel Add-In (https://www.excelpricefeed.com) which retrieves financial prices/data via simple formulas. It also includes a search function so you can easily find stock codes. It currently connects to Yahoo Finance, I am working on adding other data providers.

    For example to populate a cell with the latest Apple stock price: =EPF.Yahoo.Price(“AAPL”)

    I am currently adding historical data as well as other functionality. The Add-in works with all versions of Excel.

    Andrew Sinclair supported this idea  · 
  2. 6,616 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

    Andrew Sinclair supported this idea  · 

Feedback and Knowledge Base