Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
3_a_2_dailymargin
by
harsh.v
381 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
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
編集
|
公開
|
公開の取り消し
|
URL
|
複製する
Contract Size (ounces)
100
Contracts (number)
2
Ounces under contract
200
Initial futures price
$600
Margin
Per
Total
Initial margin
$2,000
$4,000
Maintenance margin
$1,500
$3,000
Daily
Cum'l
Margin
Futures
gain
gain
Account
Margin
Price
(loss)
(loss)
Balance
call
Notes:
$600.00
$4,000
Exchange sets minimum levels for initial and maintenance margins
5-Jun
$597.00
($600)
($600)
$3,400
$0
The margin account is volatile: cash in excess of margin can be withdrawn
6-Jun
$596.10
($180)
($780)
$3,220
$0
This daily market-to-market creates CONVEXITY BIAS vis-à-vis forward contracts
7-Jun
$598.20
$420
($360)
$3,640
$0
Breach of maintenance margin requires MARGIN CALL: VARIATION MARGIN required to TOP UP TO INITIAL MARGIN
8-Jun
$597.10
($220)
($580)
$3,420
$0
9-Jun
$596.70
($80)
($660)
$3,340
$0
10-Jun
$595.40
($260)
($920)
$3,080
$0
11-Jun
$593.30
($420)
($1,340)
$2,660
$1,340
12-Jun
$593.60
$60
($1,280)
$4,060
$0
13-Jun
$591.80
($360)
($1,640)
$3,700
$0
14-Jun
$592.70
$180
($1,460)
$3,880
$0
15-Jun
$587.00
($1,140)
($2,600)
$2,740
$1,260
16-Jun
$587.00
$0
($2,600)
$4,000
$0
17-Jun
$588.10
$220
($2,380)
$4,220
$0
18-Jun
$588.70
$120
($2,260)
$4,340
$0
19-Jun
$591.00
$460
($1,800)
$4,800
$0
20-Jun
$592.30
$260
($1,540)
$5,060
$0
Dailiy Margin Hull Table 2_1
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More