notebook.community

Edit and run 





In [15]:



    


import requests
import pandas as pd
url = 'http://192.168.5.4:8808/bds/"%s"/"DVD_HIST"/{}'

ticker = 'IF IM Equity'
print(url%ticker)
res = requests.get(url%ticker).json()

res = pd.read_json(res)
print(res)
res['ex_date'] = pd.to_datetime(res['Ex-Date'], unit='s')
good = res.loc[res.ex_date>'2018-09-17']



    


















    






http://192.168.5.4:8808/bds/"IF IM Equity"/"DVD_HIST"/{}
            Dividend Amount Dividend Frequency Dividend Type     Ex-Date  \
2002-03-22         0.049903             Annual  Regular Cash  1020643200   
2003-04-15         0.058710             Annual  Regular Cash  1050969600   
2004-05-04         0.058710             Annual  Regular Cash  1083542400   
2005-03-03         0.082193             Annual  Regular Cash  1114992000   
2006-03-29         0.171621             Annual  Regular Cash  1147046400   
2007-03-16         0.171621             Annual  Regular Cash  1179100800   
2008-03-04         0.214527             Annual  Regular Cash  1208736000   
2009-02-26         0.214527             Annual  Regular Cash  1240185600   
2010-03-19         0.085811             Annual  Regular Cash  1272844800   
2011-03-07         0.058421             Annual  Regular Cash  1304899200   
2012-03-22         0.250000             Annual  Regular Cash  1336348800   
2013-03-06         0.370000             Annual  Regular Cash  1367798400   
2014-03-06         0.570000             Annual  Regular Cash  1398643200   
2015-02-18         0.660000             Annual  Regular Cash  1428883200   
2016-02-02         0.760000             Annual  Regular Cash  1459209600   
2017-02-09         0.820000             Annual  Regular Cash  1493683200   
2018-03-06         1.000000             Annual  Regular Cash  1524441600   

            Payable Date  Record Date  
2002-03-22    1020902400   1020384000  
2003-04-15    1051228800   1050537600  
2004-05-04    1083801600   1083283200  
2005-03-03    1115251200   1114732800  
2006-03-29    1147305600   1146787200  
2007-03-16    1179360000   1178841600  
2008-03-04    1208995200   1208476800  
2009-02-26    1240444800   1239926400  
2010-03-19    1273104000   1272585600  
2011-03-07    1305158400   1304640000  
2012-03-22    1336608000   1336521600  
2013-03-06    1368057600   1367971200  
2014-03-06    1398988800   1398816000  
2015-02-18    1429056000   1428969600  
2016-02-02    1459382400   1459296000  
2017-02-09    1493856000   1493769600  
2018-03-06    1524614400   1524528000  

















In [31]:



    


def dvd(ticker: str, date: str="2018-09-17"):
    """"""
    url = 'http://192.168.5.4:8808/bds/"%s"/"DVD_HIST"/{}'
    print(url%ticker)
    res = requests.get(url%ticker)
    print(res)
    res = pd.read_json(res.json())
    res['ex_date'] = pd.to_datetime(res['Ex-Date'], unit='s')
    good = res.loc[res.ex_date>'2018-09-17']

    return good['Dividend Amount']



    











In [32]:



    


ceft = {
"BFZ US Equity": 27.10122249388753,
"BNY US Equity": 28.100957095709575,
"CEV US Equity": 30.110951526032316,
"EVM US Equity": 34.134768611670026,
"IEF US Equity": -33.06648375594295,
"JRS US Equity": 33.670010111223455,
"LQD US Equity": -16.048483198044863,
"MVT US Equity": 25.114910313901344,
"MYJ US Equity": 26.11970791698693,
"NKG US Equity": 31.09597260273973,
"NKX US Equity": 26.101156250000003,
"NRK US Equity": 28.10473282442748
}
pir = {
"AMP IM Equity": 5.035382231404959,
"AST IM Equity": 33,dvd
"BSS IM Equity": 2.0210314465408805,
"BST IM Equity": 31.151824817518246,
"CAI IM Equity": 18.481354838709677,
"DIB IM Equity": 6,
"ELC IM Equity": 28,
"ELN IM Equity": 3.042225663716814,
"FKR IM Equity": 33.75883248730965,
"GE IM Equity": 7.274716981132075,
"GIMA IM Equity": 4.109573770491804,
"IF IM Equity": 2.0624895222129087,
"IGD IM Equity": 8.559181909837246,
"IMA IM Equity": 1.0212278145695364,
"IP IM Equity": 3.0228930817610067,
"LD IM Equity": 4.08695652173913,
"LR IM Equity": 44,
"MN IM Equity": 32,
"MTV IM Equity": 11,
"PRI IM Equity": 2.0218555377207066,
"PRT IM Equity": 16.496537467700257,
"REY IM Equity": 1.006507718696398,
"SO IM Equity": 17,
"TIP IM Equity": 12.139509202453988,
"UNIR IM Equity": 5.383656387665199
}



    


















    






  File "<ipython-input-32-3884afb92cec>", line 18
    "BSS IM Equity": 2.0210314465408805,
                  ^
SyntaxError: invalid syntax

















In [33]:



    


tickers = list(ceft.keys()) + list(pir.keys())
print(tickers)



    


















    






['NRK US Equity', 'JRS US Equity', 'MYJ US Equity', 'LQD US Equity', 'MVT US Equity', 'BNY US Equity', 'IEF US Equity', 'CEV US Equity', 'NKG US Equity', 'EVM US Equity', 'BFZ US Equity', 'NKX US Equity', 'GE IM Equity', 'AST IM Equity', 'LR IM Equity', 'FKR IM Equity', 'DIB IM Equity', 'MTV IM Equity', 'IMA IM Equity', 'IF IM Equity', 'PRT IM Equity', 'ELN IM Equity', 'IGD IM Equity', 'TIP IM Equity', 'UNIR IM Equity', 'AMP IM Equity', 'LD IM Equity', 'SO IM Equity', 'BSS IM Equity', 'IP IM Equity', 'MN IM Equity', 'REY IM Equity', 'PRI IM Equity', 'ELC IM Equity', 'CAI IM Equity', 'BST IM Equity', 'GIMA IM Equity']

















In [35]:



    


# download
for t in tickers:
    print(t)
    try:
        res = dvd(t)
        print(res)
    except:
        print('Failed')



    


















    






NRK US Equity
http://192.168.5.4:8808/bds/"NRK US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
JRS US Equity
http://192.168.5.4:8808/bds/"JRS US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
MYJ US Equity
http://192.168.5.4:8808/bds/"MYJ US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
LQD US Equity
http://192.168.5.4:8808/bds/"LQD US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
MVT US Equity
http://192.168.5.4:8808/bds/"MVT US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
BNY US Equity
http://192.168.5.4:8808/bds/"BNY US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
IEF US Equity
http://192.168.5.4:8808/bds/"IEF US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
CEV US Equity
http://192.168.5.4:8808/bds/"CEV US Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
NKG US Equity
http://192.168.5.4:8808/bds/"NKG US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
EVM US Equity
http://192.168.5.4:8808/bds/"EVM US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
BFZ US Equity
http://192.168.5.4:8808/bds/"BFZ US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
NKX US Equity
http://192.168.5.4:8808/bds/"NKX US Equity"/"DVD_HIST"/{}
<Response [500]>
Failed
GE IM Equity
http://192.168.5.4:8808/bds/"GE IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
AST IM Equity
http://192.168.5.4:8808/bds/"AST IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
LR IM Equity
http://192.168.5.4:8808/bds/"LR IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
FKR IM Equity
http://192.168.5.4:8808/bds/"FKR IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
DIB IM Equity
http://192.168.5.4:8808/bds/"DIB IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
MTV IM Equity
http://192.168.5.4:8808/bds/"MTV IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
IMA IM Equity
http://192.168.5.4:8808/bds/"IMA IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
IF IM Equity
http://192.168.5.4:8808/bds/"IF IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
PRT IM Equity
http://192.168.5.4:8808/bds/"PRT IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
ELN IM Equity
http://192.168.5.4:8808/bds/"ELN IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
IGD IM Equity
http://192.168.5.4:8808/bds/"IGD IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
TIP IM Equity
http://192.168.5.4:8808/bds/"TIP IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
UNIR IM Equity
http://192.168.5.4:8808/bds/"UNIR IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: int64)
AMP IM Equity
http://192.168.5.4:8808/bds/"AMP IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
LD IM Equity
http://192.168.5.4:8808/bds/"LD IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
SO IM Equity
http://192.168.5.4:8808/bds/"SO IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
BSS IM Equity
http://192.168.5.4:8808/bds/"BSS IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
IP IM Equity
http://192.168.5.4:8808/bds/"IP IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
MN IM Equity
http://192.168.5.4:8808/bds/"MN IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
REY IM Equity
http://192.168.5.4:8808/bds/"REY IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
PRI IM Equity
http://192.168.5.4:8808/bds/"PRI IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
ELC IM Equity
http://192.168.5.4:8808/bds/"ELC IM Equity"/"DVD_HIST"/{}
<Response [200]>
Failed
CAI IM Equity
http://192.168.5.4:8808/bds/"CAI IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
BST IM Equity
http://192.168.5.4:8808/bds/"BST IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)
GIMA IM Equity
http://192.168.5.4:8808/bds/"GIMA IM Equity"/"DVD_HIST"/{}
<Response [200]>
Series([], Name: Dividend Amount, dtype: float64)

















In [ ]:

Content source: wangzhe3224/notebook

Similar notebooks:

notebook.community | gallery | about