How to get CMP in MS EXcel 2016?

Algos, strategies, code
1

I know google sheet and google finance formulas., but due to certain limitations need to use excel 2016.
Anyone tried getting CMP for NSE/BSE stocks? Kindly share.

2

@Hum_Sa
Check if below link helps

https://www.quora.com/How-do-I-fetch-BSE-NSE-data-for-my-excel-spreadsheet

3

Zerodha pi was a good one for the matter. Now it is phased out. Expecting Zerodha to give alternate solution.