aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--docs/process.rst17
1 files changed, 13 insertions, 4 deletions
diff --git a/docs/process.rst b/docs/process.rst
index 36dbd0d3..f3b5f015 100644
--- a/docs/process.rst
+++ b/docs/process.rst
@@ -30,14 +30,22 @@ We first create a directory called ``data/Indicative_%Y-%m-%d``.
From the spreadsheet, this is driven by the two shortcuts
``CTRL+Shift+Y`` and ``CTRL+Shift+G``.
+* In Intex Options, under Miscellaneous, Change the export settings to
+ "Tab delimited"
* First select the cusips of interest, do ``CTRL+Shift+Y`` and paste them
into a new portfolio tab in intex. On the portfolio tab itself,
right click, then Export to text, and save into ``data/Indicative_%Y-%m-%d``.
The intex filename should be called ``Portfolio.txt`` or ``Portfolio(i).txt``
for some ``i``.
+* If the deal is not in our database (i.e. new 2.0 deal),
+ "CTRL+Shift+Y" and "CTRL+Shift+G" will not work on the new deals.
+ Manually type in the deal name in the above process and manually
+ type in the CUSIPs in the process below when you get All Tranches
+ info.
* Then in the Collat Detail tab, make sure Asset Detail is
- toggled. Right click, then Export to text, All bonds and extract the
- resulting zip file into a folder named ``data/Collaterals_%Y-%m-%d``
+ toggled. "Show Summary Statistics" is toggled OFF. Right click, then
+ Export to text, All bonds and extract the resulting zip file into a
+ folder named ``data/Collaterals_%Y-%m-%d``
* Last step, select the cusips again, do ``CTRL+SHIFT+G``, paste into a
new portfolio tab. Click on All Tranches, Right Click, Export to
text, and save the file into a folder named ``data/Indicative_%Y-%m-%d``.
@@ -77,8 +85,9 @@ Running the scenarios in Intex
"Tab delimited"
* Select the cusips of interest on the spreadsheet (make sure the
corresponding sss files exist), do ``CTRL+Shift+I`` and paste them
- into a new portfolio tab in Intex... twice so that Intex actually
- paste the data.
+ into a new portfolio tab in Intex... A new improvement of Intex is
+ that the "SSS Forecast" column can not be pasted in directly, so
+ paste it into a spreadsheet first and copy/paste column by column.
* Then go onto the Scenarios Tab, and click the cross next to Rate
Update to make sure it reloads the Interest Rates (otherwise intex
will run it with libor set at 0... not good)