There are two ways to pull stock quotes into a readable and analyzable format. We've documented steps on how that can be done through Microsoft Excel or Google Sheets. There are major pros and cons with using either. For example, with Excel you don't need to be connected to an internet browser, but the functionality is limited and bulky. The blue bars are an eye sore. In Google Sheets, you'll need to open up a browser. But, at least it is nice and clean.
MarketXLS. Is is a software that is directly downloadable instantly over the web. It pulls quotes into your Excel sheet using formulas that pull real-time quotes seamlessly.
One of the most useful and used formula is the "=ask("TICKER")". Simply type in =ask("WFM") and it will pull in the ask price instantly.
How do you screen for stocks or find stocks to buy?
MarketXLS allows you to screen stocks based on cash flow ratios, balance sheet items, profitability, gross margin, and even more things including return by period.
Note that the above is a real review of the product paid for by our sponsored partner.