import pandas as pd
from swap_pricing import RateCurve
import QuantLib as ql
import pilar_rates as pr

#Eikon Stuff
import eikon as ek  # the Eikon Python wrapper package
import configparser as cp

import os
os.environ["HTTPX_LOG_LEVEL"] = "trace"
ek.set_log_level(1)

cfg = cp.ConfigParser()
cfg.read(u'eikon.cfg')  # adjust for different file location
ek.set_app_key(cfg['eikon']['app_id'])
cfg = cp.ConfigParser()
cfg.read(u'eikon.cfg')  # adjust for different file location
ek.set_app_key(cfg['eikon']['app_id'])
2020-10-22 07:57:28,650 P[30444] [MainThread 12052] Reset a Desktop session with new app_key
2020-10-22 07:57:28,654 P[30444] [MainThread 12052] Unlock login_event for streaming session 0 due to stop streaming call
2020-10-22 07:57:28,660 P[30444] [MainThread 12052] Send GET request to http://127.0.0.1:9060/api/status to detect API Proxy...
2020-10-22 07:57:28,664 P[30444] [MainThread 12052] Request to http://127.0.0.1:9060/api/status
	headers = {'x-tr-applicationid': 'xxx'}
	params = None
2020-10-22 07:57:28,676 P[30444] [MainThread 12052] HTTP request response 200: {"statusCode":"ST_PROXY_READY","version":"2.6.3"}
2020-10-22 07:57:28,680 P[30444] [MainThread 12052] Checking port 9060 response : 200 - {"statusCode":"ST_PROXY_READY","version":"2.6.3"}
2020-10-22 07:57:28,684 P[30444] [MainThread 12052] Port 9060 was retrieved from .portInUse file
2020-10-22 07:57:28,689 P[30444] [MainThread 12052] Try to handshake on url http://127.0.0.1:9060/api/handshake...
2020-10-22 07:57:28,694 P[30444] [MainThread 12052] Request to http://127.0.0.1:9060/api/handshake
	headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'xxx'}
	params = None
2020-10-22 07:57:28,865 P[30444] [MainThread 12052] HTTP request response 500: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:28,868 P[30444] [MainThread 12052] Response : 500 - {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:28,872 P[30444] [MainThread 12052] Response 500 on handshake port 9060 : {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:28,875 P[30444] [MainThread 12052] Application ID: xxx
2020-10-22 07:57:28,879 P[30444] [MainThread 12052] Init a Desktop session with new app_key
2020-10-22 07:57:28,882 P[30444] [MainThread 12052] Port 9060 on local proxy was detected


2020-10-22 07:57:38,428 P[30444] [MainThread 12052] entity: DataGrid_StandardAsync
2020-10-22 07:57:38,432 P[30444] [MainThread 12052] payload: {'requests': [{'instruments': ['CAD='], 'fields': [{'name': 'TR.AMERICACLOSEBIDPRICE.date'}, {'name': 'TR.AMERICACLOSEBIDPRICE'}, {'name': 'OPEN_PRC'}], 'parameters': {'SDate': '2020-08-03', 'EDate': '2020-08-03', 'FRQ': 'D'}}]}
2020-10-22 07:57:38,434 P[30444] [MainThread 12052] Request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'instruments': ['CAD='], 'fields': [{'name': 'TR.AMERICACLOSEBIDPRICE.date'}, {'name': 'TR.AMERICACLOSEBIDPRICE'}, {'name': 'OPEN_PRC'}], 'parameters': {'SDate': '2020-08-03', 'EDate': '2020-08-03', 'FRQ': 'D'}}]}}}
2020-10-22 07:57:38,438 P[30444] [MainThread 12052] Request to http://127.0.0.1:9060/api/v1/data
	headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'xxx'}
	params = None
2020-10-22 07:57:38,612 P[30444] [MainThread 12052] HTTP request response 500: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:38,615 P[30444] [MainThread 12052] HTTP Response code: 500
2020-10-22 07:57:38,619 P[30444] [MainThread 12052] HTTP Response: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:38,622 P[30444] [MainThread 12052] Headers: x_ratelimit_limit=None / x_ratelimit_remaining=None 
2020-10-22 07:57:38,625 P[30444] [MainThread 12052]          x_volumelimit_limit=None / x_volumelimit_remaining=None
2020-10-22 07:57:38,628 P[30444] [MainThread 12052]          retry_after 0
2020-10-22 07:57:38,631 P[30444] [MainThread 12052] Error code 500 | Server Error: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-22 07:57:38,633 P[30444] [MainThread 12052] HTTP request failed: EikonError-Server Error: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}