search

VarunS2002 / Python-NSE-Option-Chain-Analyzer

The NSE has a website which displays the option chain in near real-time. This program retrieves this data from the NSE site and then generates useful analysis of the Option Chain for the specified Index or Stock. It also continuously refreshes the Option Chain and visually displays the trend in various indicators useful for Technical Analysis.
GNU General Public License v3.0
390 stars 205 forks source link

TypeError: Sheet.insert_row() got an unexpected keyword argument 'values' #67

Closed akashj87 closed 3 weeks ago

akashj87 commented 3 weeks ago

after doing tksheet version 6.3.5, following error is resolved but new errror is appearing

[2024-06-13 11:11:11 - INFO ] ----------Logging Started---------- [2024-06-13 11:11:11 - INFO ] Windows 10 .py version 5.5 [2024-06-13 11:11:29 - ERROR] [2024-06-13 11:11:29 - ERROR] Warning (from warnings module): [2024-06-13 11:11:29 - ERROR] File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1454 [2024-06-13 11:11:29 - ERROR] int_put_oi_2: int = int(entire_oc.iloc[i, [20]][0]) [2024-06-13 11:11:29 - ERROR] FutureWarning: Series.getitem treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use ser.iloc[pos] [2024-06-13 11:11:29 - ERROR] Exception in Tkinter callback [2024-06-13 11:11:29 - ERROR] Traceback (most recent call last): File "C:\Python\Lib\tkinter__init.py", line 1967, in call [2024-06-13 11:11:29 - ERROR] return self.func(*args) [2024-06-13 11:11:29 - ERROR] ^^^^^^^^^^^^^^^^ File "C:\Python\Lib\tkinter\init__.py", line 861, in callit [2024-06-13 11:11:29 - ERROR] func(*args) File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1536, in main [2024-06-13 11:11:29 - ERROR] self.set_values() File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1282, in set_values [2024-06-13 11:11:29 - ERROR] self.sheet.insert_row(values=output_values, add_columns=True) TypeError: Sheet.insert_row() got an unexpected keyword argument 'values'

===========================================================

line 1409 [2024-06-13 11:27:28 - ERROR] int_call_oi: int = int(entire_oc.iloc[i, [0]][0]) [2024-06-13 11:27:28 - ERROR] FutureWarning: Series.getitem treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use ser.iloc[pos] [2024-06-13 11:27:28 - ERROR] [2024-06-13 11:27:28 - ERROR] Warning (from warnings module): [2024-06-13 11:27:28 - ERROR] File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1417 [2024-06-13 11:27:28 - ERROR] int_put_oi: int = int(entire_oc.iloc[i, [20]][0]) [2024-06-13 11:27:28 - ERROR] FutureWarning: Series.getitem treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use ser.iloc[pos] [2024-06-13 11:27:28 - ERROR] [2024-06-13 11:27:28 - ERROR] Warning (from warnings module): [2024-06-13 11:27:28 - ERROR] File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1446 [2024-06-13 11:27:28 - ERROR] int_call_oi_2: int = int(entire_oc.iloc[i, [0]][0]) [2024-06-13 11:27:28 - ERROR] FutureWarning: Series.getitem treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use ser.iloc[pos] [2024-06-13 11:27:28 - ERROR] [2024-06-13 11:27:28 - ERROR] Warning (from warnings module): [2024-06-13 11:27:28 - ERROR] File "C:\Users\akash\Documents\Python-NSE-Option-Chain-Analyzer-5.5\NSE_Option_Chain_Analyzer.py", line 1454 [2024-06-13 11:27:28 - ERROR] int_put_oi_2: int = int(entire_oc.iloc[i, [20]][0]) [2024-06-13 11:27:28 - ERROR] FutureWarning: Series.getitem treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use ser.iloc[pos]

VarunS2002 commented 3 weeks ago

Duplicate of #64 Workaround is to revert tksheet version to 6.3.5