Add the values of an online table into a excel Cell

Topic

New Reply

Hi all,

With reference to the below table:

http://www.nseindia.com/products/dynaContent/equities/equities/histscrip.jsp?symbolCode=234&symbol=TATASTEEL&symbol=TATASTEEL&segmentLink=3&symbolCount=1&series=ALL&dateRange=week&fromDate=+&toDate=+&dataType=PRICEVOLUMEDELIVERABLE

I wish to get the sum of values of the column “Total Traded Quantity” & column “Turnover in Lacs” into an excel file.

The following values only change in the url “Symbolcode” and “symbol” for getting various tables.
we shall input in excel these values.

Attaching herewith excel file for better understanding
thanks
bhushan shah

Reply | Quote

Replies

Hi all,

With reference to the below table:

http://www.nseindia.com/products/dynaContent/equities/equities/histscrip.jsp?symbolCode=234&symbol=TATASTEEL&symbol=TATASTEEL&segmentLink=3&symbolCount=1&series=ALL&dateRange=week&fromDate=+&toDate=+&dataType=PRICEVOLUMEDELIVERABLE

I wish to get the sum of values of the column “Total Traded Quantity” & column “Turnover in Lacs” into an excel file.

The following values only change for the tables
Attaching herewith excel file for better understanding
thanks
bhushan shah

Reply | Quote