Python for Finance: Analyze Big Financial Data

comment Comment attached to cell hyperlink Hyperlink or email address as string object alignment Text/value al ...

clear Resets all properties/attributes of the cell copy_from Copies all properties/attributes from another cell co ...

performance might be an issue. Basically, performance is bound by Excel input/output (I/O) speed. The following ...

generate matplotlib plot nplt.figure(figsize=( 8 , 4 )) nplt.plot(Cell(“A2”).vertical, Cell(“C2”).vertical, label=‘AA ...

particular file — will then be directly callable from Excel. Consider the by now well- known function ...

Figure 12-7. Screenshot of Excel function dialog for Python function Although this function is not that ...

Figure 12-8. Screenshot of Excel with parameter grid for European option values Whereas in a previous ...

Figure 12-9. Screenshot of Excel with European option value surface plot ...

xlwings At the time of this writing, a new contender in the Python-Excel integration world has emerged: xl ...

Conclusions There are several options to integrate Python with Excel. Some Python libraries — like xlwt or x ...

Further Reading For all libraries and solutions presented in this chapter, there are helpful web resources ava ...

Chapter 13. Object Orientation and Graphical User Interfaces First, solve the problem. Then, write the code. — ...

Object Orientation Wikipedia provides the following definition for object-oriented programming: Object-oriented progra ...

We can also overwrite our initial values by simply assigning new values to the attributes: In [ 9 ]: c.a = 100 ...

In [ 22 ]: c = ExampleFive( 10 , 15 ) In [ 23 ]: c.addition() Out[23]: 25 In [ 24 ]: c.multiplication() Out[24]: ...

Calling the multiplication method, however, works as desired: In [ 37 ]: c.multiplication() Out[37]: 300 To conclu ...

Out[42]: Guido Henry Lilli ...

short rate over five years. The factors for t = 0 are all equal to 1; i.e., “no discounting” of today’ ...

To get discount factors from the new object, a time list with year fractions is needed: In [ 52 ]: time_ ...

opportunity costs of the investment, is positive. In our case, the NPV is simply the sum of the single present ...