Create Stock Portfolio in Excel/Google Sheet, Part 3 - Pull Live Stock Price

Опубликовано: 03 Апрель 2026
на канале: Shine Vision

11,155

157

In this tutorial, We will show you how we can import Stock price(LTP) information in our sheet from any open site (Eg: NEPSE). NEPSE stock live site provides stock information in trading hours only, If you want to pull stock price at any time you can replace following site in P2

https://www.sharesansar.com/live-trading

Formula to import data: =IMPORTHTML(P2,"Table",1)

Formula to pull Company code: =INDEX('Listed Company'!C:C,Match(A2,'Listed Company'!E:E,0))

Formula to pull LTP in Data tab(NEPSE): =Index(LTP!C:C,Match(S2,LTP!B:B,0))

Formula to pull LTP in Data tab(Share Sansar): =iferror(Index(LTP!C:C,Match(S2,LTP!B:B,0)),100)

In latest version of google sheet, Script Editor menu has been moved to Extensions menu with new name App Scripts.

Formula to Pull Point change(NEPSE)

=Index(LTP!E:E,Match(S2,LTP!B:B,0))

Formula to Pull Point change(Share Sansar)

=iferror(Index(LTP!D:D,Match(S2,LTP!B:B,0)),0)

Don't forget to subscribe this channel for upcoming videos and comment your queries/feedback.