Forum Discussion
Solved
Help with formulas based on criteria
I have a Stock Options workbook with several sheets and I'm looking for a formula that will draw info from some of the sheets into a Summary page. For instance, I have one sheet titled ProfitGrid wh...
Paladin1078 Yes, attachments are available not for all users. You may share your file on OneDrive, Google Drive, whatever. Give access to everyone and share the link.
It looks like you are Google Sheets since you use functions like QUERY(). File won't help a lot, opened in Excel it has a quite many errors.
It was originally a Google sheet that I exported over to Excel. As I stated it's a work in progress as I'm converting everything over to Excel. The LARGE majority of errors is because I deleted much of my personal trading history. But, each of the primary sheets such as Puts, Calls, Leaps, etc should work just fine as they have been converted over to work with Excel and with IBKR's API which is where the option quotes come from. It should at least give anyone who is experienced with Excel a good idea of where I'm trying to get to. The formula is pretty simple, I'm just not experienced enough to know what it is.