Data collection update tool
Please add features to existing data collection tool
Step1: Read ticker name in column A1 on excel sheet (see image : step 1)
Step 2: save value in variable “ticker”
Step 3: enter “ticker” into link: [login to view URL]
Step 4: collect “yield” data (see image : step Print “yield” data in cell J1
step 5: collect net profit margin Quarter value and print in cell K1 ie 3.36, collect net profit margin Annual value and print in cell L1 ie 3.68.
Step6: collect operating profit margin Quarter value and print in cell M1 ie 5.37, collect operating profit margin Annual value and print in cell N1 ie 5.94.
step 7: collect return on average equity Quarter value and print in cell O1 ie 20.23, collect return on average equity Annual value and print in cell P1 ie 22.55.
Step 8: enter “ticker” into link: [login to view URL]
Step 9: collect “Total Debt” data , Print “Total Debt” data in cell Q1
Shift entire spreadsheet data one row downward so that a title row can be added in row1.
I will label the columns with titles myself