Excel Forum (2024)

Excel Forum (1)Excel Forum (2)

Import stock quotes in Excel 2016

Excel Forum (3)

nv groups


New Member

Members

Excel Forum (4)

Forum Posts: 1

Member Since:
February 21, 2021

Excel Forum (5)Offline

1

February 21, 2021 - 11:28 pm

Excel Forum (6)Excel Forum (7)

I am using Excel 2016. Pl help me to get stock quotes real-time or closing prices for the companies I track.

I dont have access to Excel 365.

Example: for AAPL, I want to get the stock price in the document. thanks

Excel Forum (8)

Mynda Treacy

Admin

Excel Forum (9)

Forum Posts: 4703

Member Since:
July 16, 2010

Excel Forum (10)Offline

2

February 22, 2021 - 10:55 pm

Excel Forum (11)Excel Forum (12)

Welcome to our forum! Without 365 you'd need to scrape the price from a web page. You can use Power Query to do this as explained here.

Mynda

Excel Forum (13)

Anders Sehlstedt

Eskilstuna, Sweden


VIP

Members

Excel Forum (14)
Trusted Members

Excel Forum (15)

Forum Posts: 900

Member Since:
December 7, 2016

Excel Forum (16)Offline

3

February 23, 2021 - 9:28 am

Excel Forum (17)Excel Forum (18)

Hello,

If you have a Microsoft account you can use the stock data types in Excel online.

Br,
Anders

Excel Forum (19)

Mynda Treacy

Admin

Excel Forum (20)

Forum Posts: 4703

Member Since:
July 16, 2010

Excel Forum (21)Offline

4

February 23, 2021 - 10:11 am

Excel Forum (22)Excel Forum (23)

I'm pretty sure you need a 365 licence to use the stock data types in Excel Online.

Excel Forum (24)

Anders Sehlstedt

Eskilstuna, Sweden


VIP

Members

Excel Forum (25)
Trusted Members

Excel Forum (26)

Forum Posts: 900

Member Since:
December 7, 2016

Excel Forum (27)Offline

5

February 23, 2021 - 4:38 pm

Excel Forum (28)Excel Forum (29)

Yep, seems to be so. Below quote is from the support site.
https://support.microsoft.com/.....a89e210877

Note:The Stocks and Geography data types are only available to Worldwide Multi-Tenant clients (standard Microsoft 365 accounts).

Excel Forum (2024)

FAQs

What is the best Excel forum? ›

Reddit Forum

There are over 50,000 members in this active community about Excel. You can post any type of questions and you'll get answers quickly. However it's more than just Q&A, people also share interesting news and useful tips.

Is there ChatGPT for Excel? ›

Boost your productivity with ChatGPT for Excel - the ultimate tool for Microsoft Excel ™ users! With our AI-powered add-in, you can automate tasks, gain valuable insights, and save time and efforts.

How good are you at Excel interview questions? ›

Excel technical interview questions
  • Can you describe some common functions in Excel? ...
  • What's the purpose of protecting a workbook in Excel? ...
  • What is What-If Analysis in Excel? ...
  • Describe a recent project you completed using Excel. ...
  • Tell me about a time when you used Excel alongside other tools and software.
Nov 29, 2023

Why does Excel say there isn't enough memory to complete this action? ›

The causes of Excel Not Enough Memory error include: 1. Trying to Copy Formulas over A Large Area: If your Excel file is large or contains many features, your memory resources may just be running low.

Is Excel being phased out? ›

The takeaway? Excel isn't obsolete; it's evolving.

Is there a better program than Excel? ›

Apache OpenOffice Calc is one of the most popular free alternatives to Excel and is used on over 100 million computers worldwide. Open Office Calc claims to work as a strong data analysis tool for number crunchers.

Can ChatGPT summarize Excel data? ›

In conclusion, ChatGPT is a powerful tool that can help you make better decisions with your pivot tables in Excel. With it, you can quickly summarize customer feedback data, analyze sales data, and track product usage trends — all within Excel.

Is there a free AI for Excel? ›

AI Office Bot – Free AI Tool for Excel

It creates and provides explanations for formulas in Airtable, Google Sheets, and Excel. This tool not only boosts productivity and saves time but also supports 12 different applications. Users can input questions and get solutions in just seconds.

How do I say I'm good at Excel? ›

To show your Excel skills, here are the steps:
  1. Start by saying how long you've used the software and any certifications or courses.
  2. Let people know what advanced features and functions you can do, like making complex formulas, pivot tables, or macros.
  3. Show your data analysis skills. ...
  4. Tell them about automation.

How to crack Excel interview questions? ›

Beginner Level Excel Interview Questions
  1. What is a cell address in Excel? ...
  2. What do you mean by Relative cell referencing and Absolute cell referencing in MS Excel? ...
  3. How do you freeze panes in Excel? ...
  4. How can you restrict someone from copying a cell from your worksheet? ...
  5. How is a Formula different from a Function in Excel?
Apr 15, 2024

Does Excel take a lot of memory? ›

If Excel works normally, it consumes 150-500MB of RAM.

What is the memory limit for Excel? ›

Working with large Excel files can use the memory available to the 32-bit Excel application. In any 32-bit application there is a 2-GB limitation. If your processes need to use more than 2 GB's, then you need to carefully consider moving to Microsoft Excel 64-bit version.

How do I get more memory for Excel? ›

Increase Virtual Memory: If you're running out of physical RAM, increasing your system's virtual memory (pagefile) settings can help alleviate memory constraints. Use 64-Bit Excel: You're already using the 64-bit version of Excel, which allows for larger memory usage compared to the 32-bit version.

What is the best site to learn Excel? ›

The best Excel online courses of 2024 in full:
  1. Coursera. Best Excel course for business statistics. Our expert review: ...
  2. LinkedIn Learning. Best Excel course for getting started. Our expert review: ...
  3. edX. Best Excel course for data analysis. ...
  4. Udemy. Best Excel course for advanced users. ...
  5. SkillShare. Best Excel course for busy people.
Feb 22, 2024

Which Excel version is best? ›

Excel is better with Microsoft 365.

Which is the best Excel freelance sites? ›

Guru.com is the leading online space for Microsoft Excel freelancers to find work posted by employers, manage projects and get paid. Simply create your profile and define the services you want to offer for hire.

Top Articles
Latest Posts
Article information

Author: Margart Wisoky

Last Updated:

Views: 5888

Rating: 4.8 / 5 (58 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Margart Wisoky

Birthday: 1993-05-13

Address: 2113 Abernathy Knoll, New Tamerafurt, CT 66893-2169

Phone: +25815234346805

Job: Central Developer

Hobby: Machining, Pottery, Rafting, Cosplaying, Jogging, Taekwondo, Scouting

Introduction: My name is Margart Wisoky, I am a gorgeous, shiny, successful, beautiful, adventurous, excited, pleasant person who loves writing and wants to share my knowledge and understanding with you.