{% extends "hedge/base.html" %}
{% load hedge_extras %}
{% block title %}Market data{% endblock %}
{% block content %}
<h1>Market data</h1>
<div class="grid2">
<section class="card"><h2>Spot rate</h2><form method="post" class="row">{% csrf_token %}<input type="hidden" name="form" value="spot">
<label>Date<input type="date" name="date" value="{{ today|date:'Y-m-d' }}" required></label><label>Currency<input name="currency" size="4" maxlength="3" required></label><label>Rate (functional per foreign)<input name="rate" required></label><button class="btn">Save</button></form></section>
<section class="card"><h2>Curve point</h2><form method="post" class="row">{% csrf_token %}<input type="hidden" name="form" value="curve">
<label>Date<input type="date" name="date" value="{{ today|date:'Y-m-d' }}" required></label><label>Currency<input name="currency" size="4" maxlength="3" required></label><label>Tenor days<input name="tenor_days" size="5" required></label>
<label>Rate %<input name="rate_pct" size="6"></label><label>Fwd points<input name="points" size="7"></label><button class="btn">Save</button></form>
<p class="muted">Quoted forward points take precedence over interest-rate parity for a currency when present.</p></section>
</div>
<section class="card"><h2>Import CSV</h2>
<p class="muted">Detected from the header: <code>date,currency,spot</code> &middot; <code>date,currency,tenor_days,rate</code> (percent) &middot; <code>date,currency,tenor_days,points</code>.</p>
<form method="post" enctype="multipart/form-data" class="stack">{% csrf_token %}<input type="file" name="csv_file" accept=".csv"><textarea name="csv" rows="4" placeholder="or paste CSV here"></textarea><button class="btn">Import</button></form></section>
<div class="grid3">
<section class="card"><h2>Latest spots</h2><table><tbody>{% for s in spots %}<tr><td>{{ s.date }}</td><td>{{ s.currency }}</td><td class="r">{{ s.rate|num:4 }}</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Latest rates</h2><table><tbody>{% for s in rates %}<tr><td>{{ s.date }}</td><td>{{ s.currency }}</td><td>{{ s.tenor_days }}d</td><td class="r">{{ s.rate_pct|num:2 }}%</td></tr>{% endfor %}</tbody></table></section>
<section class="card"><h2>Latest forward points</h2><table><tbody>{% for s in points %}<tr><td>{{ s.date }}</td><td>{{ s.currency }}</td><td>{{ s.tenor_days }}d</td><td class="r">{{ s.points|num:4 }}</td></tr>{% endfor %}</tbody></table></section>
</div>
{% endblock %}