Skip to main content

​
What is FQL?

FQL (Finscreener Query Language) is your key to unlocking powerful data insights. It lets you filter companies and GST records with simple, precise queries. Think of queries as conversations with your data. You ask questions, and the system finds answers.

​
Query Anatomy

Every FQL query follows a simple pattern: 
Field Operator Value
Example: 
City == 'Mumbai'
ComponentDescriptionExample
FieldWhat you want to filter byCity, paidUpCapital
OperatorHow to compare==, >, CONTAINS
ValueWhat you’re looking for'Mumbai', 10000000

​
Quick Start Examples

City == 'Mumbai'
Simple location-based filtering.
NICDesc CONTAINS 'software' AND paidUpCapital > 10000000
Combining text search with numerical filtering.
(State IN ['Maharashtra', 'Karnataka']) AND ((classOfCompany == 'Public' AND Listed == 'Listed') OR paidUpCapital > 50000000)
Complex logic with grouping and multiple conditions.

​
Key Concepts

​
Case Sensitivity

Field names are CASE-SENSITIVE!
  • Company fields: City, State, NICCode (capitalized)
  • GST fields: state (lowercase!)

​
String Values

Always wrap string values in single quotes: 
City == 'Mumbai'  ✓
City == Mumbai    ✗

​
Numeric Values

Numbers don’t need quotes: 
paidUpCapital > 10000000  ✓

​
Combining Conditions

OperatorDescriptionExample
ANDBoth conditions must be trueCity == 'Mumbai' AND paidUpCapital > 1000000
OREither condition can be trueCity == 'Mumbai' OR City == 'Delhi'

​
Grouping with Parentheses

Use parentheses to control evaluation order: 
(companyType == 'Public' OR companyType == 'Private') AND City == 'Mumbai'

​
Data Statistics

5M+

Companies

12M+

GST Records

100+

Filterable Fields

​
Next Steps

Operators

Learn all available FQL operators.

Company Fields

Explore company-specific fields.

GST Fields

Explore GST-specific fields.

Examples

Real-world query examples.