yes. today i searched and found that google sheets provide writing app scripts. let this thread be open. if i find good solutions i will share the details here. Thanks
i just tried out https://github.com/mrjbq7/ta-lib
using RSI lib from this works fine. i could even plot candles and RSI in plotly and crosscheck with kite chart
I calculated RSI with this lib for period of 14. but when i compared with values plotted in kite page, the values are different. is there any calculation difference between this lib and the calculation that kite follows?