@@muks095 Glad you some value out of these. Thanks for kind remarks.

Plan to revisit Bert again and showcase some R Finance libraries. Excel however will soon be more integrated with python. See announcement from Microsoft support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d and Google Colab (using gspread) may be come a sort of back engine for Googlesheets saturncloud.io/blog/how-to-read-data-from-google-sheets-using-colaboratory-google/ Javascript in googlesheets is not well suited for numerically intensive estimations but coupled with Google Colab googlesheets can become very powerful and I hope to move a bit in that direction i.e. get the most out of googlesheets by using google colab high end mathematical libraries with access to gpu and tpu. That would mean we should be able to fire up a tonne of processing power in the cloud. It also means means that R libraries run on Google Colab can be integrated into googlesheets sites.google.com/view/vinegarhill-datalabs/data-transformation-and-visualization/tidyverse-r#h.yhlp738t1ddy

@BrianByrneFinance hi manymany thanks for informative reply and bert is not running as i think it's dead

Thanks for the kind words! It's great to hear that you're incorporating those early financial intuitions into your courses. Bachelier is a classic for options, but De La Vega adds such an interesting historical layer, especially with his insights on speculative behavior. Glad you found the Python code useful-you might also find this short paper from Herve Dumez a palatable read for finance students annales.org/gc/GC-english-language-online-edition/2015/DUMEZ.pdf . Also another historical account of option trading that makes reference to the Dutch www.sfu.ca/~poitras/heinz_%24%24.pdf Confusions of Confusions can be found here archive.org/details/ned-kbn-all-00002508-001/mode/2up best, Brian

@@BrianByrneFinance I only taught for a few years part-time. Way retired now but I try to keep in touch and I really love your videos and resources. I am just astounded that you don't have a bigger following on YT: your material is in my opinion the best I have come across on this platform, especially as the additional resources are really generous. I think I once told you in another comment that a good portion of the material is beyond my grasp, but I always learn something useful. So thank you for extra references above. I have already downloaded Confusions of Confusions. I'll have a look at the others. Thank you again Brian.

It’s really heartbreaking to see how inflation and recession impact low-income families. The cost of living keeps rising, and many struggle just to meet basic needs, let alone save or invest. It’s a reminder of the importance of finding ways to create financial opportunities. You've helped me a lot sir Robert! Imagine i invested $50,000 and received $190,500 after 14 days

Absolutely! Profits are possible, especially now, but complex transactions should be handled by experienced market professionals.

Some persons think inves'tin is all about buying stocks; I think going into the stock market without a good experience is a big risk, that's why I'm lucky to have seen someone like mr Robert L Cox.

Finding yourself a good broker is as same as finding a good wife, which you go less stress, you get just enough with so much little effort at things

Cox demonstrates an excellent understanding of market trends, making well informed decisions that leads to consistent profit

Thanks Vega, In education and building learning tools for professionals in the finance sector. best, Brian

Thanks for your question! I haven’t broken into using Rust for market feeds yet, but it’s definitely a promising technology I plan to explore in the future. Rust’s speed, memory safety, and strong support for asynchronous programming make it ideal for handling real-time market data. I hope to come up to speed on it soon and share insights as I learn.

@@MichaelFlynn0 I believe you can Michael. I have run colab from smart phones. All the processing is in the cloud.

Hi @ranjithramachandran8009, Thank you for the great suggestion! JAX with lax.scan could be an interesting approach for iterative computations like option pricing, especially with GPU acceleration. As you noted, JAX may not always outperform Numba on CPU-bound tasks, but it’s worth testing. I’ll consider exploring this comparison in a future video-thanks again for your thoughtful input! best, Brian

Numba can be set up to use GPUs; you get the speedup benefits if you have to value lots of contracts is my understanding. I'v been running this code with the Intel SVML/fastmath=true Numba parameters and the speed is ridiculously fast. It really is amazing.

@@laurentbouchard1448 Dear Laurent, Do you have a colab link to that? If so could you share? best, Brian

Make sure vba code is in the same excel spreadsheet

@@BrianByrneFinance I found a way round by inserting the inputing the figures (from stock price to the number of runs) in the bracket of the 'equation' separated by commas. Now I simply have a tabulated format and refer the cells in the 'equation'. Many thanks for the VBA and the series of videos.

Brian, please ignore the above message as I found the second video

Second video is on the vinegar hill portal

More to come!

@@BrianByrneFinance I can't wait!

Great suggestion!

www.google.ie/books/edition/Python_Guide_for_Introductory_Econometri/BLiqDwAAQBAJ?hl=en&gbpv=1&dq=chris%20brooks%20econometrics&pg=PT9&printsec=frontcover

Glad you liked it!

are you trading calendars?

What happened?

Glad you enjoyed it!

No unfortunately and if you get a good source can you post. I think there is a bit of interest in that. The numpy library in python has become extremely optimised for multi dimensional arrays.

The owner passed away. But his vba book is still published by Wiley.

@@BrianByrneFinance What happened to his repositories or codes on volopta? They were really good!.

@@BrianByrneFinance What´s the name of his VBA Book?

www.amazon.co.uk/Option-Pricing-Volatility-Excel-VBA-Finance/dp/0471794643

you could try run code snippets in google colab kzbin.info/www/bejne/aWiolaiklKt2oZo then troubleshoot through chatgpt line by line

@@BrianByrneFinance How do you install QuantLib in C++?

@@BrianByrneFinance I'm trying to install QuantLib in Visual Studio 2022. But, it doesn't work.

Owners of American options may exercise at any time before the option expires. European options can only be exercised at expiration. Most equity options are American-style options, but many broad-based equity indices have actively traded European-style options, including the S&P 500. Short dated American options will have values close to European. The advantage of early exercise in greater for longer dated instruments

@@BrianByrneFinance Thanks a lot!

The owner passed away and the host dropped the content a year or two later. Tragic every which way

No but in the Espen Haug text book there is a monte carlo approach used to model the value of a financial contract based on multiple underlying. This would be not be a lattice approach.

Thank you for letting me know. I had glanced at Espen Haug's book a while back. Seemed quite useful then.

Could use the source code for yfinance if you wanted a bit more control

No - only for contemporaneous data.

It seems to be one of the better python notebooks

You may need to pip install wooldridge

pip install pandas-profiling thank you for suggestion

www-2.rotman.utoronto.ca/~hull/ofod/index.html. Please check this website

@@BrianByrneFinance Thanks a ton for sharing this!

sites.google.com/view/vinegarhill-financelabs/binomial-lattice-framework/tian-1993

Check a bit down the portal page

The model needs a volatility input but you could use 0.00001 perhaps

Glad you enjoy it!

If you look closer you do find that formula works out the same. You divide and divide again which is like multiplying.

@@BrianByrneFinance makes sense, thank you

You might try to use chatgpt to write the code. Feed it a sample of your data with labels and ask it to generate code for classification.

@@BrianByrneFinance will try that, And also do we have to normalize the data with the code or manually in the dataset

yes normalize@@gds231

@@BrianByrneFinance how??

subtract mean and divide by standard deviation or use sklearn@@gds231

sites.google.com/view/vinegarhill-financelabs/monte-carlo