Excel power query sum columns jobs

...existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - extract SKUs from all categories if null), sub_category (optional - extract all SKUs from all subcategories if null), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of SKUs with the following columns (category, sub_category, brand, sku_name, description, competitor_name, datetime, location, url, nsp, psp, stock_count (if...

I need to transform the fashade of this building without altering its structural integrity. I was thinking to do something with the existing arches and i attach some photos for inspiration but ofcourse i am open to your creative suggestions We cannot alter openings (doors or windows) and we cannot remove any structual ellements i.e columns Please include your input for the garden and pavements etc... I have some more photos from drone if you think ot would be better This is the beginning of a large project for the renovation of a hotel so successful candidates will have the oportunity for allot more work... Thanks

...constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are added and finally sent to the customer. A second Excel file must also be created for production so that they know which parts are required for construction. 7. Synchronise article and customer master data between Majesty and Odoo. Majesty can only export the data using an Excel file and has no API. 8. Design customisation so that configurations that have already been made are collapsed, so that the page remains clearer due ...

IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracker Employee Attendance Tracker and Payroll Exce...

I'm looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. - Strong communication skills and a proactive approach to project management. I'...

...scheme -------------------------------------------------------------- Brand message: 1, brand consumer statistics analysis: age: 95% are 25 years old and above Income: 80% of the customers from the United States middle and high income families, Engel's coefficient must not be high, there are certain luxury goods and non-necessities of life spending power. Gender: 74% are female customers, 26% are male. Marital status: 83% of clients are married. Education: the educational level of the customers is high, 95% of them are above high school level, and about half of them can go to university and above. 2、Product use scenarios: in desktop, corridor, entrance hall, bathroom, corner, doorway, ...

I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel: The freelancer should have excellent skills in using Excel for data cleaning...

In need of a detailed-oriented freelancer for an alphanumeric data entry ...freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entry position will be...

I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you find are high quality and in either JPG or SVG formats. Your work will be integral in the creation...

for my online bookstore, I need: in admin part in order details need to add two columns and hide few other

I'm looking for a PowerBI expert to set up a dashboard for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - Resource Allocation: Demonstrating how resources a...

I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.

We are looking to collect the current prices for 5 specific procedures from local clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up on the caller ID. Start immediately. Pay is $250. Do not bid higher, as we will not...

I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.

Optimize Queries for Website Our website is slow and sometimes overloaded we assume it has to do with queries we work with MYSQL job will be 1 determine crucial queries 2 optimize them off application 3 find the code in application - this can be done more efficiently by myself 4 switch the new query with the old 5 test and deploy Please let me know whether suitable

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.

I'm looking for a professional who can assist me with organizing financial data in an Excel sheet. This organized data will be used for reporting purposes. Key Responsibilities: - Inputting and arranging financial data - Ensuring accuracy and consistency of data - Creating a well-structured Excel sheet for reporting Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail and accuracy - Understanding of financial data - Experience with creating reports from data The successful freelancer will need to have a keen eye for detail, as the accuracy and correctness of the data is crucial for its utilization in our reporting.

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I'm in need of an Excel database creation expert to help me establish a system to store and manage customer information. The project is time-sensitive, so I need someone who can get on it ASAP. Key Responsibilities: - Building an Excel database for customer information, possibly by using Chat GPT for data population - Ensuring the database is well-structured and easy to navigate for future reference - Implementing any necessary formulas or functions that can enhance the utility of the database - Ensuring the project is completed in a timely manner, as I need it done ASAP Ideal Skills: - Proficiency in Excel, with experience in database creation and management - Knowledge of using Chat GPT for data entry is a plus - Ability to structure data in a clear and organ...

I am on the lookout for a driven intern who is eager to manage a large volume of social media representation, and isn't afraid of achieving targets. You will be on a commission structure and stand to earn a significant sum - 15% per sale. with a guaranteed 5-star review at the end. POTENTIAL KEY TASKS: - Follow 7500 accounts on Instagram for 1000 accounts - Manage 1000 individual Instagram accounts The primary goal? I want to boost my product sales and I believe effective social media engagement is one way to achieve this. Ideally, you'll be a self-starter with prior experience managing multiple social media accounts and generating sales. An understanding of follower engagement practices on Instagram is critical. The knack to identify potential customers and the skil...

...for Performance Optimization: - Database Queries: The application has several database interactions that need to be optimized to reduce query times and enhance overall database performance. - Algorithm Efficiency: There are certain algorithms in the application that should be revisited and optimized for better performance. - Memory Management: The application currently faces memory management issues that need to be addressed to make it more efficient and less resource-intensive. Ideal skills and experience for this project include: - Strong C# development skills - Prior experience in refactoring and performance optimization - Understanding of database query optimization - Proficiency in algorithm analysis and optimization - Knowledge of memory management techniques in C# ...

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandable manner to industry professionals. - Excellent attention to detail. - Proact...

I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. I...

...three-pronged job involving: 1. Entering Contact Information: You will input a myriad of contact details into an Excel spreadsheet. Accuracy is paramount. 2. Updating Databases: You'll be responsible for ensuring that all existing data is up-to-date. If a discrepancy is noticed, you will correct it. 3. Transcribing Documents: Transcription services are required. You need to accurately transcribe information from diverse documents. In addition to the aforementioned tasks, this job involves email verification for all entries; without exception. Needless to say, your keen attention to detail would be required to spot and correct any errors. The ideal candidate would have past experience with Excel spreadsheets, database management, and transcription. Excellent typing ...

...analysis. Achieve monthly targets of 150 salons signed and 3,000 app downloads to qualify for performance bonuses. Provide real-time geolocation updates during field movements. Candidate Requirements: Minimum 2 years of experience in B2B sales, preferably within the beauty, wellness, or tech industries. Strong understanding of sales strategies and customer relationship management. Proficient in Excel and capable of managing basic sales data analysis. Exceptional communication and interpersonal skills. Ability to commit to BookBook's unique brand and sales approaches. Must be organized, self-motivated, and capable of working under pressure to meet sales targets. Compensation and Incentives: Monthly salary of £2,000 after taxes. Promising £4,000 compensation follow...

I'm seeking an expert to revise an annual financial model for a Saas Startup. The successful bidder will be tasked with modifying revenue projections, adjusting expense figures and adding new financial metrics. The final version of the model should be delivered as an Excel spreadsheet. This project requires deep knowledge of financial analysis, Excel forecasting tools and financial metrics. Familiarity with financial models and proven track record in creating or modifying them is essential.

I'm seeking a professional to help me enhance the visibility of my business on Google through the acquisition of genuine customer reviews. This project aims to leverage the power of positive feedback to increase the online presence and recognizability of my business. Key requirements: - A strategy to collect honest and high-quality reviews directly from my customers. - The ability to manage the review collection process effectively and ethically. - Experience in enhancing the visibility of businesses on Google through positive review campaigns. Ideal applicants will have a proven track record of successfully executing similar projects, and a deep understanding of the dynamics of online business reputation management. Your proposal should include a clear outline of your approa...

I'm looking for a professional who excels in PowerPoint presentations. The tasks primarily include creating comprehensive and engaging presentations. Additionally, I need someone with experience in branding strategy and lead generation targeted towards B2C (Business to Consumer). I have ideas I wrote on paper, I need someone to organize it and put it on power point. Key Responsibilities Include: -Ideation and creation of fascinating PowerPoint presentations -Developing a branding strategy Ideal Candidate: -An extraordinary creative mind with high-level proficiency in PowerPoint, including presentations’ creation. -Expertise in consumer market analysis, lead generation, and branding strategy. -Experience or understanding of the B2C industry -A proven track record of e...

...record includes creating and designing courses that resonate with diverse audiences, driving engagement and delivering tangible results. ⏰ **Timing Mastery**: You understand the importance of pacing and timing in course delivery. You'll orchestrate the flow of content to keep participants engaged and motivated every step of the way. ✍️ **Copywriting Skills**: Beyond just instructional design, you excel in crafting compelling copy that speaks to our target audience. Your words will inspire action and drive enrollment. ? **Quality Assurance**: Attention to detail is your middle name. You'll conduct thorough testing of the course materials to ensure seamless functionality and a superior learning experience. But that's not all! In addition to course creation, you&#...

I need a freelancer with a deep understanding of Excel ,data management and social media to extract info from profile list that we have . As the project involves organizing approximately 20,000 rows of data, proficiency in handling large datasets will get you far in this task. Key Project Details: - Data Type: The data primarily comprises email addresses and phone numbers. - Links in Profile - Other profiles in the profile - Formatting: The data files contain labels, so you'll need to distinguish this information keenly. Ideal Skills: - Proficient in Excel - Expertise in data management - Data Scraper

I need an expert with strong Excel skills to create two simple line graphs. Though I didn't provide specifics, these will be used to illustrate financial data, so experience in creating graphs for financial analysis would be ideal. Fast turnaround is critical. I will share 2 images of sample graphs. You need to put same data but have to create it line graph and in excel. I need this now. If you can't do now then please dont waste my time.

I require a professional who can develop a detailed sales forecasting report leveraging Power BI. The project needs to be done within one day. Key Requirements: - Utilize data from Excel spreadsheets for the forecasting. - The sales forecast should be detailed, breaking down sales by product/service. - The forecasting model should be based on regression analysis. Ideal Skills: - Proficiency in Power BI. - Strong experience in Excel data analysis. - Proven track record in regression analysis for sales forecasting. - Ability to work under tight deadlines.

I am in need of a Visual Basics code in Excel that specifically focuses on equipment check-in and check-out functionality, while also automatically creating a record for each transaction. Key Features: - Equipment Check-in and Check-out: The primary purpose of the program is to allow users to easily check equipment in and out. - Automatic Inventory Status Update: The program should update the inventory status automatically, ensuring that the availability of each item is always up to date. Additional Features: - Daily Reports: The program should generate daily check-in and check-out reports - this would be beneficial for managing equipment usage and tracking. - Statistics: The program should also provide statistics on equipment usage. This could help in determining patterns of usag...

Transferring data from a jpg file to an excel table. With online access via google

I'm looking for a Power BI expert to help me set up a robust sales forecasting system. Responsibilities: - Integrate my Excel spreadsheets into Power BI Desktop - Design visually appealing and intuitive dashboards that clearly display sales forecasts - Utilize Power BI's capabilities to predict sales trends Ideal Skills: - Proficiency in Power BI Desktop - Expertise in Excel spreadsheet integration - Proven track record in sales forecasting - Strong communication skills to understand my business and its sales forecasting needs This project requires someone who can not only set up the technical aspects but also has a deep understanding of sales forecasting.

I require an expert for systematic detailing of steel structures - including beams, columns, connections, bracings, and plates. The project will demand the execution of: • General arrangement drawings, • Fabrication drawings, • Erection drawings. Alongside the technical accuracy, I look forward to incorporating aesthetics while maintaining strength, stability, and functionality of the steel structures. Ideal candidates should have: • Proficiency in steel structures design and fabrication. • Adeptness in architectural aesthetics. • Acute attention to detail and practicality. This project requires a union of engineering acumen with an eye for aesthetics.

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me ...

I am in need of a Multiwave Oscillator that is specifically designed for healing and wellness purposes. This oscillator should have a low power output, up to 100 watts. Key Responsibilities: - Design a Multiwave Oscillator for healing and wellness purposes. - Ensure that the oscillator has a low power output, up to 100 watts. Ideal Skills and Experience: - Prior experience in designing and constructing Multiwave Oscillators. - Knowledge of low power electronics, especially in the range of up to 100 watts. - Understanding of the principles of healing and wellness technologies. I'm looking to have this product built (DIY Lakhovsky MWO (Milti Wave Oscollator) device, detailed informations, facts, analysis)

I am seeking a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project is to ob...

...schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. The budget is $25 to start but if it goes well will become full-time for 4 to 12 weeks. We have other areas outside London coming up as well. The final output should be a comprehensive Excel spreadsheet that includes the name and address of each school, along with their exact distance from the nearest Tube sta...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

...pressure range) suitable for the nRF52840 DK. Continuously collect pressure data from the sensors with low power consumption for extended battery life. Communicate pressure data wirelessly to a smartphone application via Bluetooth Low Energy (BLE). Allow for configuration and interaction with the pressure sensors through the mobile app (optional). Key Requirements: Expertise in nRF52840 DK development, including sensor interfacing, BLE communication, and low-power programming. Strong understanding of pressure sensor selection and integration for accurate and reliable pressure readings. Experience with mobile app development for BLE communication (Android or iOS) is a plus. Familiarity with power optimization techniques for extended battery life in embedded systems....

I am seeking experienced professionals in solar photovoltaic system installation. The goal of this project is to install a reliable system that can contribute heavily to clean energy generation, reduce electricity bills or act as a back-up power supply. Freelancers must be able to adapt to different needs as the type of property (home or commercial) they will be working on is currently undetermined. Ideal Skills and Experience: - Demonstrated knowledge in solar photovoltaic systems - Proven track record of successful installations - Strong problem-solving skills and adaptability Application Requirements: Freelancers applying should ensure their application includes the following: - Portfolio of past work - Detailed background in the field - Comprehensive project proposal for this...

...only. I'm seeking an experienced blockchain developer to create an ERC-20 token with the goal of launching a new cryptocurrency. The token will be the backbone of the startup www.infinidium.ca. Infinidium is revolutionizing datacenter/cryptomining cooling infrastructure and energy efficiency performance with the worlds first patented server cooling system which, requires no energy while producing power from waste heat. Opportunity for coins as project advisor of issued coins after the completion of the ICO as a success fee. - **ERC-20 Token Creation**: Expertise in generating a secure and functional ERC-20 token, aligned with current standards but also allowing room for custom features down the line. - **Implementation Speed**: Given the urgent nature, I need someone who...

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

I'm looking for a professional developer to implement an OCR (Optical Character Recognition) script that can accurately extract text from digital photos. These photos have complex layouts with multiple columns of text. This task will require: - A thorough understanding of OCR technology - Proven experience with image recognition and processing - An ability to handle complex layouts and formatting Accuracy is key in this project, as the ultimate goal is to eliminate manual data entry and ensure the text is easily readable post-extraction. With your bid, please share relevant samples of your past OCR projects specifically handling complex layouts for a solid reference.

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops / entries to be made. b. Single Stop BOL's....

...this project are: - Expertise in data curation, specifically in regard to financial data. - Familiarity with CSV (Comma Separated Values) format, as this is the desired output format. - Stock data will be sourced from a specific location that I will provide. - Proficiency in compiling data is required. I will need one csv file for each stock (symbol). The CSV files would have the following columns (please do not alter the casing of the column headers - all characters should be in lowercase): - symbol - date - open - high - low - close - volume Data source: Instructions: 1. Select "Security wise price volume data" in Type field in the dropdown 2. Enter the symbol of the stock in the symbol field 3. Click on "custom" button below 4. Specify