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
117
118
119
120
121
|
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",),
"NY_CREW": (
"fyu@lmcg.com",
"ghorel@lmcg.com",
"etsui@lmcg.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
)
|