FirasaAI Documentation
FirasaAI Data Groups
Stock Information Data
Data on over 500 companies in MENA
Real Estate
Daily and historical sale and rental prices for residential units in UAE
Fundemental Data
Income Statements and Balance Sheet for over 200 Companies in MENA
Macroeconomic Data
Macroeconomic data for many countries in MENA
Installation
-
Download Excel Add-ins from here
-
Open Excel From Files, go to options
-
From Files, go to options, add-ins
-
In add-ins, go to Manage: Excel Add-ins and press GO
-
Go to Browse, and select Ferasa-V0.1 and press Ok
List of Functions
=GetFerasa(market code)
| Item | Description |
|---|---|
| market code |
"sa" for Saudi market (Tadawul), "ae" for UAE markets, "eg" for Egypt market, "qa" for Qatar, "kw" for Kuwait, "om" for Oman, "jo" for Jordan. Example: =GetFerasa("sa") Output: function will print out end of day (EOD) stock market data for Saudi (Tadawul) |
=GetFerasa(market code, date)
| Item | Description |
|---|---|
| market code |
"sa" for Saudi market (Tadawul), "ae" for UAE markets, "eg" for Egypt market, "qa" for Qatar, "kw" for Kuwait, "om" for Oman, "jo" for Jordan. |
| date |
date in YYYY-MM-DD format Example: =GetFerasa("sa","2019-11-29") Output: function will print out end of day (EOD) for specific date for stock market data for Saudi (Tadawul) |
=GetFerasaStockStats(ticker)
| Item | Description |
|---|---|
| ticker |
Required: ticker for the company on the exchange Example: =GetFerasaStockInfo("3030") Output: function will print out end of day (EOD) stock info for Saudi Cement |
| Company Name |
Optional: Company name |
| Close Price |
Optional: Close Price |
| Price Change % |
Optional: Daily change in price |
| P/E Ratio |
Optional: Price to Earnings ratio |
| P/B Ratio |
Optional: Price to Book ratio |
| Book Value(BVPS) |
Optional: Book value per share |
=GetFerasaStockInfo(ticker)
| Item | Description |
|---|---|
| ticker |
Required: ticker for the company on the exchange Example: =GetFerasaStockInfo("3030") Output: function will print out end of day (EOD) stock info for Saudi Cement |
| Description |
Optional: Company description |
| Shareholders |
Optional: Major shareholders for the company |