real time alerts on discount to nav

can I get real time alerts whenever GBTC's discount to nav exceeds 20%? Ycharts seems to only do end of day for that. I saw GBTC's discount to nav move >10% intraday today.

 

You can do it in excel.

 

How do you get real time price quotes in excel for either GBTC or spot bitcoin?

 

nobody has free quotes except of the 15 minute delayed variety afaik. Is that what excel has?

 

Interactive brokers have an excel spreadsheet that you can modify to get real-time data in from TWS. Who is your broker?

 

who is your broker?

 

IB

 

http://interactivebrokers.github.io/#

Download the api and you will get the sample spreadsheet.

 

Wholly shait, I'm an IB customer, never knew this. THanks a ton ZBZB!!!