RIQ Add-In for Excel
Overview
Get direct access to global Shariah compliance data right inside Excel. Built for financial professionals, this tool simplifies screening, zakat calculations, and purification workflows.
To install the Excel Add-In, follow these steps:
- Open Microsoft Excel
- Click on the Add-ins button in the top ribbon
- Search for RaqabaIQ in the add-in store
- Click Add to install
Functions
| Function | Description | Required | Sample |
|---|---|---|---|
RIQ.Ticker() | Retrieves data by stock ticker | Yes | =RIQ.Ticker("AAPL", "Result", "Zakatpershare") |
RIQ.ISIN() | Retrieves data by ISIN | Yes | =RIQ.ISIN("US0378331005", "Result") |
Field Glossary
| Field Name | Description | Value Type | Applies To |
|---|---|---|---|
| Result | Shariah compliance result | Text | Ticker / ISIN |
| NoofStandards | Number of standards passed | Number | Ticker / ISIN |
| AAOIFI | AAOIFI compliance verdict | Text | Ticker / ISIN |
| SP, DJIM, FTSE, MSCI | Other standard compliance verdicts | Text | Ticker / ISIN |
| TotalImpure | Impure income percentage | Percent | Ticker / ISIN |
| Purification | Amount to purify per share | Currency | Ticker / ISIN |
| Zakatpershare | Zakat amount per share | Currency | Ticker / ISIN |
Examples
Get compliance result for Tesla
=RIQ.Ticker("TSLA", "Result")
➝ Returns: "Compliant"
Get AAOIFI compliance + zakat
=RIQ.Ticker("AAPL", "AAOIFI", "Zakatpershare")
➝ Returns: "Compliant", 0.121
FAQs
Does it work with both tickers and ISINs?
Yes. Use RIQ.Ticker() or RIQ.ISIN() based on your input type.
How often is the data updated?
Compliance screening and updates are done quarterly.
Support
If you need help with onboarding or integration for your team, contact us at:
- Email: support@raqabaiq.com