Analyse U.S. companies financial performance at scale - fast and easy
Find and extract data from thousands of SEC financial reports with one easy to use Excel tool
About
Are you tired of looking for financial statements data? Are you worried that you'll miss on investment opportunities? Do you feel that data extraction takes too much of your time? If you've answered YES to any of the above, we can help! Currently, annual financial reports around the world are on average 204 pages long!
Finding and reading through company financial statements like that for the data you want to analyse can take hours (or even days!). Now, you can dramatically reduce the time and effort involved with our simple and affordable Excel tool. LENSELL® FOR EXCEL is a powerful Excel Add-in with inbuilt functions that lets you query the latest financial reports from thousands of U.S. companies as soon as they’re submitted to SEC.
Once installed, you can pull this data directly into your Excel spreadsheet and model it exactly how you want with the click of a button. The add-in also has several built in ratios to help you speed up your work.
So, what's on offer?
Detailed Financial Reports
Data from over 9000 US companies reporting to SEC including FPI (foreign private issuers)
Latest Reports
Latest and historical reports for more than 10 years
Detailed Financial Reports
ALL 10-K (annual reports), 10-Q (quarterly reports) and 20-F (annual reports FPI)
4 Million Data Points
Over 4 million data points available for your fundamentals analysis
Beat the competition with
timely insights
Take advantage of the LENSELL® FOR
EXCEL add-in
Easy to use functions
Standardised and as-reported data so you can speed up data access
Pre-calculated financial ratios, so you can save time and focus on insights
Powerful generic function so you can get detailed data for your analysis
Our Pricing
Frequently Asked Questions
After we receive your request we will send you the addin file, your account details and instructions how to install it and retrieve financial data. With the free version you can query data for up to 5 U.S. companies, with a total of up to 5000 data points during the 30 days period. After 30 days, or if you need more querying power you’ll need to upgrade to one of the paid versions. We offer the Basic, Plus and Pro options.
You’ll receive an email with the add-in and instructions how to install it and retrieve financial data. The limits specific to your plan will be specified in the email. Once you hit those limits you are welcome to wait for a new subscription cycle or to upgrade your plan.
For all paid plans, you start on a free 14 day trial of the plan. You get all functionality applicable for your plan from the beginning, so you have two weeks to decide if the plan suits you.
You will receive the Excel Add-in, account details and the installation guide in less than 24 hours.
A data point is each piece of financial information that you request and extract into your Excel spreadsheet using the functions built in the add-in. For example, "Revenue", "Net Profit","Gross Profit" etc.Each request for a data point gets counted towards your plan limit, even if you requested the same data point at a previous time during the same month. That is because we do not keep track of which data points you query.
Note that every time when you save your your Excel spreadsheet, all functions that are in that spreadsheet will be refreshed (i.e. the latest values for the data points will be requested again from the database) and they will be counted towards your plan limit. We suggest that you keep a separate spreadsheet where you perform the data querying and another file where you have your final financial model.
All plans come with a number of functions that help you retrieve the data points in a consistent manner, no matter how they were reported to SEC by the company. For example, GetRevenue will return the total amount of revenue reported by the company, for the financial year and financial period selected, no matter if the company reported that value as "Revenue", "Revenues", "Sales", "Sales Volume" etc.
A list of available functions and ratios is included in the 'Installation and Use Guide' that will be emailed to you with the add-in.
The paid plans (Basic, Plus and Pro) come with 18 financial ratios that help you fast track your analysis. For example GrossProfitMargin, ReturnOnAssets, ReturnOnEquity, Cash Ratio and many others.
A list of available functions and ratios is included in the 'Installation and Use Guide' that will be emailed to you with the add-in.
The paid plans include a generic function that you can use to get any of the millions of financial statements line items reported by companies to SEC in US during the past 10 years. The data points will be returned as reported by the company, without any standardisation of the output.
This is extremely powerful when you want to do more complex or more detailed financial analysis where you need very specific data points. However, it requires you to know the name of the fields that you want to extract, from the GAAP taxonomy. We can provide a list of the 250 most often queried U.S. financial statements fields. Please contact us and enquire.
At this stage the add-in is only available for Windows installations, and it works with any Excel version from 2007 onwards.
All plans, including the free Trial one, come with free technical support.
Troubleshooting advice is provided in the documentation and we are always here to help. Email us with a description of the problem (include screenshots if you have) and we will get back to you in 2 business days.
Plus and Pro plans have priority technical support (1 business day).
Certainly, you can cancel your subscription anytime by contacting us at info@xbrl-advance.com.
If you have not used any of the plan data points allowance during the month, the full fees paid in advance will be refunded. If you have used some of the data points, the refund will be prorated.
Get in touch today
LENSELL® is brought to you by XBRL experts
We are specialists in digital business reporting and data analytics for financial services. We enable companies, investors, analysts, auditors, academics and many others share, discover and strategise with financial and non-financial corporate performance data and insights.We are members of XBRL US and XBRL International, and a proud supporter of TCFD.
