Melt Up & Melt Down Financial Investment Tracking Program

Wanted an expert MS Excel programmer to provide following items: 1. A Preliminary Layout Flowchart & initial design of an Excel workbook that is macro enabled to perform the following within various subroutines within the said workbook: i. Download & extract & store individual listed stock information such as: Certain Portfolio Daily stock costs and other information such as: ii. High and Low yearly stock prices iii. Return on Equity iv. Stock symbol v. Company Name vi. Stock Price vii. Last Price Change viii. %Currency Market ix. Time Volume Shares x. Average Vol (3m) Day xi. Range52-Wk xii. Range Day b. Market Capitalization c. Return on Equity d. Stock symbol e. Company Name f. Stock Price g. Last Price Change h. %Currency Market i. Time Volume Shares j. Average Vol (3m)Day k. Price Range52-Wk Hi & Low l. Range within a given Day’s trading m. Market Capitalization n. 2. initial test portfolio will contain approximately 150 individual stocks a. Later expansion of the workbook will cover approx.8000 individual stocks. b. Once stored the data will be used to compute 10, 20 & 30 % values for calculating trailing stops for the individual stocks in the given portfolio. The stops will be fed into the actual portfolio held at a broker and used to provide specific selling points for the individual stocks should a down turn in the monitored stocks occur. c. Should prices of the individual stocks rise, the subroutine would re-compute new trailing stop prices to provide new (higher) selling prices for the Certain Portfolio Daily stock costs and other information such as: d. Said Expert programmer will provide the workbook and all data only after a multiple set of actual trials that will be performed by the person who is purchasing the programming work. e. Programmer must sign an individual confidentiality agreement assigning all rights to all versions of the code and also provide copies of the coding installed on MS Excel 2016 version to the Owner. 3. Please quote hourly rate to accomplish all objectives and timing to provide all intermediary steps and also to achieve the final code & delivery to the Owner as specified above