aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dawn.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/dawn.sql')
-rw-r--r--sql/dawn.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 78e9ca8a..d4f095b1 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3254,7 +3254,7 @@ SELECT eo.id,
eo.expiration_date,
eo.strike,
eo.buysell,
- eo.notional * price
+ eo.notional * price * (2* buysell::integer -1.)
FROM equityoptions eo JOIN counterparties cps ON cp_code = code) ORDER BY trade_date DESC;
CREATE TABLE bond_tickets (