Back
Topic:

Quants

Stay up to date with the latest news for quantitative analysts, learn about Intrinio’s analytical tools, and hear from other financial analysts.

May 30, 2018
Calculate Altman Z Score Automatically in Excel in Under 5 Minutes with 3 Simple Steps
Courtney Kiely

The Altman Z Score calculation is based on five financial ratios and can take some time to produce manually. In this short process, we’ll show you how to pull the Altman Z Score for US publicly traded companies without doing manual calculations through the Intrinio Excel Add-In.

Read More
May 29, 2018
Calculate NOPAT Automatically in Excel in Under 5 Minutes with 3 Simple Steps
Courtney Kiely

Stop spending time manually calculating Net Operating Profit After Tax (NOPAT) and start saving time by automatically calculating this in Excel in under two minutes. In this short process, we’ll show you how to pull NOPAT for US publicly traded companies through the Intrinio Excel Add-In.

Read More
May 29, 2018
Calculate P/E Ratio Automatically in Excel in Under 5 Minutes with 3 Simple Steps
Courtney Kiely

If you’re sick of doing Price to Earnings Ratio (P/E Ratio) calculations by hand, check out this Excel hack. In this short process, we’ll show you how to pull the P/E Ratio for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

Read More
December 6, 2017
Refreshing Data in Excel for Mac
Andrew Carpenter

Boy, Excel for Mac can be a real pain in the butt sometimes. In particular, refreshing data within a Mac Excel spreadsheet is near impossible. Many of our users face this issue. Thankfully, we’ve got two simple solutions for you, and this blog walks you through each one step by step.

Read More
August 4, 2017
Corporate Events Dates in the Intrinio Financial Data Marketplace
Andrew Carpenter

Pair Wall Street Horizon’s exceptionally accurate corporate events calendar with Intrinio’s extraordinarily intuitive access methods. This article explains what data is included in the feed, how to subscribe to that data, and how to access that data in Excel, CSV, or API formats.

Read More
April 25, 2017
Press Release API from NASDAQ
Andrew Carpenter

Intrinio is excited to announce the addition of the NASDAQ Global Press Releases data feed. This data feed will provide Intrinio users with API access to the latest breaking news for companies from around the world. This article explains how to get access and provides sample API calls.

Read More
December 27, 2016
Trouble Shooting the Excel Add-In On PC
Andrew Carpenter

Intrinio's Excel add-in is a valuable tool that helps analysts quickly pull data and make calculations without the hassle of manual data entry. This article provides a step-by-step process for getting the Intrinio Excel add-in installed if you are experiencing problems on a PC.

Read More
December 27, 2016
Trouble Shooting the Excel Add-In on Mac
Andrew Carpenter

Intrinio's Excel add-in is a valuable tool that helps analysts quickly pull data and make calculations without the hassle of manual data entry. This article provides a step-by-step process for getting the Intrinio Excel add-in installed if you are experiencing problems on a Mac.

Read More
October 11, 2016
Historical Financial Data in R for Stocks
Andrew Carpenter

Learn custom functions that will allow you to pull historical data into R very efficiently. I plan to build quant models, predicting historical prices based on historical metrics for a stock, and use a subset of the historical data to back test my models. This blog explains how to get the data.

Read More
September 26, 2016
Intrinio Financial Data in R and RStudio
Andrew Carpenter

Data analysts everywhere know that most of their time is spent gathering, cleaning, and formatting data. The actual analysis is easy once the data is structured how you need it. This blog shows how Intrinio makes analysis easier by using the Intrinio API to pull financial data into R.

Read More