Feedback by UserVoice

rros

My feedback

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

    We’ll send you updates on this idea

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

    rros commented  · 

    One more time. James and Team Excel, thank you for letting us have this tool.

    Some feedback. All works well and data can be refreshed manually just fine. Preferred shares issues aside, I was wondering if the team could work on allowing users to define their own variables/fields.

    It will impractical to add any more fields in the drop down. And there are so, so many variables that each individual user may chose from that perhaps the best course of action would be to create a standard macro that we could play with.

    Example, what if I want 2017 data? or data that is weekly, monthly or quarterly? What if I want ratios such as EV/ebitda, debt/ebitda, short term debt, long term debt, acid ratios, short interest, fully diluted shares? Juts too many different ones all subject to too many variables (time periods).

    Thank you again for having listened to our plight.

    rros commented  · 

    Yes, thank you for making this tool available.
    Preferred shares are an issue: fnmas, mechel (mtl.pr), etc.

  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    rros commented  · 

    Same issue with other preferred shares: fnmas, fmckj, mtl.pr (mechel preferred shares), not retrieving the data.

Feedback and Knowledge Base