What is the difference between using Pi Bridge and using Kite Connect? From what I understand is that Pi Bridge is used to send alerts in Pi, whereas using Kite Connect we can directly trigger orders, am I right? Is Kite Connect fully automatic trading system?
Technically everything is possible.
You cannot connect PiBridge from google sheets directly.
You need to setup a server and receive order details from Google Spreadsheets and pass that to PiBridge on the Server in turn PiBridge will pass that details to Pi as Alerts.
Instead, You can use Excel Sheet in Local PC/Laptop.Is there any specific reason to use Google Spreadsheets…?
You can use Link to Excel Feature of Pi…
This will give you real time quotes that is 10x faster than what you get in Google Spreadsheets.
and available for all segments/exchanges.
Thanks for that suggestion, but I have already tried that. The limitation here is that I can load only 50 stocks per market watch. I want all F&O stocks, for which I have to create 5 different MW and corresponding 5 different excels. Also, I do not get historical data. Is there a solution here?