eToro Datamine

eToro Datamine Walton Street Web Design is looking for someone to create a system that datamines eToro.com. Please carefully READ the entire following work spec before providing your quote. We are a web development company in the United States, and if you do a good job here then we will likely have more work for you. You will be given a cPanel Linux server on which to do the dev with access to a mySQL database. Please also let us know what language you will program this system in. No Microsoft languages - software must run on linux sever. The system will require a very minimal front end with NO graphic design required and NO mobile capability required - it must only be functional. 1. Home page: -List of all portfolios in alphabetical order, linked to portfolio detail page. Next to each portfolio is also a delete button, which will have a Javascript (JS) confirm if you really want to delete it - if you hit delete it deletes the portfolio along with all associated data. -Add portfolio function - form with a name field to add a new portfolio, URL field for the eToro URL. Here are some sample eToro portfolio URL's: [login to view URL], [login to view URL], [login to view URL] 2. Portfolio Mine logic: -A cron job will run every day at 0500 UTC time that will update ALL portfolios with the latest data. -Each portfolio detail page will have a "Mine Now" button that will update only that specific portfolio with the latest data from eToro. -If you click on one of the eToro sample links, click the filter on the right side and hit "Stocks". We will ONLY be mining stocks and ETF's. All other types should be ignored and never mined. -Now in the mine, the system will go through the portfolio page and mine the data from EACH stock or ETF. For example, go to [login to view URL] then a stock on there is MU, which is located at [login to view URL] For EACH position we are going to capture the following data: -Symbol (MU) -Full Name (Micron Technology Inc) -Position (BUY or SELL, but in the system call it LONG for BUY, and SHORT for SELL), each position must be captured unless it's a duplicate date, MU has multiple positions for example -Each date of the Buy or Sell, so for example MU has dates 14/12/2017, 12/01/2018, etc... The dates from eToro are in DD/MM/YYYY format, but we will store all dates in MM/DD/YYYY format. If you have duplicate dates we do not need to make duplicate entries, one entry from each date is sufficient. -SL Value -TP Value 3. Portfolio Detail page: Here shall be a single table of ALL the positions in this portfolio. ALL of the stocks/ETF's will be presented in a single table, ordered by date starting with oldest going to newest. Table shall have columns: -Symbol -Full Name -Date -Position -SL -TP Below the table will be the following options: -Export as CSV - Will export the Symbol, Full Name, Date, and Position columns to a CSV file - you will be provided a CSV template for formatting. -Datamine Now - Triggers a datamine for this set only right now. Page will reload upon completion of datamine. -Delete and Exclude Symbol - This will be a form with an input field called "Symbol". When a symbol is entered here, ANY data in this portfolio for that symbol will be deleted. Furthermore, below this form will be a table called "Excluded Symbols" - this table shall store all the symbols that were excluded. Any symbol that is on this exclusion list in the future will NOT be datamined for this portfolio only (if system runs across this symbol in eToro, the symbol will simply be ignored). Next to each symbol will be a "Remove" button that removes the symbol from the exclusion list.