Skip to content

C# VSTO Excel Workbook Add-in that creates new worksheets that show a table of stock option prices and the potential profits for various scenarios. This requires an API key to access the TD Ameritrade API (for fetching option chains), and Thinkorswim (for live updates). TD evidently no longer has the $500,000 account requirement for the API.

License

Notifications You must be signed in to change notification settings

viras34/StockAnalyzerWB

 
 

Repository files navigation

StockAnalyzerWB

C# Excel Workbook Add-in that creates new worksheets that show a table of stock option prices and the potential profits and ROI for various scenarios.

It pulls in the option data for a specified stock and specified option expiration dates. If you have ThinkOrSwim running (provided by TD Ameritrade) then the option prices will be updated in real time.

This now requires TD Ameritrade API's, because Yahoo finance stopped providing stock tables. So to use this you will need to register as a developer at TD Ameritrade.

How to Install:

1.Register to create a Developer Account at https://developer.tdameritrade.com/ .

  1. Register an app there to get your "OAuth User ID".

  2. Edit "publish\Application Files\StockAnalyzerWB_1_1_0_1\AuthData.txt.deploy" in notepad, and put your "OAuth User ID" on the first line of the file (by itself).

  3. run "publish\setup.exe"

About

C# VSTO Excel Workbook Add-in that creates new worksheets that show a table of stock option prices and the potential profits for various scenarios. This requires an API key to access the TD Ameritrade API (for fetching option chains), and Thinkorswim (for live updates). TD evidently no longer has the $500,000 account requirement for the API.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 100.0%