- Prepare for earnings by previewing estimates in our new dynamic Earnings Preview template
- Ability to go offline
- Choose your brokers: create a custom consensus
- Pull additional company info
The new Earnings Preview templates lets you quickly scan estimates before a company reports earnings. Visible Alpha now provides you with a dynamic, updating worksheet that will always reflect estimates from the company’s upcoming quarter and forecast year. This means that you no longer have to create an earnings preview sheet from scratch, and constantly update the time periods every quarter.
The Revision Date field also allows you to check where the estimates were 30 days before today. You can change this to a custom date, and measure revisions both on a short term and a long term basis.
Download the template by selecting ‘Download Templates’ button and ‘Earnings Preview’.
As always, the Download Worksheet functionality is still there for you to use. You can now access it by selecting ‘Download template’ and ‘Financial Statement.’
When you are not working with the Visible Alpha add-in, you can now pause the application by selecting the ‘Go Offline’ button. This will be especially useful when managing large sheets with substantial amounts of data. By being able to go offline, users will notice a significant improvement in the speed and performance of the add-in. Resume working with the add-in by simply clicking ‘Go Online.’
Along with pulling the latest consensus and broker data with the add-in, you can now also create your own custom consensus. Click on the ‘Additional Tools’ button and choose ‘Custom Consensus’.
In the dialog box, enter the ticker and choose the brokers you want to include in your custom consensus.
Once saved, you can pull data based on your custom consensus through your VAdata formulas.
For example, you would use the following formula to pull custom consensus of Azure Revenue for Microsoft:
=VAData("MSFT","3QFY-2019","Revenue - Azure","Custom","NMV")
Under ‘Additional Tools,’ leverage ‘Company Info’ to extract more information on a company. New information includes: the last reported period, whether a period is an actual or an estimate, and earnings date for a company.
The following functions are available:
As a reminder, you can also add these formulas manually with the following options:
- =vadetail("LastReportedPeriod","AAPL") will return the latest reported period for AAPL
- =vadetail("ActualorEstimate", "<ticker>", "<consensus/broker>", "<period>") will return whether a period is an actual or an estimate
- =vadetail("lastupdate", "<ticker>", "<source>") will return the last date the consensus or a broker model was updated