Data Transfer Specialist for Financial Data for 2021 -- 2
Budget: $35 – $36 USD
This jon is being reposted because the previous worker collected the wrong table.
We need someone to copy down 63 company tables from a website:
1- go to https://www.chittorgarh.com/report/ipo_basis_of_allotment_list/7/mainline/
2- Select the year 2021 (only that year). Alphabetically, the first company should be Aditya Birla Sun Life AMC Ltd.
3- There will be a list of company names, such as Antony Waste Handling Cell Ltd. Click on it.
4- Find the basis of the allotment table. The table has a fairly stable structure. Usually, the first column is called the category, and the second column is Applications or the number of applications.
An example table is this:
Category No. of Applications No. of Equity Shares applied Shares Reserved as per Prospectus No. of times Subscribed Amount (Rs)
-------------------------------------------------------------------
Qualified Institutions Bidders (excluding Anchor Investors) 97 101511600 1848323 54.92 75626142000
Non-Institutional Investors 639 183317080 924160 198.36 1.36571E+11
Retail Individual Investors 281152 6440400 616107 10.45 47989
Total 281888 291269080 3388590 85.96 2.16996E+11
Copy the values into the attached tab-separated text file (use Excel or another spreadsheet application to edit the file). The numbers are Indian, that is, sometimes they are given as 10.25.123.000 with dots in two decimals, which look strange in English. Please write them down as they look and do not even change typos (sometimes they are given with mistakes such as 10.,25.000)
The main thing to know is that sometimes column names are a bit confusing, for example, the EquitySharesReserved column appears as "Shares Reserved as per Prospectus" or "Shared reserves" etc. Sometimes the shared reserves column does not exist in the table. In that case, leave it blank.
We need someone to copy down 63 company tables from a website:
1- go to https://www.chittorgarh.com/report/ipo_basis_of_allotment_list/7/mainline/
2- Select the year 2021 (only that year). Alphabetically, the first company should be Aditya Birla Sun Life AMC Ltd.
3- There will be a list of company names, such as Antony Waste Handling Cell Ltd. Click on it.
4- Find the basis of the allotment table. The table has a fairly stable structure. Usually, the first column is called the category, and the second column is Applications or the number of applications.
An example table is this:
Category No. of Applications No. of Equity Shares applied Shares Reserved as per Prospectus No. of times Subscribed Amount (Rs)
-------------------------------------------------------------------
Qualified Institutions Bidders (excluding Anchor Investors) 97 101511600 1848323 54.92 75626142000
Non-Institutional Investors 639 183317080 924160 198.36 1.36571E+11
Retail Individual Investors 281152 6440400 616107 10.45 47989
Total 281888 291269080 3388590 85.96 2.16996E+11
Copy the values into the attached tab-separated text file (use Excel or another spreadsheet application to edit the file). The numbers are Indian, that is, sometimes they are given as 10.25.123.000 with dots in two decimals, which look strange in English. Please write them down as they look and do not even change typos (sometimes they are given with mistakes such as 10.,25.000)
The main thing to know is that sometimes column names are a bit confusing, for example, the EquitySharesReserved column appears as "Shares Reserved as per Prospectus" or "Shared reserves" etc. Sometimes the shared reserves column does not exist in the table. In that case, leave it blank.