Search - Filter.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filter\n",
    "One of the most powerful parameters when defining a search is the ability to filter the results.  While a Query is more of an unstructured approach to search for text within documents, a Filter provides a well-defined structured approach when we know which properties we want to restrict our matching documents.\n",
    "\n",
    "The following examples will be using some of the popular properties as outlined within the \"Properties & Metadata\" notebook.  In addition, the selection of these properties was determined based on the discovery techniques used such as metadata and debugging."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<refinitiv.dataplatform.core.session.desktop_session.DesktopSession at 0x504a978>"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import refinitiv.dataplatform as rdp\n",
    "import pandas as pd\n",
    "import datetime as dt\n",
    "import dateutil.relativedelta\n",
    "\n",
    "rdp.open_desktop_session('Your API Key here')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1.0.0a7.post1'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_colwidth', 140)\n",
    "rdp.__version__"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Query vs Filter\n",
    "As you become more familiar with Search, you will realize there are a number of different paths you can take to arrive at the same destination."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>PermID</th>\n",
       "      <th>SEDOL</th>\n",
       "      <th>CUSIP</th>\n",
       "      <th>RIC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>US046353AQ14</td>\n",
       "      <td>46645702869</td>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>046353AQ1</td>\n",
       "      <td>046353AQ1=</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                            DocumentTitle  \\\n",
       "0  AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "\n",
       "           ISIN       PermID    SEDOL      CUSIP         RIC  \n",
       "0  US046353AQ14  46645702869  BF4SNM7  046353AQ1  046353AQ1=  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Retrieve the document(s) for a specific ISIN using a Query.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.Instruments,\n",
    "    query = 'US046353AQ14',\n",
    "    select = 'DocumentTitle, RIC, ISIN, CUSIP, SEDOL, PermID'\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>PermID</th>\n",
       "      <th>SEDOL</th>\n",
       "      <th>CUSIP</th>\n",
       "      <th>RIC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>US046353AQ14</td>\n",
       "      <td>46645702869</td>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>046353AQ1</td>\n",
       "      <td>046353AQ1=</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                            DocumentTitle  \\\n",
       "0  AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "\n",
       "           ISIN       PermID    SEDOL      CUSIP         RIC  \n",
       "0  US046353AQ14  46645702869  BF4SNM7  046353AQ1  046353AQ1=  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Retrieve the document(s) for the same ISIN using a Filter\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.Instruments,\n",
    "    filter = \"ISIN eq 'US046353AQ14'\",\n",
    "    select = 'DocumentTitle, RIC, ISIN, CUSIP, SEDOL, PermID'\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>PermID</th>\n",
       "      <th>SEDOL</th>\n",
       "      <th>CUSIP</th>\n",
       "      <th>RIC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022</td>\n",
       "      <td>US046353AQ14</td>\n",
       "      <td>46645702869</td>\n",
       "      <td>BF4SNM7</td>\n",
       "      <td>046353AQ1</td>\n",
       "      <td>046353AQ1=</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                            DocumentTitle  \\\n",
       "0  AstraZeneca PLC, Plain Vanilla Fixed Coupon Bond, TRACE Eligible AZN 2.375 12-Jun-2022   \n",
       "\n",
       "           ISIN       PermID    SEDOL      CUSIP         RIC  \n",
       "0  US046353AQ14  46645702869  BF4SNM7  046353AQ1  046353AQ1=  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# If you are provided a code but are not sure if the code is an ISIN, SEDOL, CUSIP etc, \n",
    "# try using the 'CodeResolutionBase' property.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.Instruments,\n",
    "    filter = \"CodeResolutionBase eq '046353AQ1'\",   # I'm using the CUSIP for the same instrument\n",
    "    select = 'DocumentTitle, RIC, ISIN, CUSIP, SEDOL, PermID'\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Apple Equities"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>AssetType</th>\n",
       "      <th>CompositeDescriptiveName</th>\n",
       "      <th>RIC</th>\n",
       "      <th>ExchangeName</th>\n",
       "      <th>ExchangeCode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPL.O</td>\n",
       "      <td>NASDAQ Global Select Consolidated</td>\n",
       "      <td>NSQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD APPLE INC</td>\n",
       "      <td>AAPLEUR.xbo</td>\n",
       "      <td>MiFID Composite Cross Market Service</td>\n",
       "      <td>XBO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPL.OQ</td>\n",
       "      <td>NASDAQ Stock Exchange Global Select Market</td>\n",
       "      <td>NSM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPL.DG</td>\n",
       "      <td>Cboe EDGX Exchange - Nasdaq Global Select Market</td>\n",
       "      <td>GCD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD APPLE INC</td>\n",
       "      <td>AAPL.Z</td>\n",
       "      <td>Cboe BZX Exchange - Nasdaq Global Select Market</td>\n",
       "      <td>GCZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPL.B</td>\n",
       "      <td>Boston SE when trading NASDAQ Global Select Market</td>\n",
       "      <td>GSB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPLE.MI</td>\n",
       "      <td>Milan Stock Exchange</td>\n",
       "      <td>MIL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD APPLE INC</td>\n",
       "      <td>AAPL.ZY</td>\n",
       "      <td>Cboe BYX Exchange - Nasdaq Global Select Market</td>\n",
       "      <td>GCY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD APPLE INC</td>\n",
       "      <td>AAPL.PH</td>\n",
       "      <td>NASDAQ OMX PHLX Global Select Market</td>\n",
       "      <td>GSX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[EQUITY]</td>\n",
       "      <td>Apple Ord Shs APPLE ORD</td>\n",
       "      <td>AAPL.DY</td>\n",
       "      <td>Cboe EDGA Exchange - Nasdaq Global Select Market</td>\n",
       "      <td>GDA</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  AssetType           CompositeDescriptiveName          RIC  \\\n",
       "0  [EQUITY]            Apple Ord Shs APPLE ORD       AAPL.O   \n",
       "1  [EQUITY]  Apple Ord Shs APPLE ORD APPLE INC  AAPLEUR.xbo   \n",
       "2  [EQUITY]            Apple Ord Shs APPLE ORD      AAPL.OQ   \n",
       "3  [EQUITY]            Apple Ord Shs APPLE ORD      AAPL.DG   \n",
       "4  [EQUITY]  Apple Ord Shs APPLE ORD APPLE INC       AAPL.Z   \n",
       "5  [EQUITY]            Apple Ord Shs APPLE ORD       AAPL.B   \n",
       "6  [EQUITY]            Apple Ord Shs APPLE ORD     AAPLE.MI   \n",
       "7  [EQUITY]  Apple Ord Shs APPLE ORD APPLE INC      AAPL.ZY   \n",
       "8  [EQUITY]  Apple Ord Shs APPLE ORD APPLE INC      AAPL.PH   \n",
       "9  [EQUITY]            Apple Ord Shs APPLE ORD      AAPL.DY   \n",
       "\n",
       "                                         ExchangeName ExchangeCode  \n",
       "0                   NASDAQ Global Select Consolidated          NSQ  \n",
       "1                MiFID Composite Cross Market Service          XBO  \n",
       "2          NASDAQ Stock Exchange Global Select Market          NSM  \n",
       "3    Cboe EDGX Exchange - Nasdaq Global Select Market          GCD  \n",
       "4     Cboe BZX Exchange - Nasdaq Global Select Market          GCZ  \n",
       "5  Boston SE when trading NASDAQ Global Select Market          GSB  \n",
       "6                                Milan Stock Exchange          MIL  \n",
       "7     Cboe BYX Exchange - Nasdaq Global Select Market          GCY  \n",
       "8                NASDAQ OMX PHLX Global Select Market          GSX  \n",
       "9    Cboe EDGA Exchange - Nasdaq Global Select Market          GDA  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Within the view (EquityQuotes), select all documents where the term 'AAPL' is within the ticker symbol.  For each, \n",
    "# ensure the type of asset is an 'equity' and that each asset is in an active state.  I chose to filter out the \n",
    "# AssetState of 'DC' (De-activated) as my criteria.\n",
    "#\n",
    "# Note: An alternative to \"AssetType eq 'equity'\" could be to use: \"RCSAssetCategoryLeaf eq 'Ordinary Share'\"\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.EquityQuotes,\n",
    "    filter = \"AssetType eq 'equity' and AssetState ne 'DC' and TickerSymbol eq 'AAPL'\",\n",
    "    select = \"RIC, CompositeDescriptiveName, ExchangeCode, ExchangeName, AssetType\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Vessels\n",
    "List all Very Large Gas Containers (VLGC) that are in service within the last week."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Build date range expression for the location of the vessel for the last 7 days\n",
    "date_7_days_ago = dt.datetime.today() - dateutil.relativedelta.relativedelta(days=7)\n",
    "date_range = f'LocationTimestamp ge {date_7_days_ago.strftime(\"%Y-%m-%d\")} and \\\n",
    "               LocationTimestamp lt {dt.datetime.today().strftime(\"%Y-%m-%d\")}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Longitude</th>\n",
       "      <th>LocationTimestamp</th>\n",
       "      <th>DTSource</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>SynonymSearchAll</th>\n",
       "      <th>RIC</th>\n",
       "      <th>IMO</th>\n",
       "      <th>LocationDestination</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>33.153282</td>\n",
       "      <td>2020-12-09T07:47:24.000Z</td>\n",
       "      <td>Red Sea|Suez Canal Tanker Zone|Egypt</td>\n",
       "      <td>28.742132</td>\n",
       "      <td>Egyptian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309491970</td>\n",
       "      <td>9350288</td>\n",
       "      <td>WADI FEIRAN [Wadi Feiran Oil Terminal]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>113.839073</td>\n",
       "      <td>2020-12-09T21:08:19.000Z</td>\n",
       "      <td>Guangdong|South China Sea|Canton Tanker Zone|China (Mainland)</td>\n",
       "      <td>22.497496</td>\n",
       "      <td>Chinese Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309636854</td>\n",
       "      <td>9719501</td>\n",
       "      <td>CN SHK [Shekou]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>130.100449</td>\n",
       "      <td>2020-12-09T13:59:15.000Z</td>\n",
       "      <td>East China Sea|Japan Tanker Zone</td>\n",
       "      <td>31.010271</td>\n",
       "      <td>Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean</td>\n",
       "      <td>C}KY7309843620</td>\n",
       "      <td>9759185</td>\n",
       "      <td>KR TSN [Daesan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-97.569687</td>\n",
       "      <td>2020-12-08T23:00:18.000Z</td>\n",
       "      <td>Pacific Ocean (Central America)|West Mexico Tanker Zone</td>\n",
       "      <td>14.309810</td>\n",
       "      <td>Mexican Korean Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309844039</td>\n",
       "      <td>9797864</td>\n",
       "      <td>PABLB [Balboa]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>66.395981</td>\n",
       "      <td>2020-12-08T18:31:51.000Z</td>\n",
       "      <td>Arabia Sea</td>\n",
       "      <td>18.539083</td>\n",
       "      <td>Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309451481</td>\n",
       "      <td>8519966</td>\n",
       "      <td>IN DMQ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>72.558334</td>\n",
       "      <td>2020-12-08T03:28:56.000Z</td>\n",
       "      <td>Arabia Sea|West Coast India Tanker Zone</td>\n",
       "      <td>19.107578</td>\n",
       "      <td>Indian Kuwaiti Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KL7309478067</td>\n",
       "      <td>9172636</td>\n",
       "      <td>INBOM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.345000</td>\n",
       "      <td>2020-12-08T06:52:52.000Z</td>\n",
       "      <td>West Med|West Med Tanker Zone</td>\n",
       "      <td>36.145489</td>\n",
       "      <td>Algerian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309478328</td>\n",
       "      <td>9176369</td>\n",
       "      <td>PTSET-&gt;DZAZW [Arzew]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>50.810871</td>\n",
       "      <td>2020-12-08T05:21:55.000Z</td>\n",
       "      <td>Gulf of Oman|Arabian Gulf Tanker Zone</td>\n",
       "      <td>27.123461</td>\n",
       "      <td>Indian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309489467</td>\n",
       "      <td>9320740</td>\n",
       "      <td>IN DAH&gt;SA RTA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>104.460350</td>\n",
       "      <td>2020-12-09T18:01:58.000Z</td>\n",
       "      <td>Java Sea|Singapore Tanker Zone</td>\n",
       "      <td>1.385350</td>\n",
       "      <td>Chinese Liquefied Petroleum Gas Very Large Gas Carrier Qatari</td>\n",
       "      <td>C}KY7309492522</td>\n",
       "      <td>9356892</td>\n",
       "      <td>NINGBO CHINA [Ningbo and Zhoushan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>87.088913</td>\n",
       "      <td>2020-12-09T23:30:18.000Z</td>\n",
       "      <td>Bay of Bengal|Chittagong Tanker Zone</td>\n",
       "      <td>19.090334</td>\n",
       "      <td>Indian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309500853</td>\n",
       "      <td>9454010</td>\n",
       "      <td>FUJAIRAH [Fujairah]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>122.672073</td>\n",
       "      <td>2020-12-08T19:43:12.000Z</td>\n",
       "      <td>East China Sea|Taiwan Tanker Zone</td>\n",
       "      <td>25.413801</td>\n",
       "      <td>Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean</td>\n",
       "      <td>C}KY7309527017</td>\n",
       "      <td>9608300</td>\n",
       "      <td>CN YNT [Yantai]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>74.164673</td>\n",
       "      <td>2020-12-09T00:18:39.000Z</td>\n",
       "      <td>West Indian Ocean|West Coast India Tanker Zone</td>\n",
       "      <td>10.688222</td>\n",
       "      <td>India Indian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309529189</td>\n",
       "      <td>9625152</td>\n",
       "      <td>ORDERS WITH GUARDS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>121.198563</td>\n",
       "      <td>2020-12-09T11:08:34.000Z</td>\n",
       "      <td>North Pacific Ocean (Japan)|Taiwan Tanker Zone</td>\n",
       "      <td>21.995995</td>\n",
       "      <td>Japanese Chinese Liquefied Petroleum Gas Very Large Gas Carrier Thai</td>\n",
       "      <td>C}KY7309586098</td>\n",
       "      <td>9670004</td>\n",
       "      <td>TH MAT [Map Ta Phut]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>55.544899</td>\n",
       "      <td>2020-12-06T18:30:51.000Z</td>\n",
       "      <td>Gulf of Oman|Arabian Gulf Tanker Zone</td>\n",
       "      <td>26.378963</td>\n",
       "      <td>Chinese Korean Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309692815</td>\n",
       "      <td>9702027</td>\n",
       "      <td>AE RUW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>104.397842</td>\n",
       "      <td>2020-12-09T01:06:32.000Z</td>\n",
       "      <td>Java Sea|Singapore Tanker Zone|Singapore Strait Waypoint</td>\n",
       "      <td>1.343237</td>\n",
       "      <td>Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309692816</td>\n",
       "      <td>9702039</td>\n",
       "      <td>SGSIN&gt;CNNSA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>129.422043</td>\n",
       "      <td>2020-12-08T07:55:34.000Z</td>\n",
       "      <td>East Sea / Sea of Japan|Korea Tanker Zone|Korea Strait Waypoint</td>\n",
       "      <td>35.156281</td>\n",
       "      <td>Japanese Korean American US USA Chinese American United States USA Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309693091</td>\n",
       "      <td>9701798</td>\n",
       "      <td>KR ULSAN [Ulsan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>-95.124786</td>\n",
       "      <td>2020-12-09T10:29:24.000Z</td>\n",
       "      <td>Gulf of Mexico|US Gulf Tanker Zone|Texas|United States</td>\n",
       "      <td>29.738237</td>\n",
       "      <td>Mexican American United States USA American US USA Chinese Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KX7309781171</td>\n",
       "      <td>9734692</td>\n",
       "      <td>USHOU [Houston]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>108.178230</td>\n",
       "      <td>2020-12-09T11:21:46.000Z</td>\n",
       "      <td>South China Sea|Canton Tanker Zone</td>\n",
       "      <td>20.574251</td>\n",
       "      <td>Chinese Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KX7309792201</td>\n",
       "      <td>9723681</td>\n",
       "      <td>SG SIN [Singapore]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113.974716</td>\n",
       "      <td>2020-12-09T16:41:58.000Z</td>\n",
       "      <td>Indonesia|East Java|Java Sea|Lawi-Lawi Terminal Tanker Zone</td>\n",
       "      <td>-7.590919</td>\n",
       "      <td>Indonesian American US USA India American United States USA Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KG7309828093</td>\n",
       "      <td>9743722</td>\n",
       "      <td>KALBUT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>79.164330</td>\n",
       "      <td>2020-12-07T10:14:48.000Z</td>\n",
       "      <td>East Indian Ocean|Colombo Tanker Zone</td>\n",
       "      <td>6.156287</td>\n",
       "      <td>India Chinese Liquefied Petroleum Gas Very Large Gas Carrier Qatari</td>\n",
       "      <td>C}KY7309843981</td>\n",
       "      <td>9778480</td>\n",
       "      <td>RASLAFFAN [Ras Laffan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>119.912025</td>\n",
       "      <td>2020-12-09T07:53:20.000Z</td>\n",
       "      <td>Jiangsu|Shanghai Tanker Zone|Yangtze River|China (Mainland)</td>\n",
       "      <td>32.150818</td>\n",
       "      <td>Chinese Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309878959</td>\n",
       "      <td>9847425</td>\n",
       "      <td>CNTAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>52.979465</td>\n",
       "      <td>2020-12-08T14:29:08.000Z</td>\n",
       "      <td>Gulf of Oman|Arabian Gulf Tanker Zone</td>\n",
       "      <td>25.136593</td>\n",
       "      <td>Indian Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309908768</td>\n",
       "      <td>9867102</td>\n",
       "      <td>AE&gt;DAS [Das Island]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>121.206596</td>\n",
       "      <td>2020-12-07T01:09:03.000Z</td>\n",
       "      <td>North Pacific Ocean (Japan)|Taiwan Tanker Zone</td>\n",
       "      <td>21.989367</td>\n",
       "      <td>Japanese Chinese Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309456906</td>\n",
       "      <td>8818219</td>\n",
       "      <td>SINGAPORE [Singapore]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>122.711884</td>\n",
       "      <td>2020-12-08T05:18:07.000Z</td>\n",
       "      <td>East China Sea|Taiwan Tanker Zone</td>\n",
       "      <td>24.691402</td>\n",
       "      <td>Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean</td>\n",
       "      <td>C}KY7309467141</td>\n",
       "      <td>9012886</td>\n",
       "      <td>LONGKOU,CHINA [Longkou]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>117.775940</td>\n",
       "      <td>2020-12-05T20:30:23.000Z</td>\n",
       "      <td>South China Sea|Canton Tanker Zone</td>\n",
       "      <td>23.110270</td>\n",
       "      <td>Chinese Liquefied Petroleum Gas Very Large Gas Carrier Cypriot</td>\n",
       "      <td>C}KY7309468382</td>\n",
       "      <td>9031519</td>\n",
       "      <td>KHOR FAKKAN [Khor Fakkan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>104.536484</td>\n",
       "      <td>2020-12-09T23:52:48.000Z</td>\n",
       "      <td>Java Sea|Singapore Tanker Zone</td>\n",
       "      <td>1.440052</td>\n",
       "      <td>Qatari Chinese Liquefied Petroleum Gas Very Large Gas Carrier nihon</td>\n",
       "      <td>C}KY7309480542</td>\n",
       "      <td>9206396</td>\n",
       "      <td>CN DGG [Dongguan]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>122.816330</td>\n",
       "      <td>2020-12-08T14:19:39.000Z</td>\n",
       "      <td>East China Sea|Taiwan Tanker Zone</td>\n",
       "      <td>24.589951</td>\n",
       "      <td>Chinese Qatari Liquefied Petroleum Gas Very Large Gas Carrier Korean</td>\n",
       "      <td>C}KY7309486846</td>\n",
       "      <td>9290270</td>\n",
       "      <td>PANJIN [Yingkou]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>56.730347</td>\n",
       "      <td>2020-12-05T00:50:22.000Z</td>\n",
       "      <td>Gulf of Oman|Arabian Gulf Tanker Zone</td>\n",
       "      <td>25.152576</td>\n",
       "      <td>Liquefied Petroleum Gas Very Large Gas Carrier</td>\n",
       "      <td>C}KY7309466510</td>\n",
       "      <td>9002491</td>\n",
       "      <td>SOHAR [Sohar]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Longitude         LocationTimestamp  \\\n",
       "0    33.153282  2020-12-09T07:47:24.000Z   \n",
       "1   113.839073  2020-12-09T21:08:19.000Z   \n",
       "2   130.100449  2020-12-09T13:59:15.000Z   \n",
       "3   -97.569687  2020-12-08T23:00:18.000Z   \n",
       "4    66.395981  2020-12-08T18:31:51.000Z   \n",
       "5    72.558334  2020-12-08T03:28:56.000Z   \n",
       "6    -0.345000  2020-12-08T06:52:52.000Z   \n",
       "7    50.810871  2020-12-08T05:21:55.000Z   \n",
       "8   104.460350  2020-12-09T18:01:58.000Z   \n",
       "9    87.088913  2020-12-09T23:30:18.000Z   \n",
       "10  122.672073  2020-12-08T19:43:12.000Z   \n",
       "11   74.164673  2020-12-09T00:18:39.000Z   \n",
       "12  121.198563  2020-12-09T11:08:34.000Z   \n",
       "13   55.544899  2020-12-06T18:30:51.000Z   \n",
       "14  104.397842  2020-12-09T01:06:32.000Z   \n",
       "15  129.422043  2020-12-08T07:55:34.000Z   \n",
       "16  -95.124786  2020-12-09T10:29:24.000Z   \n",
       "17  108.178230  2020-12-09T11:21:46.000Z   \n",
       "18  113.974716  2020-12-09T16:41:58.000Z   \n",
       "19   79.164330  2020-12-07T10:14:48.000Z   \n",
       "20  119.912025  2020-12-09T07:53:20.000Z   \n",
       "21   52.979465  2020-12-08T14:29:08.000Z   \n",
       "22  121.206596  2020-12-07T01:09:03.000Z   \n",
       "23  122.711884  2020-12-08T05:18:07.000Z   \n",
       "24  117.775940  2020-12-05T20:30:23.000Z   \n",
       "25  104.536484  2020-12-09T23:52:48.000Z   \n",
       "26  122.816330  2020-12-08T14:19:39.000Z   \n",
       "27   56.730347  2020-12-05T00:50:22.000Z   \n",
       "\n",
       "                                                           DTSource  \\\n",
       "0                              Red Sea|Suez Canal Tanker Zone|Egypt   \n",
       "1     Guangdong|South China Sea|Canton Tanker Zone|China (Mainland)   \n",
       "2                                  East China Sea|Japan Tanker Zone   \n",
       "3           Pacific Ocean (Central America)|West Mexico Tanker Zone   \n",
       "4                                                        Arabia Sea   \n",
       "5                           Arabia Sea|West Coast India Tanker Zone   \n",
       "6                                     West Med|West Med Tanker Zone   \n",
       "7                             Gulf of Oman|Arabian Gulf Tanker Zone   \n",
       "8                                    Java Sea|Singapore Tanker Zone   \n",
       "9                              Bay of Bengal|Chittagong Tanker Zone   \n",
       "10                                East China Sea|Taiwan Tanker Zone   \n",
       "11                   West Indian Ocean|West Coast India Tanker Zone   \n",
       "12                   North Pacific Ocean (Japan)|Taiwan Tanker Zone   \n",
       "13                            Gulf of Oman|Arabian Gulf Tanker Zone   \n",
       "14         Java Sea|Singapore Tanker Zone|Singapore Strait Waypoint   \n",
       "15  East Sea / Sea of Japan|Korea Tanker Zone|Korea Strait Waypoint   \n",
       "16           Gulf of Mexico|US Gulf Tanker Zone|Texas|United States   \n",
       "17                               South China Sea|Canton Tanker Zone   \n",
       "18      Indonesia|East Java|Java Sea|Lawi-Lawi Terminal Tanker Zone   \n",
       "19                            East Indian Ocean|Colombo Tanker Zone   \n",
       "20      Jiangsu|Shanghai Tanker Zone|Yangtze River|China (Mainland)   \n",
       "21                            Gulf of Oman|Arabian Gulf Tanker Zone   \n",
       "22                   North Pacific Ocean (Japan)|Taiwan Tanker Zone   \n",
       "23                                East China Sea|Taiwan Tanker Zone   \n",
       "24                               South China Sea|Canton Tanker Zone   \n",
       "25                                   Java Sea|Singapore Tanker Zone   \n",
       "26                                East China Sea|Taiwan Tanker Zone   \n",
       "27                            Gulf of Oman|Arabian Gulf Tanker Zone   \n",
       "\n",
       "     Latitude  \\\n",
       "0   28.742132   \n",
       "1   22.497496   \n",
       "2   31.010271   \n",
       "3   14.309810   \n",
       "4   18.539083   \n",
       "5   19.107578   \n",
       "6   36.145489   \n",
       "7   27.123461   \n",
       "8    1.385350   \n",
       "9   19.090334   \n",
       "10  25.413801   \n",
       "11  10.688222   \n",
       "12  21.995995   \n",
       "13  26.378963   \n",
       "14   1.343237   \n",
       "15  35.156281   \n",
       "16  29.738237   \n",
       "17  20.574251   \n",
       "18  -7.590919   \n",
       "19   6.156287   \n",
       "20  32.150818   \n",
       "21  25.136593   \n",
       "22  21.989367   \n",
       "23  24.691402   \n",
       "24  23.110270   \n",
       "25   1.440052   \n",
       "26  24.589951   \n",
       "27  25.152576   \n",
       "\n",
       "                                                                                                     SynonymSearchAll  \\\n",
       "0                                                             Egyptian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "1                                                              Chinese Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "2                                              Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean   \n",
       "3                                                       Mexican Korean Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "4                                                                      Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "5                                                       Indian Kuwaiti Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "6                                                             Algerian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "7                                                               Indian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "8                                                       Chinese Liquefied Petroleum Gas Very Large Gas Carrier Qatari   \n",
       "9                                                               Indian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "10                                             Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean   \n",
       "11                                                        India Indian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "12                                               Japanese Chinese Liquefied Petroleum Gas Very Large Gas Carrier Thai   \n",
       "13                                                      Chinese Korean Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "14                                                                     Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "15  Japanese Korean American US USA Chinese American United States USA Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "16          Mexican American United States USA American US USA Chinese Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "17                                                             Chinese Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "18         Indonesian American US USA India American United States USA Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "19                                                India Chinese Liquefied Petroleum Gas Very Large Gas Carrier Qatari   \n",
       "20                                                             Chinese Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "21                                                              Indian Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "22                                                    Japanese Chinese Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "23                                             Chinese Japanese Liquefied Petroleum Gas Very Large Gas Carrier Korean   \n",
       "24                                                     Chinese Liquefied Petroleum Gas Very Large Gas Carrier Cypriot   \n",
       "25                                                Qatari Chinese Liquefied Petroleum Gas Very Large Gas Carrier nihon   \n",
       "26                                               Chinese Qatari Liquefied Petroleum Gas Very Large Gas Carrier Korean   \n",
       "27                                                                     Liquefied Petroleum Gas Very Large Gas Carrier   \n",
       "\n",
       "               RIC      IMO                     LocationDestination  \n",
       "0   C}KY7309491970  9350288  WADI FEIRAN [Wadi Feiran Oil Terminal]  \n",
       "1   C}KY7309636854  9719501                         CN SHK [Shekou]  \n",
       "2   C}KY7309843620  9759185                         KR TSN [Daesan]  \n",
       "3   C}KY7309844039  9797864                          PABLB [Balboa]  \n",
       "4   C}KY7309451481  8519966                                  IN DMQ  \n",
       "5   C}KL7309478067  9172636                                   INBOM  \n",
       "6   C}KY7309478328  9176369                    PTSET->DZAZW [Arzew]  \n",
       "7   C}KY7309489467  9320740                           IN DAH>SA RTA  \n",
       "8   C}KY7309492522  9356892      NINGBO CHINA [Ningbo and Zhoushan]  \n",
       "9   C}KY7309500853  9454010                     FUJAIRAH [Fujairah]  \n",
       "10  C}KY7309527017  9608300                         CN YNT [Yantai]  \n",
       "11  C}KY7309529189  9625152                      ORDERS WITH GUARDS  \n",
       "12  C}KY7309586098  9670004                    TH MAT [Map Ta Phut]  \n",
       "13  C}KY7309692815  9702027                                  AE RUW  \n",
       "14  C}KY7309692816  9702039                             SGSIN>CNNSA  \n",
       "15  C}KY7309693091  9701798                        KR ULSAN [Ulsan]  \n",
       "16  C}KX7309781171  9734692                         USHOU [Houston]  \n",
       "17  C}KX7309792201  9723681                      SG SIN [Singapore]  \n",
       "18  C}KG7309828093  9743722                                  KALBUT  \n",
       "19  C}KY7309843981  9778480                  RASLAFFAN [Ras Laffan]  \n",
       "20  C}KY7309878959  9847425                                   CNTAX  \n",
       "21  C}KY7309908768  9867102                     AE>DAS [Das Island]  \n",
       "22  C}KY7309456906  8818219                   SINGAPORE [Singapore]  \n",
       "23  C}KY7309467141  9012886                 LONGKOU,CHINA [Longkou]  \n",
       "24  C}KY7309468382  9031519               KHOR FAKKAN [Khor Fakkan]  \n",
       "25  C}KY7309480542  9206396                       CN DGG [Dongguan]  \n",
       "26  C}KY7309486846  9290270                        PANJIN [Yingkou]  \n",
       "27  C}KY7309466510  9002491                           SOHAR [Sohar]  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Show the location of each vessel and some general details such as location, destination and coordinates.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.VesselPhysicalAssets,\n",
    "    filter = f\"RCSAssetTypeLeaf eq 'VLGC' and VesselStatus eq 'IN SERVICE' and {date_range}\",\n",
    "    select = 'RIC, SynonymSearchAll, DTSource, LocationTimestamp, IMO,Latitude, Longitude, LocationDestination',\n",
    "    top=100\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Floating Rate Notes\n",
    "Retrieve all floating rate notes (floating coupon) in the healthcare sector which are issued in Euros.  For each, ensure the coupon rate is great than 2 and our Moody's rating is greater than 'Baa1'.\n",
    "\n",
    "To determine the rating, we apply the following logic utilizing the RatingsScope property - which is a nested property providing additional details:\n",
    "\n",
    "- RatingsScope(RatingType eq 'MIS' and CurrentRatingRank lt 10)\n",
    "\n",
    "The RatingType of 'MIS' refers to the \"Moody's Long-term Issuer Rating\".\n",
    "The CurrentRatingRank < 10 instructs search to look for ratings less than 10 ('Baa1').  **Note**: The lower the rank, the better the rating."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IssuerName</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>CouponCurrency</th>\n",
       "      <th>RCSTRBC2012Leaf</th>\n",
       "      <th>Ticker</th>\n",
       "      <th>RIC</th>\n",
       "      <th>IssueDate</th>\n",
       "      <th>CouponRate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sanofi FR</td>\n",
       "      <td>FR0000140022</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Pharmaceuticals (NEC)</td>\n",
       "      <td>SASY</td>\n",
       "      <td>FR0000140022=</td>\n",
       "      <td>1983-07-01T00:00:00.000Z</td>\n",
       "      <td>15.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sanofi FR</td>\n",
       "      <td>FR0000047656</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Pharmaceuticals (NEC)</td>\n",
       "      <td>SASY</td>\n",
       "      <td>AVEPpaEUR.MIp</td>\n",
       "      <td>1987-10-01T00:00:00.000Z</td>\n",
       "      <td>15.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IssuerName          ISIN CouponCurrency        RCSTRBC2012Leaf Ticker  \\\n",
       "0  Sanofi FR  FR0000140022            EUR  Pharmaceuticals (NEC)   SASY   \n",
       "1  Sanofi FR  FR0000047656            EUR  Pharmaceuticals (NEC)   SASY   \n",
       "\n",
       "             RIC                 IssueDate  CouponRate  \n",
       "0  FR0000140022=  1983-07-01T00:00:00.000Z        15.5  \n",
       "1  AVEPpaEUR.MIp  1987-10-01T00:00:00.000Z        15.5  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rdp.search(\n",
    "    view = rdp.SearchViews.GovCorpInstruments,\n",
    "    filter = \"CouponRate gt 2 and \\\n",
    "              RatingsScope(RatingType eq 'MIS' and CurrentRatingRank lt 10) and \\\n",
    "              RCSCouponTypeName eq 'Floating Coupon' and \\\n",
    "              IsActive eq true and \\\n",
    "              RCSTRBC2012Name eq 'Healthcare' and \\\n",
    "              RCSCurrencyLeaf xeq 'Euro'\",\n",
    "    select = \"CouponCurrency, IssuerName, IssueDate, RIC, CouponRate, ISIN, Ticker, RCSTRBC2012Leaf, MaturityDate, AssetState\",   \n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Outstanding Green Bonds\n",
    "List the outstanding Green Bonds for Telefonica."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>IssuerName</th>\n",
       "      <th>IssuerTicker</th>\n",
       "      <th>DebtTypeDescription</th>\n",
       "      <th>FaceOutstanding</th>\n",
       "      <th>RIC</th>\n",
       "      <th>CouponRate</th>\n",
       "      <th>EOMAmountOutstanding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Telefonica Europe BV, Bond, TEF 2.502</td>\n",
       "      <td>XS2109819859</td>\n",
       "      <td>Telefonica Europ</td>\n",
       "      <td>TEFBV</td>\n",
       "      <td>Junior Subordinated Note</td>\n",
       "      <td>500000000</td>\n",
       "      <td>ES210981985=</td>\n",
       "      <td>2.502</td>\n",
       "      <td>500000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Telefonica Emisiones SAU, Plain Vanilla Fixed Coupon Bond, TEF 1.069 05-Feb-2024</td>\n",
       "      <td>XS1946004451</td>\n",
       "      <td>Telefonica Emis</td>\n",
       "      <td>TEFEMI</td>\n",
       "      <td>Senior Note</td>\n",
       "      <td>1000000000</td>\n",
       "      <td>ES194600445=</td>\n",
       "      <td>1.069</td>\n",
       "      <td>1000000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                      DocumentTitle  \\\n",
       "0                                             Telefonica Europe BV, Bond, TEF 2.502   \n",
       "1  Telefonica Emisiones SAU, Plain Vanilla Fixed Coupon Bond, TEF 1.069 05-Feb-2024   \n",
       "\n",
       "           ISIN        IssuerName IssuerTicker       DebtTypeDescription  \\\n",
       "0  XS2109819859  Telefonica Europ        TEFBV  Junior Subordinated Note   \n",
       "1  XS1946004451   Telefonica Emis       TEFEMI               Senior Note   \n",
       "\n",
       "   FaceOutstanding           RIC  CouponRate  EOMAmountOutstanding  \n",
       "0        500000000  ES210981985=       2.502             500000000  \n",
       "1       1000000000  ES194600445=       1.069            1000000000  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rdp.search(\n",
    "    view = rdp.SearchViews.GovCorpInstruments,\n",
    "    filter = \"IssuerName eq 'Telefonica' and IsGreenBond eq true\",\n",
    "    select = \"IssuerName, DocumentTitle, RIC, CouponRate, ISIN, IssuerTicker, DebtTypeDescription, EOMAmountOutstanding, FaceOutstanding\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Equity Index listing in the U.S.A"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RCSTRBC2012Leaf</th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>RIC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Trade &amp; Business Publishing</td>\n",
       "      <td>Dow Jones Industrial Average Index, Equity Index</td>\n",
       "      <td>.DJI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Magazine Publishing</td>\n",
       "      <td>S&amp;P 500 Index - CBOE, Equity Index</td>\n",
       "      <td>.SPX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>UK Investment Trusts</td>\n",
       "      <td>NASDAQ 100 Index, Equity Index</td>\n",
       "      <td>.NDX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Financial &amp; Commodity Market Operators &amp; Service Providers (NEC)</td>\n",
       "      <td>NASDAQ Composite Index, Equity Index</td>\n",
       "      <td>.IXIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Professional Information Services (NEC)</td>\n",
       "      <td>Refinitiv United States Price Return Index, Equity Index</td>\n",
       "      <td>.TRXFLDUSP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Trade &amp; Business Publishing</td>\n",
       "      <td>Dow Jones Transport Average Index, Equity Index</td>\n",
       "      <td>.DJT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Trade &amp; Business Publishing</td>\n",
       "      <td>Dow Jones Composite Index, Equity Index</td>\n",
       "      <td>.DJA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Trade &amp; Business Publishing</td>\n",
       "      <td>Dow Jones Utility Average Index, Equity Index</td>\n",
       "      <td>.DJU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Magazine Publishing</td>\n",
       "      <td>S&amp;P 600 Small Cap Index, Equity Index</td>\n",
       "      <td>.SPCY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Magazine Publishing</td>\n",
       "      <td>S&amp;P 500 Index - CME, Equity Index</td>\n",
       "      <td>.INX</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    RCSTRBC2012Leaf  \\\n",
       "0                                       Trade & Business Publishing   \n",
       "1                                               Magazine Publishing   \n",
       "2                                              UK Investment Trusts   \n",
       "3  Financial & Commodity Market Operators & Service Providers (NEC)   \n",
       "4                           Professional Information Services (NEC)   \n",
       "5                                       Trade & Business Publishing   \n",
       "6                                       Trade & Business Publishing   \n",
       "7                                       Trade & Business Publishing   \n",
       "8                                               Magazine Publishing   \n",
       "9                                               Magazine Publishing   \n",
       "\n",
       "                                              DocumentTitle         RIC  \n",
       "0          Dow Jones Industrial Average Index, Equity Index        .DJI  \n",
       "1                        S&P 500 Index - CBOE, Equity Index        .SPX  \n",
       "2                            NASDAQ 100 Index, Equity Index        .NDX  \n",
       "3                      NASDAQ Composite Index, Equity Index       .IXIC  \n",
       "4  Refinitiv United States Price Return Index, Equity Index  .TRXFLDUSP  \n",
       "5           Dow Jones Transport Average Index, Equity Index        .DJT  \n",
       "6                   Dow Jones Composite Index, Equity Index        .DJA  \n",
       "7             Dow Jones Utility Average Index, Equity Index        .DJU  \n",
       "8                     S&P 600 Small Cap Index, Equity Index       .SPCY  \n",
       "9                         S&P 500 Index - CME, Equity Index        .INX  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Based on the Asset Category (Equity Index), list the top 10 indexes within the USA.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.IndexInstruments,\n",
    "    filter = \"RCSIndexCountryGroupLeaf xeq 'United States' and RCSAssetCategoryLeaf xeq 'Equity Index'\",\n",
    "    select = \"DocumentTitle, RIC, RCSTRBC2012Leaf\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Search for Brazil global sovereign bonds in USD with a duration greater than 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IndustrySector</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>FaceOutstandingUSD</th>\n",
       "      <th>OptionAdjustedDuration</th>\n",
       "      <th>RIC</th>\n",
       "      <th>CouponRate</th>\n",
       "      <th>MaturityDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BU30</td>\n",
       "      <td>2150000000</td>\n",
       "      <td>1.995180</td>\n",
       "      <td>105756BU3=</td>\n",
       "      <td>2.625</td>\n",
       "      <td>2023-01-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AR10</td>\n",
       "      <td>1029030000</td>\n",
       "      <td>2.959345</td>\n",
       "      <td>BR012631375=</td>\n",
       "      <td>8.875</td>\n",
       "      <td>2024-04-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AZ36</td>\n",
       "      <td>85557000</td>\n",
       "      <td>2.959345</td>\n",
       "      <td>BR017244388=</td>\n",
       "      <td>8.875</td>\n",
       "      <td>2024-04-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BV13</td>\n",
       "      <td>4300000000</td>\n",
       "      <td>3.698457</td>\n",
       "      <td>105756BV1=</td>\n",
       "      <td>4.250</td>\n",
       "      <td>2025-01-07T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BF62</td>\n",
       "      <td>688201000</td>\n",
       "      <td>3.514352</td>\n",
       "      <td>BR021210641=</td>\n",
       "      <td>8.750</td>\n",
       "      <td>2025-02-04T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756CD06</td>\n",
       "      <td>1750000000</td>\n",
       "      <td>4.199081</td>\n",
       "      <td>105756CD0=</td>\n",
       "      <td>2.875</td>\n",
       "      <td>2025-06-06T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BX78</td>\n",
       "      <td>2176245000</td>\n",
       "      <td>4.608230</td>\n",
       "      <td>105756BX7=</td>\n",
       "      <td>6.000</td>\n",
       "      <td>2026-04-07T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AE07</td>\n",
       "      <td>765023000</td>\n",
       "      <td>5.052952</td>\n",
       "      <td>105756AE0=</td>\n",
       "      <td>10.125</td>\n",
       "      <td>2027-05-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BZ27</td>\n",
       "      <td>3000000000</td>\n",
       "      <td>5.823233</td>\n",
       "      <td>105756BZ2=</td>\n",
       "      <td>4.625</td>\n",
       "      <td>2028-01-13T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756CA66</td>\n",
       "      <td>2000000000</td>\n",
       "      <td>6.928336</td>\n",
       "      <td>105756CA6=</td>\n",
       "      <td>4.500</td>\n",
       "      <td>2029-05-30T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndustrySector          ISIN  FaceOutstandingUSD  OptionAdjustedDuration  \\\n",
       "0       SOVERGRN  US105756BU30          2150000000                1.995180   \n",
       "1       SOVERGRN  US105756AR10          1029030000                2.959345   \n",
       "2       SOVERGRN  US105756AZ36            85557000                2.959345   \n",
       "3       SOVERGRN  US105756BV13          4300000000                3.698457   \n",
       "4       SOVERGRN  US105756BF62           688201000                3.514352   \n",
       "5       SOVERGRN  US105756CD06          1750000000                4.199081   \n",
       "6       SOVERGRN  US105756BX78          2176245000                4.608230   \n",
       "7       SOVERGRN  US105756AE07           765023000                5.052952   \n",
       "8       SOVERGRN  US105756BZ27          3000000000                5.823233   \n",
       "9       SOVERGRN  US105756CA66          2000000000                6.928336   \n",
       "\n",
       "            RIC  CouponRate              MaturityDate  \n",
       "0    105756BU3=       2.625  2023-01-05T00:00:00.000Z  \n",
       "1  BR012631375=       8.875  2024-04-15T00:00:00.000Z  \n",
       "2  BR017244388=       8.875  2024-04-15T00:00:00.000Z  \n",
       "3    105756BV1=       4.250  2025-01-07T00:00:00.000Z  \n",
       "4  BR021210641=       8.750  2025-02-04T00:00:00.000Z  \n",
       "5    105756CD0=       2.875  2025-06-06T00:00:00.000Z  \n",
       "6    105756BX7=       6.000  2026-04-07T00:00:00.000Z  \n",
       "7    105756AE0=      10.125  2027-05-15T00:00:00.000Z  \n",
       "8    105756BZ2=       4.625  2028-01-13T00:00:00.000Z  \n",
       "9    105756CA6=       4.500  2029-05-30T00:00:00.000Z  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rdp.search(\n",
    "    view=rdp.SearchViews.FixedIncomeInstruments,\n",
    "    filter = \"RCSIssuerCountryLeaf eq 'Brazil' and \\\n",
    "              RCSCurrencyLeaf eq 'US Dollar' and \\\n",
    "              RCSTRBC2012Leaf eq 'Government & Government Finance' and \\\n",
    "              OptionAdjustedDuration gt 1\",\n",
    "    select =\"RIC, ISIN, MaturityDate, CouponRate, IndustrySector, FaceOutstandingUSD, OptionAdjustedDuration\"\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IndustrySector</th>\n",
       "      <th>ISIN</th>\n",
       "      <th>FaceOutstandingUSD</th>\n",
       "      <th>OptionAdjustedDuration</th>\n",
       "      <th>RIC</th>\n",
       "      <th>CouponRate</th>\n",
       "      <th>MaturityDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BU30</td>\n",
       "      <td>2150000000</td>\n",
       "      <td>1.995180</td>\n",
       "      <td>105756BU3=</td>\n",
       "      <td>2.625</td>\n",
       "      <td>2023-01-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AR10</td>\n",
       "      <td>1029030000</td>\n",
       "      <td>2.959345</td>\n",
       "      <td>BR012631375=</td>\n",
       "      <td>8.875</td>\n",
       "      <td>2024-04-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AZ36</td>\n",
       "      <td>85557000</td>\n",
       "      <td>2.959345</td>\n",
       "      <td>BR017244388=</td>\n",
       "      <td>8.875</td>\n",
       "      <td>2024-04-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BV13</td>\n",
       "      <td>4300000000</td>\n",
       "      <td>3.698457</td>\n",
       "      <td>105756BV1=</td>\n",
       "      <td>4.250</td>\n",
       "      <td>2025-01-07T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BF62</td>\n",
       "      <td>688201000</td>\n",
       "      <td>3.514352</td>\n",
       "      <td>BR021210641=</td>\n",
       "      <td>8.750</td>\n",
       "      <td>2025-02-04T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756CD06</td>\n",
       "      <td>1750000000</td>\n",
       "      <td>4.199081</td>\n",
       "      <td>105756CD0=</td>\n",
       "      <td>2.875</td>\n",
       "      <td>2025-06-06T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BX78</td>\n",
       "      <td>2176245000</td>\n",
       "      <td>4.608230</td>\n",
       "      <td>105756BX7=</td>\n",
       "      <td>6.000</td>\n",
       "      <td>2026-04-07T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756AE07</td>\n",
       "      <td>765023000</td>\n",
       "      <td>5.052952</td>\n",
       "      <td>105756AE0=</td>\n",
       "      <td>10.125</td>\n",
       "      <td>2027-05-15T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756BZ27</td>\n",
       "      <td>3000000000</td>\n",
       "      <td>5.823233</td>\n",
       "      <td>105756BZ2=</td>\n",
       "      <td>4.625</td>\n",
       "      <td>2028-01-13T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SOVERGRN</td>\n",
       "      <td>US105756CA66</td>\n",
       "      <td>2000000000</td>\n",
       "      <td>6.928336</td>\n",
       "      <td>105756CA6=</td>\n",
       "      <td>4.500</td>\n",
       "      <td>2029-05-30T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndustrySector          ISIN  FaceOutstandingUSD  OptionAdjustedDuration  \\\n",
       "0       SOVERGRN  US105756BU30          2150000000                1.995180   \n",
       "1       SOVERGRN  US105756AR10          1029030000                2.959345   \n",
       "2       SOVERGRN  US105756AZ36            85557000                2.959345   \n",
       "3       SOVERGRN  US105756BV13          4300000000                3.698457   \n",
       "4       SOVERGRN  US105756BF62           688201000                3.514352   \n",
       "5       SOVERGRN  US105756CD06          1750000000                4.199081   \n",
       "6       SOVERGRN  US105756BX78          2176245000                4.608230   \n",
       "7       SOVERGRN  US105756AE07           765023000                5.052952   \n",
       "8       SOVERGRN  US105756BZ27          3000000000                5.823233   \n",
       "9       SOVERGRN  US105756CA66          2000000000                6.928336   \n",
       "\n",
       "            RIC  CouponRate              MaturityDate  \n",
       "0    105756BU3=       2.625  2023-01-05T00:00:00.000Z  \n",
       "1  BR012631375=       8.875  2024-04-15T00:00:00.000Z  \n",
       "2  BR017244388=       8.875  2024-04-15T00:00:00.000Z  \n",
       "3    105756BV1=       4.250  2025-01-07T00:00:00.000Z  \n",
       "4  BR021210641=       8.750  2025-02-04T00:00:00.000Z  \n",
       "5    105756CD0=       2.875  2025-06-06T00:00:00.000Z  \n",
       "6    105756BX7=       6.000  2026-04-07T00:00:00.000Z  \n",
       "7    105756AE0=      10.125  2027-05-15T00:00:00.000Z  \n",
       "8    105756BZ2=       4.625  2028-01-13T00:00:00.000Z  \n",
       "9    105756CA6=       4.500  2029-05-30T00:00:00.000Z  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Alternatively, you have the option of trying it this way which will render the same results\n",
    "rdp.search(\n",
    "    view=rdp.SearchViews.FixedIncomeInstruments,\n",
    "    filter = \"IssuerCountryName eq 'Brazil' and \\\n",
    "              OptionAdjustedDuration gt 1 and \\\n",
    "              Currency eq 'USD' and IndustrySectorDescription eq 'Sovereign'\",\n",
    "    select =\"RIC, ISIN, MaturityDate, CouponRate,IndustrySector, FaceOutstandingUSD, OptionAdjustedDuration\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Top executives"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>PrimaryOfficerDirector</th>\n",
       "      <th>FullName</th>\n",
       "      <th>PrimaryOfficerDirectorRIC</th>\n",
       "      <th>PrimaryTitleAsReported</th>\n",
       "      <th>OfficerDirectorActiveCompanies</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Microsoft Corp</td>\n",
       "      <td>John Wendell Thompson</td>\n",
       "      <td>MSFT.O</td>\n",
       "      <td>Independent Non-Executive Chairman of the Board</td>\n",
       "      <td>[User Replay Ltd, Crystal Decisions Inc, Commerce Decisions Ltd, Illumina Inc, Microsoft Corp]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Microsoft Corp</td>\n",
       "      <td>Satya Nadella</td>\n",
       "      <td>MSFT.O</td>\n",
       "      <td>Chief Executive Officer, Director</td>\n",
       "      <td>[Starbucks Corp, Chandler Insurance Company Ltd, Microsoft Corp]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Apple Inc</td>\n",
       "      <td>Art D. Levinson</td>\n",
       "      <td>AAPL.O</td>\n",
       "      <td>Independent Chairman of the Board</td>\n",
       "      <td>[Apple Inc, Genentech Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apple Inc</td>\n",
       "      <td>Tim D. Cook</td>\n",
       "      <td>AAPL.O</td>\n",
       "      <td>Chief Executive Officer, Director</td>\n",
       "      <td>[Apple Inc, Nike Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Amazon.com Inc</td>\n",
       "      <td>Jeff P. Bezos</td>\n",
       "      <td>AMZN.O</td>\n",
       "      <td>Chairman of the Board, President, Chief Executive Officer</td>\n",
       "      <td>[Institute For Advanced Study, Amazon.com Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Amazon.com Inc</td>\n",
       "      <td>Keith Brian Alexander</td>\n",
       "      <td>AMZN.O</td>\n",
       "      <td>Director</td>\n",
       "      <td>[Amazon.com Inc, Ironnet Cybersecurity Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Amazon.com Inc</td>\n",
       "      <td>Jon J. Rubinstein</td>\n",
       "      <td>AMZN.O</td>\n",
       "      <td>Independent Director</td>\n",
       "      <td>[Palm Inc, Amazon.com Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alphabet Inc</td>\n",
       "      <td>Sundar Pichai</td>\n",
       "      <td>GOOGL.O</td>\n",
       "      <td>Chief Executive Officer, Director</td>\n",
       "      <td>[Alphabet Inc, Ruba  Inc (Fka  Kudo  Inc)]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alphabet Inc</td>\n",
       "      <td>Roger W. Ferguson</td>\n",
       "      <td>GOOGL.O</td>\n",
       "      <td>Independent Director</td>\n",
       "      <td>[Teachers Insurance and Annuity Association of America, Audax Health Solutions LLC, Alphabet Inc, International Flavors &amp; Fragrances Inc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Facebook Inc</td>\n",
       "      <td>Mark Zuckerberg</td>\n",
       "      <td>FB.O</td>\n",
       "      <td>Chairman of the Board, Chief Executive Officer, Founder</td>\n",
       "      <td>[Facebook Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Facebook Inc</td>\n",
       "      <td>Dustin A. Moskovitz</td>\n",
       "      <td>FB.O</td>\n",
       "      <td>Venture Economics Executive</td>\n",
       "      <td>[Facebook Inc, Asana Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Facebook Inc</td>\n",
       "      <td>Adam D'Angelo</td>\n",
       "      <td>FB.O</td>\n",
       "      <td>Venture Economics Executive</td>\n",
       "      <td>[Facebook Inc, Quora Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Berkshire Hathaway Inc</td>\n",
       "      <td>Warren Edward Buffett</td>\n",
       "      <td>BRKa</td>\n",
       "      <td>Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>[Grinnell College, Bill &amp; Melinda Gates Foundation Trust, Berkshire Hathaway Inc, Kraft Heinz Intermediate Corporation II, Lubrizol Corp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Berkshire Hathaway Inc</td>\n",
       "      <td>Gregory E. Abel</td>\n",
       "      <td>BRKa</td>\n",
       "      <td>Vice Chairman � Non Insurance Operations, Director</td>\n",
       "      <td>[Northern Electric PLC, Berkshire Hathaway Inc, Northern Powergrid Holdings Co, Kraft Heinz Intermediate Corporation II, Pacificorp, Ber...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Berkshire Hathaway Inc</td>\n",
       "      <td>Steve B. Burke</td>\n",
       "      <td>BRKa</td>\n",
       "      <td>Independent Director</td>\n",
       "      <td>[Berkshire Hathaway Inc, NBCUniversal Media LLC, JP Morgan Investment Management Inc, JPMorgan Chase &amp; Co]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alibaba Group Holding Ltd</td>\n",
       "      <td>Daniel Zhang</td>\n",
       "      <td>BABA.K</td>\n",
       "      <td>Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>[Weibo Corp, Alibaba Group Holding Ltd, Sun Art Retail Group Ltd]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Alibaba Group Holding Ltd</td>\n",
       "      <td>Fan Jiang</td>\n",
       "      <td>BABA.K</td>\n",
       "      <td>President - Taobao and Tmall</td>\n",
       "      <td>[Alibaba Group Holding Ltd, Umeng Technology Ltd]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Tencent Holdings Ltd</td>\n",
       "      <td>Huateng Ma</td>\n",
       "      <td>0700.HK</td>\n",
       "      <td>Executive Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>[Tencent Holdings Ltd, Tencent Technology Beijing Co Ltd]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Visa Inc</td>\n",
       "      <td>Al Francis Kelly</td>\n",
       "      <td>V</td>\n",
       "      <td>Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>[Visa Inc]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Johnson &amp; Johnson</td>\n",
       "      <td>Alex Gorsky</td>\n",
       "      <td>JNJ</td>\n",
       "      <td>Chairman of the Board, Chief Executive Officer</td>\n",
       "      <td>[Johnson &amp; Johnson Services Inc, Ethicon Inc, Johnson &amp; Johnson, International Business Machines Corp]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       PrimaryOfficerDirector               FullName  \\\n",
       "0              Microsoft Corp  John Wendell Thompson   \n",
       "1              Microsoft Corp          Satya Nadella   \n",
       "2                   Apple Inc        Art D. Levinson   \n",
       "3                   Apple Inc            Tim D. Cook   \n",
       "4              Amazon.com Inc          Jeff P. Bezos   \n",
       "5              Amazon.com Inc  Keith Brian Alexander   \n",
       "6              Amazon.com Inc      Jon J. Rubinstein   \n",
       "7                Alphabet Inc          Sundar Pichai   \n",
       "8                Alphabet Inc      Roger W. Ferguson   \n",
       "9                Facebook Inc        Mark Zuckerberg   \n",
       "10               Facebook Inc    Dustin A. Moskovitz   \n",
       "11               Facebook Inc          Adam D'Angelo   \n",
       "12     Berkshire Hathaway Inc  Warren Edward Buffett   \n",
       "13     Berkshire Hathaway Inc        Gregory E. Abel   \n",
       "14     Berkshire Hathaway Inc         Steve B. Burke   \n",
       "15  Alibaba Group Holding Ltd           Daniel Zhang   \n",
       "16  Alibaba Group Holding Ltd              Fan Jiang   \n",
       "17       Tencent Holdings Ltd             Huateng Ma   \n",
       "18                   Visa Inc       Al Francis Kelly   \n",
       "19          Johnson & Johnson            Alex Gorsky   \n",
       "\n",
       "   PrimaryOfficerDirectorRIC  \\\n",
       "0                     MSFT.O   \n",
       "1                     MSFT.O   \n",
       "2                     AAPL.O   \n",
       "3                     AAPL.O   \n",
       "4                     AMZN.O   \n",
       "5                     AMZN.O   \n",
       "6                     AMZN.O   \n",
       "7                    GOOGL.O   \n",
       "8                    GOOGL.O   \n",
       "9                       FB.O   \n",
       "10                      FB.O   \n",
       "11                      FB.O   \n",
       "12                      BRKa   \n",
       "13                      BRKa   \n",
       "14                      BRKa   \n",
       "15                    BABA.K   \n",
       "16                    BABA.K   \n",
       "17                   0700.HK   \n",
       "18                         V   \n",
       "19                       JNJ   \n",
       "\n",
       "                                       PrimaryTitleAsReported  \\\n",
       "0             Independent Non-Executive Chairman of the Board   \n",
       "1                           Chief Executive Officer, Director   \n",
       "2                           Independent Chairman of the Board   \n",
       "3                           Chief Executive Officer, Director   \n",
       "4   Chairman of the Board, President, Chief Executive Officer   \n",
       "5                                                    Director   \n",
       "6                                        Independent Director   \n",
       "7                           Chief Executive Officer, Director   \n",
       "8                                        Independent Director   \n",
       "9     Chairman of the Board, Chief Executive Officer, Founder   \n",
       "10                                Venture Economics Executive   \n",
       "11                                Venture Economics Executive   \n",
       "12             Chairman of the Board, Chief Executive Officer   \n",
       "13         Vice Chairman � Non Insurance Operations, Director   \n",
       "14                                       Independent Director   \n",
       "15             Chairman of the Board, Chief Executive Officer   \n",
       "16                               President - Taobao and Tmall   \n",
       "17   Executive Chairman of the Board, Chief Executive Officer   \n",
       "18             Chairman of the Board, Chief Executive Officer   \n",
       "19             Chairman of the Board, Chief Executive Officer   \n",
       "\n",
       "                                                                                                                 OfficerDirectorActiveCompanies  \n",
       "0                                                [User Replay Ltd, Crystal Decisions Inc, Commerce Decisions Ltd, Illumina Inc, Microsoft Corp]  \n",
       "1                                                                              [Starbucks Corp, Chandler Insurance Company Ltd, Microsoft Corp]  \n",
       "2                                                                                                                    [Apple Inc, Genentech Inc]  \n",
       "3                                                                                                                         [Apple Inc, Nike Inc]  \n",
       "4                                                                                                [Institute For Advanced Study, Amazon.com Inc]  \n",
       "5                                                                                                   [Amazon.com Inc, Ironnet Cybersecurity Inc]  \n",
       "6                                                                                                                    [Palm Inc, Amazon.com Inc]  \n",
       "7                                                                                                    [Alphabet Inc, Ruba  Inc (Fka  Kudo  Inc)]  \n",
       "8   [Teachers Insurance and Annuity Association of America, Audax Health Solutions LLC, Alphabet Inc, International Flavors & Fragrances Inc...  \n",
       "9                                                                                                                                [Facebook Inc]  \n",
       "10                                                                                                                    [Facebook Inc, Asana Inc]  \n",
       "11                                                                                                                    [Facebook Inc, Quora Inc]  \n",
       "12  [Grinnell College, Bill & Melinda Gates Foundation Trust, Berkshire Hathaway Inc, Kraft Heinz Intermediate Corporation II, Lubrizol Corp...  \n",
       "13  [Northern Electric PLC, Berkshire Hathaway Inc, Northern Powergrid Holdings Co, Kraft Heinz Intermediate Corporation II, Pacificorp, Ber...  \n",
       "14                                   [Berkshire Hathaway Inc, NBCUniversal Media LLC, JP Morgan Investment Management Inc, JPMorgan Chase & Co]  \n",
       "15                                                                            [Weibo Corp, Alibaba Group Holding Ltd, Sun Art Retail Group Ltd]  \n",
       "16                                                                                            [Alibaba Group Holding Ltd, Umeng Technology Ltd]  \n",
       "17                                                                                    [Tencent Holdings Ltd, Tencent Technology Beijing Co Ltd]  \n",
       "18                                                                                                                                   [Visa Inc]  \n",
       "19                                       [Johnson & Johnson Services Inc, Ethicon Inc, Johnson & Johnson, International Business Machines Corp]  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Using the People View, we can utilize the OfficerDirector property, which contains a number of nested or sub-properties \n",
    "# that allow me to perform a more fine-grained search against active people that have been assigned a title code of \n",
    "# CEO (Chief Executive Officer). The results are listed based on a default rank defined by the search service.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.People,\n",
    "    filter = \"OfficerDirector(RoleTitleCode eq 'CEO' and RoleStatus eq 'Active')\",\n",
    "    top = 20,\n",
    "    select = \"FullName, PrimaryTitleAsReported, PrimaryOfficerDirector, RIC, OfficerDirectorActiveCompanies, PrimaryOfficerDirectorRIC\"\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Example - Live Options\n",
    "The following example will specify an underlying instrument (RIC) and pull the list of options that are active, i.e. not expired."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DocumentTitle</th>\n",
       "      <th>CallPutOption</th>\n",
       "      <th>StrikePrice</th>\n",
       "      <th>RIC</th>\n",
       "      <th>ExpiryDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OPRA Apple Equity Option 120 Put Feb 2021 , Equity Cash Option, Put 120 USD 19-Feb-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>120.0</td>\n",
       "      <td>AAPLN192112000.U</td>\n",
       "      <td>2021-02-19T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>OPRA Apple Equity Option 130 Call Feb 2021 , Equity Cash Option, Call 130 USD 19-Feb-2021, OPRA</td>\n",
       "      <td>Call</td>\n",
       "      <td>130.0</td>\n",
       "      <td>AAPLB192113000.U</td>\n",
       "      <td>2021-02-19T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>OPRA Apple Equity Option 125 Call Feb 2021 , Equity Cash Option, Call 125 USD 19-Feb-2021, OPRA</td>\n",
       "      <td>Call</td>\n",
       "      <td>125.0</td>\n",
       "      <td>AAPLB192112500.U</td>\n",
       "      <td>2021-02-19T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OPRA Apple Equity Option 130 Put Feb 2021 , Equity Cash Option, Put 130 USD 19-Feb-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>130.0</td>\n",
       "      <td>AAPLN192113000.U</td>\n",
       "      <td>2021-02-19T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OPRA Apple Equity Option 120 Call Feb 2021 , Equity Cash Option, Call 120 USD 19-Feb-2021, OPRA</td>\n",
       "      <td>Call</td>\n",
       "      <td>120.0</td>\n",
       "      <td>AAPLB192112000.U</td>\n",
       "      <td>2021-02-19T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2151</th>\n",
       "      <td>OPRA Apple Equity Option 143 Put Mar 2021 , Equity Cash Option, Put 143 USD 05-Mar-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>143.0</td>\n",
       "      <td>AAPLO052114300.U</td>\n",
       "      <td>2021-03-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2152</th>\n",
       "      <td>OPRA Apple Equity Option 129 Call Mar 2021 , Equity Cash Option, Call 129 USD 05-Mar-2021, OPRA</td>\n",
       "      <td>Call</td>\n",
       "      <td>129.0</td>\n",
       "      <td>AAPLC052112900.U</td>\n",
       "      <td>2021-03-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2153</th>\n",
       "      <td>OPRA Apple Equity Option 125 Put Mar 2021 , Equity Cash Option, Put 125 USD 05-Mar-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>125.0</td>\n",
       "      <td>AAPLO052112500.U</td>\n",
       "      <td>2021-03-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2154</th>\n",
       "      <td>OPRA Apple Equity Option 128 Put Mar 2021 , Equity Cash Option, Put 128 USD 05-Mar-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>128.0</td>\n",
       "      <td>AAPLO052112800.U</td>\n",
       "      <td>2021-03-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2155</th>\n",
       "      <td>OPRA Apple Equity Option 142 Put Mar 2021 , Equity Cash Option, Put 142 USD 05-Mar-2021, OPRA</td>\n",
       "      <td>Put</td>\n",
       "      <td>142.0</td>\n",
       "      <td>AAPLO052114200.U</td>\n",
       "      <td>2021-03-05T00:00:00.000Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2156 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                        DocumentTitle  \\\n",
       "0       OPRA Apple Equity Option 120 Put Feb 2021 , Equity Cash Option, Put 120 USD 19-Feb-2021, OPRA   \n",
       "1     OPRA Apple Equity Option 130 Call Feb 2021 , Equity Cash Option, Call 130 USD 19-Feb-2021, OPRA   \n",
       "2     OPRA Apple Equity Option 125 Call Feb 2021 , Equity Cash Option, Call 125 USD 19-Feb-2021, OPRA   \n",
       "3       OPRA Apple Equity Option 130 Put Feb 2021 , Equity Cash Option, Put 130 USD 19-Feb-2021, OPRA   \n",
       "4     OPRA Apple Equity Option 120 Call Feb 2021 , Equity Cash Option, Call 120 USD 19-Feb-2021, OPRA   \n",
       "...                                                                                               ...   \n",
       "2151    OPRA Apple Equity Option 143 Put Mar 2021 , Equity Cash Option, Put 143 USD 05-Mar-2021, OPRA   \n",
       "2152  OPRA Apple Equity Option 129 Call Mar 2021 , Equity Cash Option, Call 129 USD 05-Mar-2021, OPRA   \n",
       "2153    OPRA Apple Equity Option 125 Put Mar 2021 , Equity Cash Option, Put 125 USD 05-Mar-2021, OPRA   \n",
       "2154    OPRA Apple Equity Option 128 Put Mar 2021 , Equity Cash Option, Put 128 USD 05-Mar-2021, OPRA   \n",
       "2155    OPRA Apple Equity Option 142 Put Mar 2021 , Equity Cash Option, Put 142 USD 05-Mar-2021, OPRA   \n",
       "\n",
       "     CallPutOption  StrikePrice               RIC                ExpiryDate  \n",
       "0              Put        120.0  AAPLN192112000.U  2021-02-19T00:00:00.000Z  \n",
       "1             Call        130.0  AAPLB192113000.U  2021-02-19T00:00:00.000Z  \n",
       "2             Call        125.0  AAPLB192112500.U  2021-02-19T00:00:00.000Z  \n",
       "3              Put        130.0  AAPLN192113000.U  2021-02-19T00:00:00.000Z  \n",
       "4             Call        120.0  AAPLB192112000.U  2021-02-19T00:00:00.000Z  \n",
       "...            ...          ...               ...                       ...  \n",
       "2151           Put        143.0  AAPLO052114300.U  2021-03-05T00:00:00.000Z  \n",
       "2152          Call        129.0  AAPLC052112900.U  2021-03-05T00:00:00.000Z  \n",
       "2153           Put        125.0  AAPLO052112500.U  2021-03-05T00:00:00.000Z  \n",
       "2154           Put        128.0  AAPLO052112800.U  2021-03-05T00:00:00.000Z  \n",
       "2155           Put        142.0  AAPLO052114200.U  2021-03-05T00:00:00.000Z  \n",
       "\n",
       "[2156 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Define our underlying\n",
    "underlying = \"'AAPL.O'\"\n",
    "\n",
    "# To search for our instrument, I'm utilizing the property: 'UnderlyingQuoteRIC'.  The property does not support an \n",
    "# exact match 'xeq', so we must use the partial match 'eq' to find all hits. Depending on the instrument you specify, \n",
    "# this may introduce additional hits.  For example, if you are using the underlying 'AAPL.O', search will also find a \n",
    "# hit on 'AAPL.OQ', for example. To protect against this, we can utilize a combination of the built-in functions, \n",
    "# 'startswith' and 'endwith' to perform our match.\n",
    "rdp.search(\n",
    "    view = rdp.SearchViews.EquityDerivativeQuotes,\n",
    "    filter = \"AssetState eq 'AC' and \\\n",
    "              startswith(UnderlyingQuoteRIC, \" + underlying + \") and \\\n",
    "              endswith(UnderlyingQuoteRIC,\" + underlying + \") and \\\n",
    "              RCSAssetClass eq 'OPT' and IsChain eq false and \\\n",
    "              ExpiryDate ge \" + dt.datetime.today().strftime('%Y-%m-%d'),\n",
    "    select = \"DocumentTitle, RIC, ExpiryDate, CallPutOption, StrikePrice\",\n",
    "    top = 10000\n",
    ")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}