Excel vba code download historical data yahoo işler

İki adet excel dosyasında ilişkilendirme yapı veriyi bulup yanındaki kodu 1. dosyadaki verinin yanına koyucak excel yazılımı istiyorum.

Bir İnternet projesi için satmakta olduğumuz ürünlerin fiyatları , kodları ve ürün uyumluluklarını içerecek bir excel hazırlanması gerekiyor. Ürün katalogları , üretici kodları ve fiyatları farklı listelerde verilecek, veri girişi yapacak arkadaşlar ilgili karalogları tek bir excelde birleştirecekler. Excelde 4 -5 kolon olmasını öngörüyoruz.

"mysql den verilerin bir kısmını verilen şablona uygun olacak şekilde excel exportu yapılacak.İlgili excel şablonu ekte."

VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.

...dönüş biniş saat aralıkları, gidiş biniş koordinatları, dönüş biniş koordinatları, Facebook bilgileri. Web client üzerinden aşağıdaki işlemlerin yapılabilmesi gerekmektedir; Araçların yeri dijital haritalar üzerinde tam olarak görüntülenmeli. (Burada bir seçenek belirtilmeli ve hangi haritayı kullanacağı kullanıcı seçebilmelidir. Eklenecek Haritalar; Bu sıralamada olacak şekilde: Google Maps, Yahoo Maps, Yandex Maps, Bing Maps, Open Street Map) Tüm araçların hızları izlenebilmeli Geçmişe yönelik raporlar, güzergah bilgileri alınabilmeli Kat edilen mesafeler izlenebilmeli Harita üzerinde belirli noktalar, güzergahlar tanımlanarak buralara giriş çıkışlar denetlene...

adlı online satış yaptığım siteme ürün girişi yapılacaktır. Bütün herşey hazırdır. Yapılması gereken hazır olan excel formatına bilgileri yazmak ve siteye upload etmek sonra girilen ürünlerin yine toplu bir şekilde yada tek tek fotoğraflarının eklenmesi kalmaktadır.

Fiziksel dökümanlardaki (Türkçe ve İngilizce) verilerin MS Word ortamına aktarılması, mevcut Excel tablolarının düzenlenmesi

Fiziksel dökümanlardaki (Türkçe ve İngilizce) verilerin MS Word ortamına aktarılması, mevcut Excel tablolarının düzenlenmesi

Web tabanlı çalışacak bir internet sitesi olacak. Sisteme veri girişi sonrasında otomatik olarak pdf ortamında belge ve rapor üretecek. Değişik modüllerden oluşacak. Rapora excel yüklenecek ve exceldeki bazı verilerin oranları alınacak. Paypal entegrasyonu sağlanacak. Sisteme üye olunacak, tekil veya toplu alım imkanı olacak. Gizlilik gereği daha detaylı bilgi veremiyorum. Daha detaylı bilgi yüzyüze görüşmede belirtilecektir. Ankara'da ikamet edenler tercih edilecektir. Tahminimce, projenin yazılımı, 1-2 ay içerisinde tamamlanabilir. Veri olarak istenecek bilgiler hazırdır, belge formatları da hazırdır. Bu da projeyi alan kişinin iş yükünü azaltacaktır. Lütfen cevaplarınızda referanslarınızı ve bu konuda ...

... Bu yukarıdaki linkteki liste sanırım Excel 2013 te yapılmış bilginiz olsun. Bazı tablo dilimleyicilerini kullanmışlar çünkü. Benim istediğim anafikirde yukarıdaki linkteki gibi, benzer ama daha farklı özelliklerde ve daha iyi olması gerekiyor. Excel bilgim hiç olmadığı için bir uzmana ihtiyaç duymaktayım. Not: İçerikleri kendim ekleyeceğim. Bana sadece altyapı lazım :) Örnek Excel Dosyasından Resimler; Eğer ilgilenirseniz daha detaylı olarakta anlatım yapabilirim. Sıfırdanda yapabiliriz yada bu yukarıdaki mevcut excel dosyası üzerinden de gidebiliriz sanırım. Cevabınızı bekleyeceğim. Teşekkür

Hızlı bir şekilde sitedeki videoların çalışıp çalışmadığını kontrol edip admin panelinden çalışmayan videoları rapor olarak bilgilendirmesi ve bilgilendirilen rapor üzerinden direk posta düzenleme linki vermesi gerekiyor. Videolar Youtube, , VK, Google Docs, Facebook, Yahoo ve Dailymotion üzerinde bulunmaktadır. Proje bütçesi konusunda teklifleriniz değerlendirilir.

Hızlı bir şekilde sitedeki videoların çalışıp çalışmadığını kontrol edip admin panelinden çalışmayan videoları rapor olarak bilgilendirmesi ve çalışmayan posta bilgilendirilen rapor üzerinden direk düzenleme linki vermesi gerekiyor. Videolar Youtube, , VK, Google Docs, Facebook, Yahoo ve Dailymotion üzerinde bulunmaktadır.

Selam, dilinden anladığım birisini bulmak güzel. İsmim Cem. İstanbul'da Bir aydınlatma şirketinde çalışorum ve satıştaki arkadaşlara yardımcı olmak için bir kolaylık düşünmem gerekti. Yazılımlar hakkında çok detaylı bilgim yok ama Excel veya VB ile çözülebileceğini düiünüyorum. Bir göz atıp yardımcı olup olamayacağını iletir misin? Satış elemanımız müşterinin atölyesini ziyaret ediyor ve mevcut lambaların (armatür) keşfini yapıyor. Şu tipten şu kadar, şundan şu kadar. Faaliyetteki sistemimide bu keşfedilen bilgileri merkeze aktarıyor. Ertesi gün ekteki tablo hazırlanıyor, sonra satışcı mekana tekrar geri gidiyor ve sunum yapıyor, iş uzuyor... İstiyoruz ki muhtemel mevcut armatür...

* Sitemiz için yeni excel eğitim videoları çekilecektir. * Çekilecek eğitim videolarının ingilizceleri size verilecektir. Bu açıdan eğitimi verecek kişi herhangi bir müfredat hazırlamayacaktır. * Bu açıdan teklif verecek kişinin izlediği ingilizce videoyu iyi düzeyde anlaması gerekmekedir. * Teklif verecek kişinin iyi düzeyde excel bilmesi gerekmektedir. * Eğitimler camtasia ile çekilecektir. * Eğitimi çeken kişi eğitimin tüm haklarını bize devredecek bir sözleşmeyi imzalaması gerekmektedir. ve çekeceği videoları internette başka herhangi bir ortamda yayınlamayacağını taahhüt edecektir. * Proje bütçesi size vereceğimiz ingilizce videoların 1 saati üzerinde...

I'm developing an engaging and educational book aimed at general readers. The book wi...introduction. - Utilize ChatGPT to generate the content, ensuring it is both factual and engaging. - Fully cite and validate citations for all quotes and resources. - English fluency Ideal Skills: - Experience in writing educational content that is engaging for general readers at the 10th grade reading level - so limited use of complicated long sentences - A deep understanding of technological and historical contexts, particularly around assistive technologies and their broader impact. - Proficiency in using AI tools like ChatGPT to support the writing process while maintaining my voice I will choose the winning bidder (who actually follows my instructions, LOL) and then provide the outlin...

...model will integrate data from multiple sources to provide actionable insights and generate optimized keywords for immediate use in campaigns. Objective: The primary goal is to create an AI model that: 1. Integrates seamlessly with Google Ads API, Google Search Console, and client-provided data. 2. Evaluates keywords based on data from: - Google Keyword Planner via Google Ads API. - Crawled content from specified landing pages. - Activity data of the landing pages from Google Search Console. - Historical data of keywords from linked Google Ads accounts. The model must function optimally regardless of whether data is available from one, several, or all sources, consistently delivering the best possible r...

Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you ...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm currently working on a historical demography project and I'm looking for a skilled freelancer to help with data collection and report writing. Key Responsibilities: - Assist in the collection of relevant data for this project. - Compile the data into a comprehensive and well-structured Word document. - Include visual elements such as charts and graphs in the report to make the data more accessible and user-friendly. Ideal Skills and Experience: - Proven experience with data collection. - Strong academic or professional writing skills. - Proficiency in creating and incorporating visual elements like charts and graphs into documents. - Familiarity with historical demography is a plus. Please apply if you are confident in your...

I am on the lookout for a researcher who can access and scan articles from a specific arabic language journal held in the Bibliothèque nationale de France. The journal was published in France. I have confirmation that it is held there. (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)

I require a custom QR code generator that outputs in SVG format. These QR codes will encode vCard data for contact information. Additionally, I would like the following features: - The QR code should be in the shape of Porsche Crest logo. - The ability to customize the colors of the QR codes. - Support for integrating custom logos or images within the QR code design. Ideal skills and experience for this project include: - Proficiency in SVG format for QR code generation. - Experience with encoding vCard data. - Strong understanding of image manipulation for custom colors and logo integration in QR codes.

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

...ranks potential candidates based on their qualifications and experience. - Interview Scheduling: The tool should also have a built-in feature that enables easy and efficient interview scheduling. Preferred Resume Screening method: - Keyword Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm to predict candidate suitability based on historical data Platform: - Web-based: The software should be accessible via any web browser for ease of use and accessibility - Mobile App: A mobile application should also be developed alongside the web version to allow recruiters and candidates to access the service on the go. Ideal skills for this project include: - Proficiency in AI and machine learning algorithms - Experienc...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I am in need of a ghostwriter to help me put my military experience into a book. The ideal candidate for this project would be someone with a strong writing background, who can take my personal experiences and craft them into a compelling narrative. Key Points: - Experience in writing military-themed content is a plus - Ability to create engaging storylines from historical events - Attention to detail in depicting personal experiences - Understanding of the military jargon and culture The professional I seek should be able to turn my experiences into a gripping story that will resonate with a wide audience. This project would require strong communication skills to work collaboratively as we bring my story to life on paper. Please include any relevant samples of your past wor...

Russian Recording Project Note : We need Native Russian speakers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $14 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm looking for a Dafny developer to support me in the completion of existing code. I need him to pass verification of the code by the instructions exactly. it requires knowledge in proofs, using lemmas. Key Responsibilities: - Complete existing code in Dafny - Conduct code verification and ensure it passes successfully - Ensure the code is coherent and properly structured Requirements: - Proficient in Dafny - Extensive experience with complex algorithms and data structures - Able to work with well-documented code and project requirements - Strong problem-solving skills - Excellent communication skills, as we will need to discuss certain parts of the code Prior experience with similar projects and a good track record of succe...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate tran...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...

Russian Recording Project Note : We need Native Russian speakers for long term project. We have a project, that needs Native Russian speakers, we will give you the text, and you need to record 626 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $14 dollar for 626 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

...understanding of current SEO best practices - Ability to use Visual Studio Code for collaboration and development The successful candidate will be able to deliver a high-quality, compelling, and SEO-friendly article within the specified word count. The use of ChatGPT to generate engaging content will be a crucial aspect of the project. You must also be able to incorporate LSI keywords effectively to improve the SEO value of the article. We're looking for an experienced ChatGPT professional proficient in Python and familiar with LSI (Latent Semantic Indexing) keyword extraction techniques to create a top-ranking, SEO-optimized article for our website. The ideal candidate should have experience utilizing Visual Studio Code as the development environment and be skille...

...content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not only collates data bu...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of ...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your ex...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of t...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of ...

...an e-commerce website that can sell a single digital product - a software. The key requirements for this project are as follows: - **E-Commerce Functionality**: The website should essentially operate as a single product online store, optimized for sales of the software. - **Digital Product Delivery**: After a successful purchase, I'd like the software to be delivered via email with a secure download link. - **Payment Integration**: The website should have seamless integration with both Credit Card and PayPal payment gateways. Skills: - Proficiency in e-commerce website development - Experience in digital product sales platforms - Payment gateway integration expertise, especially in Credit Card and PayPal - Strong understanding of security considerations for digital pro...

******************************************************************* Send me a message proving to me that you have read the project. ******************************************************************* If you are familiar with AWS programming, this should be a ...-started Requirements: • I will create a new AWS free account and will supply credentials. • In my AWS account, configure any IAM role/policy/user/credentials needed to run the example program. • Change the example program to accept credentials (accessKey/secretKey) as arguments passed to the executable. • Ensure that the corrected code successfully converts the speech in the audio file to text using the AWS Transcribe service. Deliverables: • All source code • Instructions on executing...

Spanish Recording Project We have a project, that needs Native Spanish speakers, we will give you the text, and you need to record 620 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 10$ for 620 short sentences record. Every sentences is 2 word. 4. It will take time to finished 40-50 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :

I'm seeking a skilled developer to create a custom Chartink scanner designed specifically for equities. It should provide real-time and historical data analysis capabilities. Key Requirements: - Equities Focus: The tool should be optimized for stocks and securities. - Real-time Data Analysis: I need to stay on top of market movements as they happen. - Historical Data Analysis: Analyzing past data is crucial for spotting trends and making informed decisions. - Potential Stock Trends: The tool should help me identify potential trends in the equities market. - Trading Opportunities: I want to be able to use the output to identify profitable trading opportunities. It's important that the tool is user-friendly, efficient, and reliable. Exper...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...