Find and extract data from thousands of SEC financial reports with one easy to use Excel tool
Data from over 9000 US companies reporting to SEC including FPI (foreign private issuers)
Latest and historical reports for more than 10 years
ALL 10-K (annual reports), 10-Q (quarterly reports) and 20-F (annual reports FPI)
Over 4 million data points available for your fundamentals analysis
Take advantage of the LENSELL® FOR
EXCEL add-in
Easy to use functions
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.