Here is a synopsis :
1. Obtain data from a web query.
[url removed, login to view] the web query value ( just one numerical value ) and add it to a numerical column list. This value and column list need to update every hour.
[url removed, login to view] the column list ( with newly added web query value ) and obtain descriptive statistics from it via a macro.
4. With the descriptive statistics obtained, take the mean and standard deviation and perform several other calculations also via the macro.
5. There are several other steps .....ie...obtain frequencies from bin limits,
calculate percent frequency and cumulative percent frequency again, via the macro. I can provide more detail upon interest.
20 freelancers are bidding on average $17/hour for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hello, I have read your requirements and I believe with my experience I can offer you the quality services you need. Please consider me for this job. BR, [login to view URL]
I am not a random bidder. Please ping me if you are happy with my proposal and I would be glad to provide you my best service. Please provide more details and Thank you. Will show you the video demo of the work.
Hello, client . i read your requirement carefully and have a thinking of can do it. i think you should use web scraping. having a solid expereience in scraping and excel macro, can satisfy u. thanks. Gerogy