Fetching portfolio data into excel

[KINNARI_1220921]

Hello Experts,
Wish to get the Portfolio positions data (almost realtime, if possible) from upsotx into excel

[KINNARI_1220921]

@Chaitanya_Kalyani - saw your many posts regarding this… can you please help?

[Ketan]

Excel based trading API

If you wish to integrate data from Upstox API into your spreadsheet, you’ll need to rely on Excel’s native features, such as Web queries, VBA, or Power Query (Get & Transform Data). These tools allow you to fetch the required data from API (in this case Upstox API) and seamlessly incorporate it into your Excel spreadsheet.

[KINNARI_1220921]

Thanks Ketan for the reply…
Can you suggest the Excel’s webquery, VBA, or Power Query (Get & Transform Data)to login and retrieve just the F&O current positions?

Regards,

Ravin Kayasth