Devam Ediyor

491221 MS Excel data fetching

Please have a look at the attached files. the primary objective is to automate as much as possible in order to reduce human intervention. I shall now explain every bit of what I need to do, step my step.

1. Everyday, a 3rd party application downloads financial data in the form of a CSV file (refer to [url removed, login to view] attachment).

2. I save this file as [url removed, login to view] (as attached)

3. Now I fetch data from [url removed, login to view] into sample.xlsx.

At this point I need to clarify something. If you notice, you will find that A1 on [url removed, login to view] is filled with a formula =[url removed, login to view]!A1. However, when I make changes to the [url removed, login to view] file and save it, values on [url removed, login to view] are not updated. Please help me with the settings that need to be implemented in order to achieve this.

4. We now switch to the 'Daily' sheet on sample.xlsx. I need Excel to fetch the latest Open, High, Low and Close values for each ticker based on the dates available on the 'Data' sheet (i.e. the most recent day's data). Please note that the 'Data' sheet will always contain one year's data for each ticker.

5. We now switch to the 'Weekly' sheet on sample.xlsx. I need Excel to fetch the latest weekly Open, High, Low and Close values for each ticker based on the dates available on the 'Data' sheet (i.e. the most recent week's data). Please note that the 'Data' sheet will always contain one year's data for each ticker. At this point I should mention a few points:

Weekly OPEN means the OPEN value for the first day of the week.

Weekly CLOSE means the CLOSE value for the last day of the week.

Weekly HIGH means the Highest of all the HIGH values for the week.

Weekly LOW means the Lowest of all the LOW values for the week.

If there are holidays in a week, then weekly data should be calculated as per the days available within that particular calendar week. Usually there are 5 working days in a week. Dates from the next week should not be used to make up for holidays.

Programmer must implement the above and send me an updated file.

Project is quite simple and hence high bids will not be entertained.

Beceriler: Her şey Kabul, Veri Girişi, Excel, PHP

Daha fazlasını görün: primary data, make calendar excel, find excel programmer, excel sheet formula, excel help formula, need excel help, xlsx, save excel, MS excel, fetch data, excel formula, excel data sheet, excel automate, data point, data financial, php csv sample, php save data file, php excel csv, switch order, excel file order form, php file open save, point excel, application downloads, excel file data points, find excel project

İşveren Hakkında:
( 1 değerlendirme ) Kolkata, India

Proje NO: #2237132