This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Google has a GoogleFinance function. Does Microsoft have or plan to have anything like this in Excel?
=GOOGLEFINANCE("APPL", "price")
With stocks here are just some examples that you can get.
"price" - Realtime price quote, delayed by up to 20 minutes.
"priceopen" - The price as of market open.
"high" - The current day's high price.
"low" - The current day's low price.
"volume" - The current day's trading volume.
"marketcap" - The market capitalization of the stock.
"tradetime" - The time of the last trade.
"datadelay" - How far delayed the realtime data is.
"volumeavg" - The average daily trading volume.
"pe" - The price/earnings ratio.
"eps" - The earnings per share.
"high52" - The 52-week high price.
"low52" - The 52-week low price.
"change" - The price change since the previous trading day's close.
"beta" - The beta value.
"changepct" - The percentage change in price since the previous trading day's close.
"closeyest" - The previous day's closing price.
"shares" - The number of outstanding shares.
"currency" - The currency in which the security is priced.
attribute is one of the following for historical data:
"open" - The opening price for the specified date(s).
"close" - The closing price for the specified date(s).
"high" - The high price for the specified date(s).
"low" - The low price for the specified date(s).
"volume" - The volume for the specified date(s).
"all" - All of the above.
attribute is one of the following for mutual fund data:
"closeyest" - The previous day's closing price.
"date" - The date at which the net asset value was reported.
"returnytd" - The year-to-date return.
"netassets" - The net assets.
"change" - The change in the most recently reported net asset value and the one immediately prior.
"changepct" - The percentage change int he net asset value.
"yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number.
"returnday" - One-day total return.
"return1" - One-week total return.
"return4" - Four-week total return.
"return13" - Thirteen-week total return.
"return52" - Fifty-two-week (annual) total return.
"return156" - 156-week (3-year) total return.
"return260" - 260-week (5-year) total return.
"incomedividend" - The amount of the most recent cash distribution.
"incomedividenddate" - The date of the most recent cash distribution.
"capitalgain" - The amount of the most recent capital gain distribution.
"morningstarrating" - The Morningstar "star" rating.
"expenseratio" - The fund's expense ratio.
A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Ron,
Based on our investigation, a similar Microsoft function isn’t available in Excel 2013. Since our forum mainly focuses on Office 365 for Business online services, to further look into the issue I suggest you post a new thread on our TechNet forum for expert help. Meanwhile, the following thread discussing this is for your reference:
Thank you for your understanding.
Cliff