Rolling return excel vbaроботи

...columns=['timestamp', 'open', 'high', 'low', 'close', 'volume']) return df def calculate_indicators(df): # Индикаторы для анализа df['SMA'] = df['close'].rolling(window=20).mean() df['EMA_9'] = df['close'].ewm(span=9, adjust=False).mean() df['EMA_21'] = df['close'].ewm(span=21, adjust=False).mean() df['ATR'] = (df['high'], df['low'], df['close'], timeperiod=14) return df def predict_price(df): model = LinearRegression() X = (range(len(df))).reshape(-1, 1) y = df['close'].values (X, y) predicted_price = ([[len(df) + 1]])[0] return predicted...

Потрібно робити схожий контент для соціальних мереж так щоб були органічні охоплення також потрібні люди які можуть робити ugc video і картинки для таргетованої реклами

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

I am in need of a meticulous data entry specialist to convert text data from various digital files, primarily PDFs and Word documents, into an Excel spreadsheet. Key Requirements: - Proficient in data entry with a keen eye for detail - Able to accurately transcribe text data from digital files into an Excel format Ideal Skills: - Excellent command of English for comprehension and transcription - Previous experience with data entry from PDFs and Word documents - High level of proficiency in Excel

I'm looking for a data entry expert to help with Excel data entry and formatting customer information. Key Responsibilities: - Entering customer information into Excel - Formatting data for consistency Ideal Skills: - Proficiency in Excel - Experience in data entry and formatting - Attention to detail and ability to meet deadlines Please reach out if you're interested.

"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data, such as companies, ...

I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.

Description: We are looking for a highly skilled photo editor to extract and edit 20 high-quality images for various Amazon products. The images need to be delivered ...Include a brief outline of your approach to this project and an estimated timeline for delivery. Don't ask me about BUDGET Your bid is the budget we will accept so bid accordingly. If you want to stand out from the competition here is a sample amazon url that I need 20 images for: Demonstrate your ability to return 20 images (feel free to watermark them), if we like your quality you will be a stand out candidate. Understanding of Midjourney and other text to image and image to image ai tools would be a bonus and you should mention it.

I need a results-oriented marketing strategy for my travel affiliate website, specifically targeting budget travelers. The main goal is to boost sales, and I must see a clear return on investment. Key Responsibilities: - Implement effective social media campaigns to drive traffic and sales - Utilize email marketing to engage potential customers and promote deals - Employ Search Engine Optimization (SEO) techniques to increase site visibility and attract budget-conscious travelers Ideal Skills: - Proven experience in affiliate marketing, particularly in the travel sector - Strong skills in social media marketing, email marketing, and SEO - Ability to demonstrate measurable results and a clear ROI - Understanding of the budget traveler demographic

...processes news sentiment from - Gathers alt rank from - Forecasts prices using Google Times Series Foundation Model The system needs to be compatible with the Jesse trading platform, able to perform both backtesting and live trading. Each news article will be classified as positive, negative, or neutral, and the task will involve calculating an indicator value as a rolling sentiment score within a specified window, with a range from -10 to 10. Key project requirements include: - Full integration with data APIs from and - Real-time updates for news sentiment and alt rank data Ideal candidates should have robust Python programming skills, trading platform experience, and a strong understanding of backtesting and data analysis. Prior

Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days

I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.

...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: - P...

I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)

PERSON I AM LOOKING TO HIRE MUST BE FROM BULGARIA. I'm seeking a creative designer with experience in crafting compelling PowerPoint presentations for business purpose...included: - Financial data: This will require clear, easy-to-understand visuals that accurately represent the company's current financial status and projections. - Company achievements: Highlighting our successes is crucial to instilling confidence in our potential investors. - Future projections: This will need to be presented optimistically, yet realistically, with a focus on growth and potential return on investment. The ideal freelancer for this project will have a strong background in business presentation design, a keen eye for creative detail, and the ability to present complex data in an accessib...

Arreglar el excel

I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accurately captured and well-structured.

I'm in need of professional assistance for the monthly filing of my GSTR-1 GST returns. Skills & Experience Needed: - Proven experience in GST return filing, particularly GSTR-1. - Strong understanding of GST regulations. - Attention to detail to ensure accurate filings. - Ability to meet monthly deadlines consistently.

I'm seeking an experienced professional to assist with the design of a rural drainage system. The key tasks include: - Preparing a detailed list of design requirements for the rural drainage system, focusing on determining an acceptable return period for critical rainfall conditions. - Conducting preliminary design work for both the drainage and irrigation systems. This will entail calculating design parameters, net irrigation requirements, and selecting appropriate equipment. - Analyzing leaching requirements during irrigation to prevent salinization. I also need a comprehensive analysis of calculation results under various rainfall conditions using SOBEK software. The final deliverable should be a clear report detailing the design steps and results, alongside a proposed m...

I have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural language processing - Famil...

I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports for CSV data import I want th...

I'm looking for a freelancer who can create two report templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these closely. Skills needed for this pr...

I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues - Familiarity with Admin panel functionalities in web applications.

Living Room Redesign Project General Description: Our living room is the heart of our home, a space where we spend most of our time as a family. We are a family of four: myself (I return home late in the afternoon), my wife (a teacher and marketing consultant who often works from home), and two daughters aged 18 and 13 (who use the sofa and TV for leisure and study). We would like to optimize this space to meet everyone’s needs, combining functionality, aesthetics, and comfort. Project Objectives: 1. Space Optimization: Make the space welcoming, practical, and organized, maximizing every square meter. 2. Multifunctional Areas: Create well-defined zones (relaxation, study, socializing) without compromising the room’s openness and brightness. 3. Contemporary D...

Looking for a seasoned Python developer to help create a robust video upload API. The API will cater to our needs, so previous experience in API development is highly desirable. Ideal Skills: - Proficiency in Python with fast api - Extensive experience in API development - Familiarity with video processing and related libraries - Kno...- Knowledge of various video formats - Understanding of server-side logic and architecture - good experience in gcp Key Responsibilities: - Design and implement a video upload API - Ensure the API is efficient and can handle large volumes of uploads - Incorporate security measures to protect uploaded content User will record the video from mobile app and it should upload in gcp and api should return the response and it should play from front end (m...

I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.

...the OS Ticket menu should have a new item: "Back to Shopping Cart".  D. Navigation Between Platforms:  Clicking the "Back to Shopping Cart" link should bring the user back to their account page in Zen Cart, from where they connected to OS Ticket.  E. Session Integrity:  Maintain session integrity between Zen Cart and OS Ticket, so that the user does not get logged out of Zen Cart when they return from OS Ticket. 3. Zen Cart Admin Panel Integration o Provide a link to OS Ticket's Admin Module within the Zen Cart Admin panel, similar to how users are linked in the frontend. 4. Development Process and Deliverables o Zen Cart Module Development: A custom module will be developed in Zen Cart to facilitate the integration with OS Ticket. This module will ...

I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions Saudi Days: Sunday to Thursday Session: 11:00 AM – 3:30 PM Daylight Saving Time: Not applicable UAE Days: Monday to Friday Session: 10:00 AM – 2:00 PM Daylight Saving Time: Not applicable London Days: Monday to Friday Session: Standard Time (October to March): 11:00 AM – 7:30 PM (AST) Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST) US Days: Monday to Friday Session: Standard Time (November to March): 5:30 PM – 12:00 AM (AST) Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST) I want to make excel template to -plan and track staff...

necesito ejecutar scripts python, estos scripts lo que hacen es : 01 - generarme archivos Excel, modificar módulos dentro del libro Excel, 02 - Subir a la base de datos que los archivos ya fueron generados 03 - Subirlos a Gdrive y obtener el enlace de descarga 04 - subir a la base de datos el enlace generado. todo esto ya esta hecho, lo que necesito poder hacer que mediante un botón en mi pagina web, php, ejecute los script python. Lo he estado haciendo con Flask y Ngrok de manera local.

I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns and fixed options. Please include exampl...

I need assistance extracting data from PDF files into a structured Excel table. The data is primarily in table format and the formatting is consistent throughout the document. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data extraction from PDF - Attention to detail - Ability to follow instructions carefully

Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!

...material, size, and design specifics. Multiple high-quality images for each product with zoom-in functionality. Option to filter and sort products by price, style, and availability. Shopping Cart and Checkout: User-friendly shopping cart functionality. Secure and streamlined checkout process with multiple payment options (credit/debit cards, UPI, PayPal, etc.). Option for users to save their cart and return later. User Accounts: Allow customers to create accounts to save their details and view order history. Guest checkout option for convenience. Shipping and Delivery: Integration with reliable shipping partners. Real-time tracking updates for customers. Customer Support: Live chat or chatbot feature for quick customer queries. FAQ section and contact form. Additional Feature...

I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows: - One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements. - Data Type: The primary data being used in these sheets is a combination of text and numbers. Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorably if you can provide examples of similar p...

I require assistance with data entry into an Excel sheet. The data is currently stored in databases and consists of a mix of numeric and textual information. The data needs to be categorized by department in the Excel sheet. Ideal skills for this job include: - Proficiency in Excel - Experience with data entry - Ability to categorize data effectively - Attention to detail - Familiarity with databases

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I'm seeking a dedicated virtual assistant to assist with my e-commerce business. Your primary focus will be responding to emails, managing my Shopify store, and helping with Excel/reporting tasks. Key Responsibilities: - Responding to emails promptly and professionally - Checking off orders and ensuring accurate processing - Updating pricing on Shopify - Adding new physical products to my Shopify store - Filing emails correctly for easy access - Assisting with data entry tasks in Excel and other reporting software Ideal Skills: - Experience with Shopify - Proficient in Excel, particularly with data entry - Excellent English email communication skills - Detail-oriented with a focus on accuracy The ideal candidate should be comfortable working with physical good...

...onTimeExceeded completion should be called from SessionWatcher instance. Creation of a DispatchWorkItem will take place in DefaultWorkItemProvider. The created work item will be used in the SessionWatcher Class. Requirements Provide an implementation for the following methods and classes: DefaultWorkItemProvider func workItem(actionBlock: @escaping () -> ()) -> DispatchWorkItem? This method should return DispatchWorkItem with the given actionBlock to execute SessionWatcher start() o The start method will be called when the session time starts. As an effect, DispatchWorkItem created from DefaultWorkItemProvider should be started to track the user's inactivity. o Anew DispatchWorkItem needs to be created when start is called. o The created DispatchWorkItem should...

I'm looking for a Tally expert who can customize an automation script for me. The script should be able to import various data fields from an Excel file into Tally. At present we have to import the goods receipt data from excel file and material issues from excel file. The automation script should be robust and capable of handling errors and exceptions during the import process. Therefore, detailed error handling is a must. Your expertise in Tally and experience in creating automation scripts will be critical for the success of this project.

...verification, Abandoned cart notification, order notification and payment gateway integration Note 99.9% website has to be managed through Dashboard, like editing pricing, bulk import,export,bulk move with-in pages, bulk edit, bulk delete, Hide category, in page pages or multiple pages, Edit in one page or multiple pages, though coded the website has to act plug and play Ecommerce Website USP - We give return gifts to customers based on Invoice size- hence the designs is detailed accordingly You need to first ensure that Gift cards with 16 digit or 12 digit secure login with pin code (as an example shown in myntra), • Coupons creation in admin panel with expiry date and with a condition which will be discussed later • Gift page which works on multiple conditions but ...

Online WhatsApp Sales Representative Https:// We are looking for a motivated Sales Representative to work in the USA timezon...WhatsApp business account. Your Responsibilities: - Manage 50 hot leads each day from Facebook ads. - Follow up with customers from the previous day. - Aim for 1-2 sales per day. - Conduct weekly bulk marketing and promote special offers. - Record sales and customer information in Excel. - Submit daily sales reports. Compensation: - **Base Salary**: $250/month. - **Commission**: 5% on all sales. Schedule: - 6 days a week, 10 hours a day. Requirements: - Strong sales and customer service skills. - Proficient in Excel for tracking and reporting. - Excellent communication skills. If you're ready to help us grow and succeed, we want to hear fr...

I'm seeking a developer experienced with the Quick... I want to be able to monitor: - How quickly orders are being processed - Whether there are any delays in fulfillment The ideal freelancer for this project will have a strong background in working with APIs, particularly the QuickBooks Online API, and will be able to deliver a solution that will save me time and help me manage my orders more effectively. One File show the orderplan today in excel we like to list all order Estimate and then show the green where is the order in trello. every column with green is a list in trello. we need set up trello connection and what list we should list up in orderplan. We have building a system and doing the connection to trello and QB. we need someone take over and finish the orderplan...

I'm looking for a commission-driven salesperson to help our finance service-based firm acquire small business clients. Key Responsibilities: - Finding and targeting clients - Using online marketing methods primarily, with a focus on soc...Responsibilities: - Finding and targeting clients - Using online marketing methods primarily, with a focus on social media, email marketing, and SEO/Content marketing Ideal Skills and Experience: - Proven experience in sales, particularly in the finance sector - Exceptional online marketing skills, specifically on the mentioned platforms - Ability to work independently and driven by commissions In return for your hard work and achievement in finding us clients, we will share a percentage of the contract amount with you. Looking forward to ...

Main Goal: 1. To create Quotation Appendix 2. Quotation Approval Email, 3. A... Steps: 1. Input Automation • Populate all the required information above into the Full Cost Model (FCM), an Excel template file, automatically. FCM file template will be provided. 2. Price Calculation • Use the FCM to compute the final selling price based on certain margin. Extract the per unit price Outputs: 1. Quotation Appendix Creation • Automatically generate a quotation appendix in Excel format, based on the FCM data. Get the per unit price from FCM. 2. Approval Email Preparation • Auto-generate an email text for approval, with the FCM file attached in both Excel and PDF formats for approvers to review and sign. 3. Auto insert these info into a...

I'm launching a Shopify jewellery store in February and need a skilled digital marketer to drive my ad campaigns on both Meta and Google Ads. Key Responsibilities: - Strategically r...launching a Shopify jewellery store in February and need a skilled digital marketer to drive my ad campaigns on both Meta and Google Ads. Key Responsibilities: - Strategically run paid campaigns with provided budgets. - Focus primarily on sales conversion. - Target new prospective customers. I need you to guarantee results and demonstrate proven expertise in this field. You will be judged on the return of investment from our ad spend. Ideal candidates will have a strong background in e-commerce marketing, particularly within the jewellery sector. Skills in data analysis and strategic planning...