aboutsummaryrefslogtreecommitdiffstats
path: root/python/report_ops/misc.py
blob: e1edb7f30ecca0aecf25e4983f093bec1bda4dba (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
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",
        "hm-operations@bnymellon.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",
        "hm-operations@bnymellon.com",
    ),
    "NYOPS": ("nyops@lmcg.com",),
    "UMB": ("lmcgcustody@umb.com",),
}

_sma_recipients = {
    "ISOSEL": (
        "HM-InnocapFunds@bnymellon.com",
        "Vera.Dvorski@bnymellon.com",
        "Diana.WuChen@bnymellon.com",
    ),
    "BOWDST": (
        "hm-operations@bnymellon.com",
        "Vera.Dvorski@bnymellon.com",
        "Diana.WuChen@bnymellon.com",
    ),
}

_settlement_recipients = {
    "BOWDST": _sma_recipients["BOWDST"],
    "SERCGMAST": ("lmcgcustody@umb.com",),
    "ISOSEL": ("derivative_settlements@citco.com",),
}

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


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
    )