1_get_dataset-0616.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "35986f4d-5348-47b1-a0d8-475980308287",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import FinanceDataReader as fdr\n",
    "import yfinance as yf\n",
    "import warnings\n",
    "warnings.simplefilter(action='ignore', category=FutureWarning)\n",
    "import yahoo_fin.stock_info as si\n",
    "from yahoo_fin.stock_info import get_data\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import yfinance as yf\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from yahoo_fin import stock_info as si\n",
    "from concurrent.futures import ThreadPoolExecutor, as_completed\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from utils.prepro import preprocess_stock\n",
    "\n",
    "pd.set_option('display.max_row', 500)\n",
    "pd.set_option('display.max_columns', 100)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69640737-f69c-449d-8ea1-0089b2775fc5",
   "metadata": {},
   "source": [
    "### Get dataset list\n",
    "\n",
    "1. We collect the dataset from FDR package \n",
    "2. We drop the non stock such as \"fund\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e2bb1a12-6c6c-4013-b2ec-0457735c36b0",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100% 3802/3802 [00:06<00:00, 567.58it/s]\n",
      "100% 2821/2821 [00:04<00:00, 573.18it/s]\n",
      "100% 1542/1542 [00:01<00:00, 1036.70it/s]\n",
      "100% 2677/2677 [00:02<00:00, 971.19it/s] \n",
      "100% 4013/4013 [00:04<00:00, 927.10it/s] \n",
      "100% 1808/1808 [00:02<00:00, 855.85it/s]\n"
     ]
    }
   ],
   "source": [
    "kospi_symbol = fdr.StockListing('KOSPI')\n",
    "nasdaq_symbol = fdr.StockListing('NASDAQ')\n",
    "nyse_symbol = fdr.StockListing('NYSE')\n",
    "\n",
    "sse_stocks = fdr.StockListing('SSE')   #상해거래소\n",
    "HKEX_stocks = fdr.StockListing('HKEX') #홍콩거래소\n",
    "TSE_stocks = fdr.StockListing('TSE')   #도쿄거래소\n",
    "SZSE_stocks = fdr.StockListing('SZSE') #산전거래소\n",
    "\n",
    "nasdaq_symbol[\"exchange\"] = \"NASDAQ\"\n",
    "sse_stocks[\"exchange\"] = \"SSE\"\n",
    "TSE_stocks[\"exchange\"] = \"TSE\"\n",
    "kospi_symbol[\"exchange\"] = \"KOSPI\"\n",
    "HKEX_stocks[\"exchange\"] = \"HKEX\"\n",
    "SZSE_stocks[\"exchange\"] = \"SZSE\"\n",
    "nyse_symbol[\"exchange\"] = \"NYES\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "aebe14a1-495c-41b6-b981-258e1871770f",
   "metadata": {},
   "outputs": [],
   "source": [
    "asdaq_symbol = nasdaq_symbol[~nasdaq_symbol[\"Industry\"].str.contains(\"펀드\", na=False)]\n",
    "se_stocks = sse_stocks[~sse_stocks[\"Industry\"].str.contains(\"펀드\", na=False)]\n",
    "SE_stocks = TSE_stocks[~TSE_stocks[\"Industry\"].str.contains(\"펀드\", na=False)]\n",
    "KEX_stocks = HKEX_stocks[~HKEX_stocks[\"Industry\"].str.contains(\"펀드\", na=False)]\n",
    "ZSE_stocks = SZSE_stocks[~SZSE_stocks[\"Industry\"].str.contains(\"펀드\", na=False)]\n",
    "yse_symbol = nyse_symbol[~nyse_symbol[\"Industry\"].str.contains(\"펀드\", na=False)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "20c1c86c-e068-4f6b-bc05-3a0df7aa8ced",
   "metadata": {},
   "outputs": [],
   "source": [
    "kospi_symbol[\"Symbol\"] = kospi_symbol[\"Code\"] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d7bcb9a5-b6e6-45d8-bbc1-9c80d6858d2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "stock_list = pd.concat([nasdaq_symbol, nyse_symbol]).dropna().reset_index(drop = True)\n",
    "stock_list = stock_list.drop(\"Name\", axis = 1)\n",
    "stock_list = stock_list.drop_duplicates().reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cb17f47a-002f-4baa-b24d-7eb147c6f6e6",
   "metadata": {},
   "source": [
    "### Get dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0b2fadca-75da-4672-9afb-2b53aec30db8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Notice that : 2023년 1월 1일 부터 2023년 8월 31일까지 발행된 정보(2023년 8월 31일 기준)\n",
    "\n",
    "def fetch_data(symbol, exchange, industry_code):\n",
    "    try:\n",
    "        if exchange == \"TSE\":\n",
    "            symbol = symbol + \".T\"\n",
    "        elif exchange == \"SZSE\":\n",
    "            symbol = symbol + \".SZ\"\n",
    "        elif exchange == \"SSE\":\n",
    "            symbol = symbol + \".SS\"\n",
    "        elif exchange == \"KOSPI\":\n",
    "            symbol = symbol + \".KS\"    \n",
    "        \n",
    "        ticker = yf.Ticker(symbol)\n",
    "        df = ticker.history(start=\"2018-01-01\",end = \"2024-03-28\", interval=\"1d\").reset_index()[[\"Date\", \"Open\",\"High\",\"Low\",\"Close\",\"Volume\"]]   \n",
    "        df = preprocess_stock(df)\n",
    "        df[\"Stock_\"] = symbol\n",
    "        df[\"IndustryCode_\"] = industry_code\n",
    "    except Exception as e:\n",
    "        print(f\"Error fetching data for {symbol}: {e}\")\n",
    "        return None\n",
    "    \n",
    "    return df\n",
    "\n",
    "def get_all_data(stock_list):\n",
    "    with ThreadPoolExecutor() as executor:\n",
    "        futures = [executor.submit(fetch_data, symbol, exchange, industry_code) for symbol, exchange, industry_code in zip(stock_list[\"Symbol\"], stock_list[\"exchange\"], stock_list[\"IndustryCode\"])]\n",
    "        results = [future.result() for future in as_completed(futures)]\n",
    "\n",
    "    data = pd.concat([result for result in results if result is not None])\n",
    "\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "102c41b5-8330-4931-a5ee-d6dfd7389133",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "FAAS: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "BOLD: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "Got error from yahoo api for ticker GWACU, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GWACU: No timezone found, symbol may be delisted\n",
      "ZBAO: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "MAMO: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "UBXG: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "ZPTA: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "NCAC: No data found, symbol may be delisted\n",
      "NIVF: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "Got error from yahoo api for ticker GIPRU, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GIPRU: No timezone found, symbol may be delisted\n",
      "CLVSQ: No data found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MAXNV, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MAXNV: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SPWRV, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPWRV: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SPEL, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPEL: No timezone found, symbol may be delisted\n",
      "MCACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BREZR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "MVNR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "MBTCR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "IMAQR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "CLOER: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "WINVR: Period '1mo' is invalid, must be one of ['1d', '5d']PPHPR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "\n",
      "NOVVR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "MCAGR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BNIXR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "HHGCR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "GLLIR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BLEUR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "FEXDR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "NVACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "KACLR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "ALSAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "AIBBR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "WTMAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BRACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "IGTAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "KYCHR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "RFACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "CSLMR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "ASCAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "GDSTR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BWAQR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "ASCBR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "RWODR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "MSSAR: Period '1mo' is invalid, must be one of ['1d', '5d']CLRCR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "\n",
      "GBBKR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "FLFVR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "GLSTR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "SVIIR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "YOTAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "QOMOR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "TENKR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "AQUNR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "ATMVR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "EMCGR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BLACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "PLTNR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "MARXR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "CETUR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "HSPOR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "TMTCR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "DISTR: Period '1mo' is invalid, must be one of ['1d', '5d']ATMCR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "GODNR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "\n",
      "ESHAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BUJAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BAYAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "QETAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "GLACR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "BOWNR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "IBLUU: No data found, symbol may be delistedAITRR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "\n",
      "AFJKR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "NNAGR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "JVSAR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "IROHR: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "Got error from yahoo api for ticker BRK.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BRK.B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BRK.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BRK.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PBR.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PBR.A: No timezone found, symbol may be delisted\n",
      "GEV: No data found for this date range, symbol may be delisted\n",
      "BF.B: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker HEI.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HEI.A: No timezone found, symbol may be delisted\n",
      "UHAL.B: No data found for this date range, symbol may be delisted\n",
      "SOLV: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker BF.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BF.A: No timezone found, symbol may be delisted\n",
      "SFB: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "LEN.B: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATH PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MOG.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MOG.A: No timezone found, symbol may be delisted\n",
      "ESMT: No data found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GRP.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GRP.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALB PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALB PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker C PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- C PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EBR.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EBR.B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WSO.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WSO.B: No timezone found, symbol may be delisted\n",
      "WNS: Data doesn't exist for startDate = 1514782800, endDate = 1711598400\n",
      "Got error from yahoo api for ticker CIG.C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CIG.C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CWEN.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CWEN.A: No timezone found, symbol may be delisted\n",
      "BIO.B: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker APO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- APO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NEE PR R, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NEE PR R: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR Z, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR Z: No timezone found, symbol may be delisted\n",
      "GEF.B: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker T PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- T PR C: No timezone found, symbol may be delisted\n",
      "LGF.B: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MKC.V, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MKC.V: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GS PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GS PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ET PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ET PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker COF PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- COF PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AKO.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AKO.B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BNRE.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BNRE.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR P, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR P: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker T PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- T PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALL PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALL PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR O, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR O: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR Q, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR Q: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DUK PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DUK PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AKO.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AKO.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker COF PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- COF PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SYF PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SYF PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR O, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR O: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MET PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MET PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker LGF.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- LGF.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ET PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ET PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JPM PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JPM PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TFC PR R, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TFC PR R: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MET PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MET PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCHW PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCHW PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RNR PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RNR PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NLY PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NLY PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EQH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EQH PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GS PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GS PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR P, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR P: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GS PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GS PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WFC PR Y, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WFC PR Y: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALL PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALL PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NEE PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}Got error from yahoo api for ticker BAC PR S, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR S: No timezone found, symbol may be delisted\n",
      "\n",
      "- NEE PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATH PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATH PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCE PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker JXN PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- JXN PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MET PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MET PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WCC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WCC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR P, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR P: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker LNC PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- LNC PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR R, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR R: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TFC PR O, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TFC PR O: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KEY PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KEY PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AACT.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AACT.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATH PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATH PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCHW PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCHW PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MOG.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MOG.B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RF PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RF PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AXS PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AXS PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SYF PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SYF PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker STT PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- STT PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker COF PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- COF PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BANC PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BANC PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KEY PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KEY PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MS PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MS PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RF PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RF PR C: No timezone found, symbol may be delisted\n",
      "GOL: No data found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR P, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR P: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NLY PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NLY PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATH PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATH PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CLVT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CLVT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GTLS PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GTLS PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RITM PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RITM PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NLY PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NLY PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCE PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AEL PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AEL PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NS PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NS PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KEY PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KEY PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CFG PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CFG PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TDS PR V, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TDS PR V: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BFAC.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BFAC.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NFYS.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NFYS.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRTL.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTL.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RNR PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RNR PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR S, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR S: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NGL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NGL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RITM PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker KEY PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RITM PR C: No timezone found, symbol may be delisted\n",
      "- KEY PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BML PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BML PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NYCB PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NYCB PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SAN PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SAN PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker USB PR Q, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- USB PR Q: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HIG PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HIG PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SNV PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SNV PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RRAC.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RRAC.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR R, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR R: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CIM PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CIM PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RLJ PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RLJ PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HYAC.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HYAC.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DBRG PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DBRG PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCE PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KCGI.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker CFG PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CFG PR D: No timezone found, symbol may be delisted\n",
      "- KCGI.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DLR PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker RF PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DLR PR L: No timezone found, symbol may be delisted\n",
      "- RF PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BAC PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BAC PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATH PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATH PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker COF PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- COF PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TDS PR U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TDS PR U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AEL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AEL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CNDA.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CNDA.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCE PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker VOYA PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- VOYA PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker AHL PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHL PR C: No timezone found, symbol may be delisted\n",
      "- PSA PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SCE PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RITM PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RITM PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DBRG PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DBRG PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALL PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALL PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AL PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AL PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CRD.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CRD.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker UMH PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- UMH PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker OSI.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- OSI.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RCFA.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RCFA.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BML PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BML PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PGSS.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PGSS.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRIS.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRIS.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker LCW.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- LCW.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DSAQ.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DSAQ.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SR PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SR PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MFA PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MFA PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GAQ.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GAQ.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TWO PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TWO PR B: No timezone found, symbol may be delisted\n",
      "EMP: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker KREF PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KREF PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KIM PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KIM PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HPP PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HPP PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TWO PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TWO PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NS PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NS PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SF PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SF PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ABR PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ABR PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MTB PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MTB PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SF PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SF PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PHYT.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PHYT.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATCO PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATCO PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SEDA.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SEDA.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CIM PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CIM PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EQH PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EQH PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WAL PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WAL PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker OAK PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- OAK PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EP PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EP PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FBRT PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FBRT PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SLG PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SLG PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NSA PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NSA PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHL PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHL PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SPNT PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPNT PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHL PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHL PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DBRG PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DBRG PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SNV PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SNV PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker WRB PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WRB PR G: No timezone found, symbol may be delisted\n",
      "- PSA PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DLR PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DLR PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KIM PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker BH.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KIM PR L: No timezone found, symbol may be delisted\n",
      "- BH.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CIM PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CIM PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PEB PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PEB PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker VNO PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- VNO PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BML PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BML PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker APCA.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- APCA.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PMT PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PMT PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GAM PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GAM PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PEB PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}Got error from yahoo api for ticker PSA PR S, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "\n",
      "- PEB PR H: No timezone found, symbol may be delisted\n",
      "- PSA PR S: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MNTN.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MNTN.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GS PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker SCE PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SCE PR G: No timezone found, symbol may be delisted\n",
      "- GS PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMS PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMS PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker VNO PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- VNO PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PMT PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PMT PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TNP PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TNP PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ABR PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ABR PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker IFIN.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- IFIN.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker VNO PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- VNO PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CLBR.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CLBR.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DLR PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DLR PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NS PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NS PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR M, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker IVR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- IVR PR C: No timezone found, symbol may be delisted\n",
      "- PSA PR M: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRTN PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTN PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CRD.B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CRD.B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TAP.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TAP.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker OAK PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- OAK PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker O PR, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- O PR: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRE PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRE PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GNL PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GNL PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MFA PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MFA PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ASB PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ASB PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SEAL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SEAL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AUB PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AUB PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SITC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SITC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SF PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SF PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker VNO PR O, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- VNO PR O: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RITM PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RITM PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SPLP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPLP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TGH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TGH PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TGH PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TGH PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker TFC PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TFC PR I: No timezone found, symbol may be delisted\n",
      "- AHH PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BIP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BIP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ARR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ARR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BEP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BEP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CADE PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CADE PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRTN PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTN PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GPMT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker TRTN PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GPMT PR A: No timezone found, symbol may be delisted\n",
      "- TRTN PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BIP PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BIP PR B: No timezone found, symbol may be delistedGot error from yahoo api for ticker ARGO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ARGO PR A: No timezone found, symbol may be delisted\n",
      "\n",
      "Got error from yahoo api for ticker TRTN PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTN PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GNL PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GNL PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FHN PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FHN PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRTX PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTX PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker INN PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- INN PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NYCB PR U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NYCB PR U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FRT PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker WEL.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WEL.U: No timezone found, symbol may be delisted\n",
      "- FRT PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLOP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLOP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SBXC.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SBXC.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PEB PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PEB PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CIM PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CIM PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ATCO PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ATCO PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SEAL PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SEAL PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WBS PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WBS PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ADC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ADC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TNP PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker EQC PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EQC PR D: No timezone found, symbol may be delisted\n",
      "- TNP PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WBS PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WBS PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMRE PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMRE PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DRH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker PSA PR O, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR O: No timezone found, symbol may be delisted\n",
      "- DRH PR A: No timezone found, symbol may be delisted\n",
      "OPA: No data found, symbol may be delistedGot error from yahoo api for ticker CTA PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CTA PR B: No timezone found, symbol may be delisted\n",
      "\n",
      "Got error from yahoo api for ticker TWO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker GDV PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GDV PR K: No timezone found, symbol may be delisted\n",
      "- TWO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ACR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "BHG: No data found, symbol may be delisted\n",
      "- ACR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BOH PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BOH PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CFR PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CFR PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EPR PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EPR PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSEC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker GSL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GSL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AMH PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSEC PR A: No timezone found, symbol may be delisted\n",
      "- AMH PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ABR PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ABR PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EFC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EFC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PMT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PMT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DX PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DX PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MITT PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MITT PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AMH PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AMH PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HFRO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HFRO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker IVR PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- IVR PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMRE PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMRE PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker KIM PR N, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- KIM PR N: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FHN PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FHN PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMRE PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMRE PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EPR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EPR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FHN PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FHN PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CLDT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CLDT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CODI PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CODI PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CODI PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CODI PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CODI PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CODI PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SHO PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SHO PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CSR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker EFC PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CSR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ACR PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EFC PR B: No timezone found, symbol may be delisted\n",
      "- ACR PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BFS PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BFS PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GNL PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GNL PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EFC PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EFC PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EPR PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EPR PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker COF PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- COF PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RIV PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RIV PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PEB PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PEB PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NCZ PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NCZ PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GNL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GNL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NCV PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NCV PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PSA PR Q, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PSA PR Q: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker LXP PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- LXP PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLOP PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLOP PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GAB PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GAB PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MITT PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MITT PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TRTN PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TRTN PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CUBI PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CUBI PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RC PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RC PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BML PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BML PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SB PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SB PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GAB PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GAB PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BW PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BW PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SHO PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SHO PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CIO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker RJF PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RJF PR B: No timezone found, symbol may be delisted\n",
      "- CIO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker INN PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- INN PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ASB PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ASB PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GMRE PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GMRE PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLP PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLP PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLOP PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLOP PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DLNG PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DLNG PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AGM PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AGM PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker REXR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- REXR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FHN PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FHN PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GTN.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GTN.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ICR PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ICR PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DSX PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DSX PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SRG PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SRG PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker REXR PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- REXR PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CHMI PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CHMI PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RWT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RWT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CTO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CTO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CDR PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CDR PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CUBI PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CUBI PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker DLNG PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- DLNG PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MAA PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MAA PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GAB PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GAB PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SPE PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPE PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NXDT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NXDT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NGL PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NGL PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EDI, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker SPG PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- SPG PR J: No timezone found, symbol may be delisted\n",
      "- EDI: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMRE PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMRE PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker OPP PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- OPP PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker FHN PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- FHN PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MDV PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MDV PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker LFT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker GUT PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- LFT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GDV PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GDV PR H: No timezone found, symbol may be delisted\n",
      "- GUT PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TCOA.U, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TCOA.U: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GRBK PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GRBK PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GGT PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GGT PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GGT PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GGT PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CHMI PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CHMI PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BHR PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BHR PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NREF PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker RMPL PR, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RMPL PR: No timezone found, symbol may be delisted\n",
      "- NREF PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HVT.A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HVT.A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MITT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MITT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker OPP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- OPP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker XFLT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- XFLT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ACP PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ACP PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CTA PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CTA PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GDL PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GDL PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ETI PR, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ETI PR: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker TY PR, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- TY PR: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ALTG PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ALTG PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR J, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR J: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CMS PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CMS PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR K, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR K: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BHR PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BHR PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker EFC PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- EFC PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GNT PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GNT PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHT PR G, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHT PR G: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker PRIF PR L, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- PRIF PR L: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CDR PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CDR PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker ECC PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- ECC PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHT PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHT PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker SB PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "Got error from yahoo api for ticker AHT PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHT PR H: No timezone found, symbol may be delisted\n",
      "- SB PR C: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHT PR I, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHT PR I: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker AHT PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- AHT PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker IIPR PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- IIPR PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker HL PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- HL PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker RC PR C, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- RC PR C: No timezone found, symbol may be delistedGot error from yahoo api for ticker EFC PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "\n",
      "- EFC PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BFS PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BFS PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GLOG PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GLOG PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BC PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BC PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker BC PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- BC PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CELG RT, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CELG RT: No timezone found, symbol may be delisted\n",
      "EAI: No data found for this date range, symbol may be delisted\n",
      "Got error from yahoo api for ticker WRB PR E, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WRB PR E: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WRB PR F, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WRB PR F: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker CNO PR A, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- CNO PR A: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker WRB PR H, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- WRB PR H: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker GL PR D, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- GL PR D: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker NSA PR B, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- NSA PR B: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker MMM WD, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- MMM WD: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker 8729.T, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- 8729.T: No timezone found, symbol may be delisted\n",
      "167A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "Got error from yahoo api for ticker 94345.T, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- 94345.T: No timezone found, symbol may be delisted\n",
      "Got error from yahoo api for ticker 25935.T, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- 25935.T: No timezone found, symbol may be delisted\n",
      "166A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "Got error from yahoo api for ticker 3171.T, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- 3171.T: No timezone found, symbol may be delisted\n",
      "153A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "6797.T: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "156A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "155A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "157A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "6192.T: No data found, symbol may be delisted\n",
      "7899.T: No data found, symbol may be delisted\n",
      "2402.T: No data found, symbol may be delisted\n",
      "171A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "6576.T: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "172A.T: Data doesn't exist for startDate = 1514732400, endDate = 1711551600\n",
      "160A.T: Period '1mo' is invalid, must be one of ['1d', '5d']\n",
      "Got error from yahoo api for ticker 000662.SZ, Error: {'code': 'Not Found', 'description': 'No data found, symbol may be delisted'}\n",
      "- 000662.SZ: No timezone found, symbol may be delisted\n"
     ]
    }
   ],
   "source": [
    "nasdaq_data = get_all_data(stock_list)\n",
    "TSE_data = get_all_data(TSE_stocks)\n",
    "SZSE_data = get_all_data(SZSE_stocks)\n",
    "sse_data = get_all_data(sse_stocks)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7f11137b-3c53-42a0-aae1-9a06389fed7b",
   "metadata": {},
   "source": [
    "### Data Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "be458d5b-e61e-4efc-82be-b51f99926230",
   "metadata": {},
   "outputs": [],
   "source": [
    "columns = [\"Open00\",'Open06', 'Open12', 'Open18', 'Open24', 'Open30',\n",
    "              \"High00\",'High06', 'High12', 'High18', 'High24', 'High30',\n",
    "               \"Low00\",'Low06', 'Low12','Low18', 'Low24', 'Low30',\n",
    "              \"Close00\",'Close06', 'Close12', 'Close18', 'Close24', 'Close30',\n",
    "               \"Volume00\",'Volume06', 'Volume12', 'Volume18', 'Volume24', 'Volume30']\n",
    "\n",
    "def get_check_data(data):\n",
    "    data_length = data[\"Stock_\"].value_counts().reset_index()\n",
    "    data = data[data[\"Stock_\"].isin(data_length[data_length[\"Stock_\"] >= 1000].iloc[:, 0].values)].reset_index(drop = True)\n",
    "    data[\"Date\"] = data[\"Date\"].astype(str)\n",
    "    date_ = [data[\"Date\"][i][:10] for i in range(data.shape[0])]\n",
    "    data[\"Date\"] = date_\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "3bea989d-a11a-4de9-9634-0bacb2e3849f",
   "metadata": {},
   "outputs": [],
   "source": [
    "nasdaq_data2 = get_check_data(nasdaq_data)\n",
    "TSE_data2    = get_check_data(TSE_data)\n",
    "SZSE_data2   = get_check_data(SZSE_data)\n",
    "sse_data2    = get_check_data(sse_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "bd3e82e5-3162-4c5e-969e-3656cdb0ca77",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nasdaq data shape:  (6311889, 38)\n",
      "tse data shape:  (4972029, 38)\n",
      "szse data shape:  (2214980, 38)\n",
      "sse data shape:  (1666886, 38)\n"
     ]
    }
   ],
   "source": [
    "print(\"nasdaq data shape: \", nasdaq_data2.shape)\n",
    "print(\"tse data shape: \", TSE_data2.shape)\n",
    "print(\"szse data shape: \", SZSE_data2.shape)\n",
    "print(\"sse data shape: \", sse_data2.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b8a511af-03a8-406c-a4cf-5b79d0b92e34",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Encoding \n",
    "# Date (We will update)\n",
    "# Sector "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "99a08b6e-b53c-4954-8b04-e4ea1b8c1cc4",
   "metadata": {},
   "outputs": [],
   "source": [
    "def date_encoder_fun(data):\n",
    "    date_encoder = LabelEncoder()\n",
    "    date_encoder.fit(data[\"Date\"].unique())\n",
    "    data[\"Date_index\"] = date_encoder.transform(data[\"Date\"])\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d61eca56-ba78-42f6-8cc2-69ca8c67bd2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "TSE_date    = date_encoder_fun(TSE_data2)\n",
    "NASDAQ_date = date_encoder_fun(nasdaq_data2)\n",
    "SZSE_date   = date_encoder_fun(SZSE_data2)\n",
    "SSE_date    = date_encoder_fun(sse_data2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5062fb94-d2e0-4fd1-9b94-354afaff2dfd",
   "metadata": {},
   "outputs": [],
   "source": [
    "def sector_encoder_fun(data):\n",
    "    date_encoder = LabelEncoder()\n",
    "    date_encoder.fit(data[\"IndustryCode_\"].unique())\n",
    "    data[\"Sector\"] = date_encoder.transform(data[\"IndustryCode_\"])\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "75761475-fd8d-4cd7-8688-0546021e1301",
   "metadata": {},
   "outputs": [],
   "source": [
    "TSE     =   sector_encoder_fun(TSE_date)\n",
    "NASDAQ = sector_encoder_fun(NASDAQ_date)\n",
    "SZSE    = sector_encoder_fun(SZSE_date)\n",
    "SSE    = sector_encoder_fun(SSE_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e2b21e47-5d34-459a-900d-bb440d51be43",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] <= \"2023-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] > \"2023-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5046e6fa-a380-4873-b0bc-e67fe9d297fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1c896dcb-f01f-470e-bbdb-4bc902c51af7",
   "metadata": {},
   "source": [
    "#### data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b2511a13-cc09-4818-89a1-4542f8ce4b94",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2022-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2022-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2022_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2022_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "21359117-c637-458e-b357-ba20ec9161bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c5295423-c422-4cf0-8a18-68b76892ba25",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2021-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2021-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2021_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2021_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "153fa42a-0731-47d4-85b7-2063112bc3a2",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "797018db-705d-49f1-81c6-e36a85de9deb",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2020-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2020-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2020_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2020_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f596cc8c-84d7-4ed1-b4b5-5e77a3ec9622",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "bd5327f9-753e-4a0a-a2bc-31fd9f7fff52",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2019-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2019-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2019_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2019_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "666379b2-1303-4800-b0a0-0bfb7e1fdc00",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aad3c722-e793-4c1d-9083-d3b56118588e",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2018-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2018-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2018_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2018_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d4d5f736-0aaf-4e20-9849-24a87093574a",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "035842ff-f0e8-4a7e-b4b8-0b865ce071a1",
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_train_test_split(data, is_save = False, is_norm = True, name = None):\n",
    "    \n",
    "    train = data[data[\"Date\"] < \"2023-01-01\"].reset_index(drop = True)\n",
    "    test = data[data[\"Date\"] >= \"2023-01-01\"].reset_index(drop = True)\n",
    "    \n",
    "    if is_norm == True:\n",
    "        scaler = StandardScaler()\n",
    "        normalized_column = scaler.fit_transform(train[columns])\n",
    "        train[columns] = normalized_column\n",
    "        test[columns] = scaler.transform(test[columns])\n",
    "    else:\n",
    "        pass\n",
    "    \n",
    "    if is_save:\n",
    "        train.to_csv(\"./data_ex_fund/train_2023_{}.csv\".format(name), index = False)\n",
    "        test.to_csv(\"./data_ex_fund/test_2023_{}.csv\".format(name), index = False)\n",
    "    else:\n",
    "        return train, test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a18c19d2-1c12-46ab-ba6d-5bd59a8eef4d",
   "metadata": {},
   "outputs": [],
   "source": [
    "get_train_test_split(NASDAQ, is_save = True, is_norm = True,name = \"nasdaq\")\n",
    "get_train_test_split(TSE, is_save = True, is_norm = True, name = \"tse\")\n",
    "get_train_test_split(SZSE, is_save = True,is_norm = True,name =  \"szse\")\n",
    "get_train_test_split(SSE, is_save = True, is_norm = True, name = \"sse\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c6c9759e-108c-4b7d-b105-b2a552290be6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f55a7b82-aee6-437a-9048-4ca34e580991",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b80f4977-486f-47b4-a46a-07a6e6ea7b62",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "937aa202-2511-4588-9ea9-0543bfd21e1f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3d858155-5449-4d7b-a3e0-ad62ce91ab4d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aff3a3f3-fed6-412b-a059-80e2e512d320",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "687972d8-c011-478c-9069-5aa5e6cf50cf",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "bigcon",
   "language": "python",
   "name": "bigcon"
  },
  "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.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}