|
»Spread for ASP.NET
» Product Tour
» Excel Compatibility
|
|
jump to:
|
|
Excel Compatibility |
|
You can import data from and export data and formatting to Microsoft Excel in
its native format, both individual spreadsheets and entire workbooks. You can
save data to an Excel-formatted (BIFF8 format) file or stream. There are
several SaveExcel methods each with several options. For instance, you can
specify whether headers are saved with the data using the setting of the
IncludeHeaders enumeration. You do not need Excel on the server for Spread to
display your Excel files.
If you have Excel installed on your computer, click on the following button to
download the below Spread file and view it in Excel:
| | A | B | C | D | E | F | G |
| 1 | Risk-free rate | | 6.0% | | Market variance | | 3.0% |
| 2 | Market rate | | 15.0% | | Maximum weight | | 100.0% |
| 3 | | | | | | | |
| 4 | | Beta | ResVar | | Weight | *Beta | *Var. |
| 5 | Stock A | 0.80 | 0.04 | | 20.0% | 0.160 | 0.002 |
| 6 | Stock B | 1.00 | 0.20 | | 20.0% | 0.200 | 0.008 |
| 7 | Stock C | 1.80 | 0.12 | | 20.0% | 0.360 | 0.005 |
| 8 | Stock D | 2.20 | 0.40 | | 20.0% | 0.440 | 0.016 |
| 9 | T-bills | 0.00 | 0.00 | | 20.0% | 0.000 | 0.000 |
| 10 | | | | | | | |
| 11 | Total | | | | 100.0% | 1.160 | 0.030 |
| 12 | | | | | Return | | Variance |
| 13 | | | Portfolio Totals: | | 16.4% | | 7.1% |
| 14 | | | | | | | |
| 15 | | | | | | | |
| 16 | | | | | | | |
| 17 | | | | | | | |
| 18 | | | | v | | | |
|
|