Deliverable % EOD

Celina · July 31, 2021, 4:39am

any pointers if I can pull % DLY qty to traded qty from google sheet.

I can pull OHLC, vol, but DLY qty.
And how is it calculated ?

Thanks.

jashjacob · July 31, 2021, 5:42am

Delivery % Data is available with NSE. Cannot be calculated from any inputs.
You can parse the Delivery Data Column on NSE page with python.

Celina · July 31, 2021, 5:45am

hey thanks. but I am illiterate with programming language.

just can pull around with google sheets or excel.

jashjacob · July 31, 2021, 5:47am

How are you pulling data with Google Sheets, are you using Google Finance API?

Celina · July 31, 2021, 5:51am

yes, google finance.

jashjacob · July 31, 2021, 5:58am

As far as I know, there is no way to fetch delivery % with GOOGLE Finance as the API does not have that specific function.

There is no way to calculate it either as the Delivery % is dynamic which is released by NSE by end of the day… You may have to download that data as .csv and match it with scrip.