Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: xlwings UDF showing name error
Post: RE: xlwings UDF showing name error

(May-29-2020, 06:31 AM)buran Wrote: maybe I got it wrong... I was under impression you cut part of the traceback in the first psot No, that was the full error message that appeared on Excel. I'm not...
pwt General Coding Help 9 5,039 May-29-2020, 07:09 AM
    Thread: xlwings UDF showing name error
Post: RE: xlwings UDF showing name error

Silly question but how do I get the full long traceback?
pwt General Coding Help 9 5,039 May-29-2020, 06:28 AM
    Thread: xlwings UDF showing name error
Post: RE: xlwings UDF showing name error

(May-29-2020, 05:08 AM)buran Wrote: installing mibian does not install scipy. Frankly, it's poorly written in many aspects. however your other code was working, right? did you change something mibia...
pwt General Coding Help 9 5,039 May-29-2020, 05:18 AM
    Thread: xlwings UDF showing name error
Post: RE: xlwings UDF showing name error

Thanks for the quick response. I thought I have mibian already installed. How do I check if mibian or scipy is installed or not? I'm using Spyder (Python 3.7) btw.
pwt General Coding Help 9 5,039 May-29-2020, 04:56 AM
    Thread: xlwings UDF showing name error
Post: xlwings UDF showing name error

Hi, I'm trying to write a simple UDF using xlwings. Note that I don't have much experience with Python. The Python code that I'm trying to call via xlwings is: import xlwings as xw import mibian @...
pwt General Coding Help 9 5,039 May-29-2020, 04:34 AM
    Thread: How to create an Excel app that runs Python?
Post: RE: How to create an Excel app that runs Python?

Have you managed to resolve your issue? Just wondering what you ended up doing as I am trying to find a similar approach.
pwt General Coding Help 3 2,285 May-28-2020, 10:30 PM
    Thread: Finance: Black Scholes Model not working
Post: RE: Finance: Black Scholes Model not working

(May-27-2020, 07:35 AM)buran Wrote: shouldn't you using historical volatility, not implied volatility? Both volatilities can be use, depending on what the user is trying to achieve. In my case, I wa...
pwt General Coding Help 5 3,937 May-27-2020, 07:58 AM
    Thread: Finance: Black Scholes Model not working
Post: RE: Finance: Black Scholes Model not working

(May-27-2020, 05:40 AM)buran Wrote: you don't pass argument for volatility. So default value is None It needs volatility [to be evaluated True] to calculate rest Duh! You're right. I should pass the...
pwt General Coding Help 5 3,937 May-27-2020, 06:21 AM
    Thread: Finance: Black Scholes Model not working
Post: Finance: Black Scholes Model not working

Hi, I'm trying to learn Python and is only my second day learning the code. At the moment, I'm trying to use the Mibian library to do some simple options pricing. I've written this simple code to d...
pwt General Coding Help 5 3,937 May-27-2020, 05:27 AM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020