aboutsummaryrefslogtreecommitdiffstats
path: root/python/report_ops/misc.py
blob: 0d5a5c8c17c4787baa6dadd0c0dadb6ba8786ad5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
import pathlib
import datetime
from serenitas.utils.env import DAILY_DIR

_recipients = {
    "ISOSEL": (
        "luke.treacy@innocap.com",
        "margincalls@innocapglobal.com",
    ),
    "BOWDST": (
        "shkumar@sscinc.com",
        "mbisoye@sscinc.com",
        "hedgemark.lmcg.ops@sscinc.com",
        "PRIM-Ops@innocap.com",
        "Hedgemark.OTC@sscinc.com",
    ),
    "SERCGMAST": (
        "SERENITAS.FA@sscinc.com",
        "SERENITAS.ops@sscinc.com",
    ),
    "BAML_FCM": ("footc_margin_csr_amrs@bofa.com",),
    "GS_FCM": (
        "Susan.Olesky@ny.email.gs.com",
        "Divyanshi.Girotra@gs.com",
        "gs-margin-calls-dcs@ny.email.gs.com",
        "PRIM-Ops@innocap.com",
    ),
    "NYOPS": ("nyops@lmcg.com",),
    "UMB": ("lmcgcustody@umb.com",),
}

_sma_recipients = {
    "ISOSEL": (
        "BCI-Ops@innocap.com",
        "Vera.Dvorski@innocap.com",
        "Diana.WuChen@innocap.com",
    ),
    "BOWDST": (
        "PRIM-Ops@innocap.com",
        "Vera.Dvorski@innocap.com",
        "Diana.WuChen@innocap.com",
    ),
    "BRINKER": ("CSG.Team.Armata@bbh.com",),
}

_monthend_nav_recipients = {
    "BOWDST": _recipients["BOWDST"]
    + (
        "Hedgemark.FA@sscinc.com",
        "PRIM-Acctg@innocap.com",
        "catherine.porter@innocap.com",
        "Meghana.shroff@innocap.com",
    ),
}

_settlement_recipients = {
    "BOWDST": _sma_recipients["BOWDST"],
    "SERCGMAST": (
        "lmcgcustody@umb.com",
        "serenitas.ops@sscinc.com",
    ),
    "ISOSEL": ("derivatives_settlements@citco.com",),
    "BRINKER": ("nyops@lmcg.com",),
}

_valuation_recipients = {
    "SERCGMAST": ("Serenitas.Vals@sscinc.com",),
    "BOWDST": (
        "prim.vals@sscinc.com",
        "AJeeva@sscinc.com",
    ),
    "ISOSEL": ("BHu@citco.com", "zzCFSDubPricing2@citco.com"),
}

_cc_recipients = {
    "ISOSEL": ("selene-ops@lmcg.com",),
    "BOWDST": ("bowdoin-ops@lmcg.com",),
    "SERCGMAST": ("nyops@lmcg.com",),
    "BRINKER": ("nyops@lmcg.com",),
}

_fund_custodians = {
    "SERCGMAST": ("UMB",),
    "ISOSEL": (
        "NT",
        "SCOTIA",
    ),
    "BOWDST": ("BNY",),
}


def get_dir(
    workdate: datetime.date = datetime.date.today(), archived=True
) -> pathlib.Path:
    p = DAILY_DIR / str(workdate) / "Reports"
    if not p.exists() and archived:
        p = (
            DAILY_DIR
            / str(workdate.year)
            / f"{workdate:%Y_%m}"
            / str(workdate)
            / "Reports"
        )
    return p


def dt_from_fname(f, dt_format="%Y%m%d%H%M"):
    return datetime.datetime.strptime(
        f.name.removesuffix(".csv").removesuffix(".xlsx").rsplit("_")[-1], dt_format
    )


def dt_from_citco(filename, file_tag, dt_format):
    return datetime.datetime.strptime(
        filename.removesuffix(".csv").removeprefix(file_tag), dt_format
    )