Vba financial project işler
...numaralı kısımda bahsettiğim web servis aynı zamanda bir takım sorgulama ve raporlama imkanları verir (bir tür APİ). Bu web servis yapısı ve dokümanları var, çok karmaşık değil. Ben google spreadsheet ve excelde vba üzerinden rahatça çalışabiliyorum bunlarla. Bizim ihtiyacımız burada basit bazı tablolamaları belirli aralıklarla AİP'ler ile sorguladığımızda görebilmek. Ardından buradaki veriler ile canlı gelen verileri karşılaştırarak ve oradan çıkan sonuçlara göre yeni web servisler çalıştırmak. Not: Bütçe sembolik yazıldı, lütfen abartmadan (uzaya araç göndermeyecek, ben bunların hepsini VBA ile yapıyorum ama excel şişiyor ondan kurtulmaya çalışıyorum) kendi fiyat ...
Sütunları 2, 3, 4lü ... gruplandırıp grup benzerlik oranlarını hesaplayan VBA istiyorum. Aslında böyle bir VBA daha önce hazırlatmıştım, ama bu VBA belli sütun sayısından fazlasını yapamadı. Belki bu dosyada değişiklik yaparak da işimi görebilirsiniz. Ben 300 sütuna kadar karşılaştırma yapmayı istiyorum.
Hisse senedi, emtia ve yatırım fonu alım satımlarım için grafikler ile kar zararı gösterebilecek güncel fiyat bilgilerini internet üzerinden 15 saniye de bir çekip güncelleye bilecek excel tablosu istiyorum.
...that we will publish in the future. We will shoot all the videos and send them online. I need a video editor/designer to edit these videos. The process will be long because we plan to publish videos on average every week and to generate income from the videos we publish after reaching a certain number of subscribers in the future. My plan is affiliate marketing. In the first place, I can provide financial support as we will not be able to reach a certain number of subscribers immediately. But the expectation should not be in the form of the earnings of the designers in professional studios, please, those who are interested in this job and plan to settle abroad in the future can help me. Waiting for your offers. Please give me details Well, I will do this job and demand xxxx TL pe...
Excelde çeşitli ebatlarda olabilen bir tablonun hücrelerinde bulunan değerlere göre bir çarpanla çarparak satır ve sütünları değere göre sıralayacak. Rank order clustering isimli bir matematiksel bir çözüm yöntemi.
Excel VBA kodları olan bir excel türünde bazı sayfa ve hücreler şifreli durumda. Bu şifrenin kaldırılmasına ihtiyacım var.
Merhabalar, Temel olarak, adı Matriks (MTX) olan bir masa üstü uygulamadan DDE veriler alabiliyorum. Bu sayede ilgili verileri excel’e çekebiliyorum ve aslında bundan sonra anlatacağım her şeyi VBA üzerinden yapabiliyorum ama excel'in sınırlamaları nedeniyle, eğer yapabilirsem excel'i aradan çıkartan bir uygulama yaz(dır)maya çalışıyorum. Yapmak istediğim şey kısaca; 1. MTX'in DDE verilerini al (excel olmadan doğrudan MTX'ten tercih edilir. Excel’e ben DDE linkle veri alıyorum, sonra da excel dosyasını python ile okuyabiliyorum ve CSV’ye yazabiliyorum, ama bu istediğim şey değil). Biliyorum DDE eski bir veri noktasıdır, ancak MTX'ten veri almanın başka bir yolu -yani TCPI veya başka bir yöntem- ol...
Mevcut bir excel dosyasında adlı siteden veri çekiyordum. Ancak 1 haftadır siteden veri çekemiyorum. Excel dosyasında module kısmı düzenlenerek dosyaya yeniden veri çekme işlemi gerçekleştirilecektir.
Yeni bir parakende mağaza açılışında giderleri tahmin etme ve kar zarar analizi yaparak mağaza açılıma uygundur veya değildir tarzında bir rapor sunacak excel istiyorum.
google excel sheet üzerinden birden fazla firmadan teklif alarak fakat verilen teklifler birbirinden gizli olacak şekilde açık arttırma ihalesi gibi bir makro excel oluşturmak istiyorum.
BENİM BELİRLEDİĞİM HÜCREYE GÖRE OTOMATİK FİLTRELEME YAPACAK EXCEL VBA YAZILMASINI İSTİYORUM
Makale üzerinden modelleme yapılarak vba programı ile ülke ligi ile ilgili program yapılacak
VBA'de egzotik opsiyon fiyatlandırılma kodu yapılacak. Monte Carlo simulasyonu kullanılacak. Detayları ilgililerle paylaşıcam.
I am currently trying to raise funds for my escape from Gaza. The primary purpose of my GoFundMe campaign is to accumulate the necessary financial resources that will aid in obtaining exit visas. Ideal Skills & Experience: - Demonstrated ability in fundraising, particularly within GoFundMe platform. - Experience in donor engagement, strategic promotion and marketing. - An understanding of humanitarian issues would be beneficial. Key Tasks: - Increase visibility of GoFundMe Campaign. - Drive donations towards obtaining necessary exit visas. - Provide consultation or strategies for ongoing fundraising success.
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
...investigative journalism, feature writing, and media relationship building are preferred. This project needs a tactful strategist with a strong way to get my story out I’m going to the actual news however this can be either for me to or preferably some cultivated relationship you have. I’m already working with a crisis response agency here I want more of a detailed in depth report here that triggers the community. The amount of lies told during and after my arrest are all documented in 10k word report. But no one will read that. Someone skilled enough to report comprehensive overview of toxicology and civil right while somehow making the public understand all of the unanticipated damage to one’s mental and financial health it has. The story already I&...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualizati...a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previou...
This creative project entails the production of an engaging 3D animated video, squarely focusing on presenting the 'benefits of having a 401k plan' to new employees. The video should ideally simplify complex financial concepts and manifest the advantages of opting for a 401k plan in an inviting and clear manner. Key Requirements: - Develop a storyboard that effectively communicates the benefits of a 401k plan. Brief, hopefully less than 3 minutes long - Execute the storyboard into a visually stimulating 3D animation. - The animation should be appealing to new employees, ensuring it is straightforward, engaging, and lays a solid premise to encourage 401k investment. - The content should be accurate, concise and easily digestible, even for people with little ...
...background in the following areas: - Internal Controls Review: The freelancer will be responsible for evaluating and testing our internal controls to ensure they are effective and in compliance with industry standards. Experience with COSO framework would be highly beneficial. - Financial Statement Audit: The selected professional will be tasked with auditing our financial statements to provide an independent and objective assessment of our financial health. An in-depth knowledge of GAAP and experience with financial statement audits is a must. - SOX Compliance Review: The freelancer will need to review our processes and procedures to ensure compliance with the Sarbanes-Oxley Act. A thorough understanding of SOX requirements and experience with complianc...
I am seeking an experienced Python professional to develop a system that can accurately detect fake invoices. The aim is to prevent financial losses and enhance security. Need to detect a submitted computer generated receipt in pdf if it is a tampered or real one. There are chances like in the computer generated bill some people can change the amount, name, address sections and submit. This model should able to detect all those tampered PDFs with minimum false positives. Do metadata analysis QR code reading in the receipt and validation Key Responsibilities: - Develop a fraud detection algorithm using Python. - Test and tune the model for maximum accuracy. Ideal Experience and Skills: - Proficient in Python programming. - Proven experience in creating algorithms, preferably ...
2 excel files with VBA macro as per customer requirement
...fees that we will pay the drivers, based off of the size of the adverts on their vehciles - the costs that we will quote to the advertisers, based off of the size of the advert and the number of cars per campaign and the campaign length. The presentation will be delivered to: - Potential Drivers: The earning potential of this program will be a key focus point. Drivers should be enticed by the financial benefits of participating in our advertising program. - Potential Advertisers: The pricing model should be clearly outlined. This will be based on factors like the number of cars in the campaign, and the size of the advertisement. Ideal Skills and Experience: - Experience in creating engaging and visually appealing presentations. - Understanding of the advertising industry and it...
I need an expert...monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Advanced spreadsheet creation - Understanding of revenue systems...
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
I'm looking for a skilled professional who can assist me with my registered investment advisory agreements and financial service agreements. Ideal Skills and Experience: - Extensive experience in legal contract drafting, particularly in the financial services industry - compliance and legal - Familiarity with the regulations and requirements of registered investment advisory agreements. - Excellent understanding of financial service agreements and their legal implications. Key Focus: - Reviewing the existing documents to ensure they are comprehensive, accurate, and legally sound. - Ensuring that both the registered investment advisory agreements and financial service agreements are aligned with industry standards. - Providing advice and guidance as nece...
I am in need of a comprehensive business plan focused on a technology indus...a technology industry, primarily crafted to secure a bank loan. As such, the business plan should instill confidence in our financial viability and be convincing enough for loan approval. Key responsibilities would include: - Researching and understanding the nuances of the technology industry - Detailed financial planning including projected revenues, costs, and profitability Ideal freelancers for this job will: - Have a deep understanding and experience in the technology industry - Have strong financial planning capabilities - Show a proven track record in crafting successful business plans for securing bank loans - Be able to communicate technical and financial details in an und...
...game offers an inclusive and educational experience, promoting financial literacy and sustainable practices through entertaining gameplay. *Key Features:* 1. *Community-Driven Gameplay:* - Players can work together to build flourishing farms, with options to visit, assist, and trade with each other in real-time. - A marketplace for exchanging goods and services using BABYCHICKEN tokens enhances player interaction and drives the in-game economy. 2. *Crypto Educational Platform:* - Earn, invest, and manage BABYCHICKEN tokens within the game to learn about cryptocurrency and blockchain technology in a fun setting. - A virtual wallet and transparent transaction ledger are incorporated to educate players on financial management and security. 3. *Sustainability R...
One excel file with macro as per the customer requirement
I'm in need of a professional who specializes in handling financial disputes and can promptly engage with the financial ombudsman on my behalf. Key tasks include: - Resolving a financial dispute and potentially securing compensation for financial losses. This will require experience in mediating with an ombudsman and a strong understanding of financial regulations. - Drafting and sending a cease and desist letter focused on breach of compensation and non-disclosure agreement (NDA), as well as immediate money release. Ideally, you would have a background in dealing with such issues and possess solid writing and negotiation skills. Please only bid if you have proven experience in these areas. Prompt response and action are essential for this task.
...Advisory business. - The website should have a professional, modern design that reflects the financial industry. - It is crucial that the site efficiently showcases our services for clients seeking to access capital markets. Additionally, I need help in the following: - Securing a domain name that is suitable for my business and easy for clients to recall. - Setting up a professional email address for the business that enhances my credibility with clients. Ideal skills and experience for this job include: - Proficiency in web development with a portfolio of financial or advisory websites - Knowledge of domain registration and email setup - Prior experience working with consultancy or financial services businesses - Strong understanding of SEO and lead genera...
As a long-standing consultancy and matchmaking agency focusing on financial services, we are keen to reach more clients. To achieve this, we are seeking digital marketing experts to provide effective advertising strategies, particularly via TikTok and YouTube. Key Responsibilities: • Formulate and execute a highly-effective advertising campaign for TikTok, social Media and YouTube, with the aim to increase customer acquisition and lead generation. • Provide insightful marketing advice and strategies. Ideal Skills and Experience: • Proficiency in TikTok, social Media and YouTube advertising. • Expertise in digital marketing and lead generation strategies. • Openness to insightful suggestions to achieve the agency’s goals. • Experience in marke...
We need a professional press release to announce a new partnership between a Canadian...in Egypt. The target audience will be potential investors and distribution through various media outlets in both regions. Key Requirements: - The press release will need to contain background information mainly on the Canadian company and emphasize the finacial benefits of the partnership in a compelling manner. - The tone needs to be engaging and tailored to a high net worth individuals and financial professionals operating mainly throughout the middle east region. Ideal Skills: - Proven experience in writing press releases for finance industry. - Understanding of Middle East culture. - Arabic language a great asset - Strong copywriting skills and ability to convey complex ideas in a conci...
I'm looking for a professional freelancer to develop a solid business project. Some of the key aspects include: - Writing a detailed business plan - Creating a comprehensive financial forecast - Identifying the optimal target audience - Suggesting innovative marketing strategies - Offering a risk assessment and mitigation plan The ideal candidate should have extensive experience in business development and have a strong track record of creating successful business plans. They should be innovative, proactive, and able to think outside the box. Please include examples of past business projects you've worked on and their outcomes in your application.
I am seeking a sales representative who is well-versed with IT cybersecurity software, primarily focused on firewall solutions and data encryption tools. Ideal Skills & Experience: * IT cybersecurity sales experience * Knowledgeable about cold and worm calls * Familiar with the business needs of industries like financial institutions, healthcare organizations, government agencies, industrial companies, and oil and gas Role Expectations: * Prospecting and outreach to target industries * Providing product demonstrations and proactive follow-ups * Negotiating and closing sales with potential customers Success in this role would be determined by your ability to ensure our clients' compliance with industry regulations using our products.
...my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financial Modeling Experience: Prior exp...
...cryptocurrencies. • Execute common wallet functions such as sending and receiving payments. • Facilitate fundraising by hosting a dedicated section for donations. Any interested developer should also ensure that users are required to create an account before they can use the wallet. Your expertise in mobile and web application development, especially with experience developing crypto wallets or similar financial apps, will be highly valued. Familiarity with blockchain technology and a deep understanding of crypto tokens and coins is essential. An intuitive UI/UX design skill is a must-have since the wallet app should be user-friendly and easy to navigate....
I'm in need of a skilled Oracle Apex developer to help with the data management of our company's financial records. The main goal of the project is to create a user-friendly web interface that can efficiently manage and present financial data. Key requirements include: - Expertise in Oracle Apex and proficient in data management - Experience working with financial records and data - Ability to design and develop a user-friendly web interface - Strong understanding of data security and confidentiality - Excellent attention to detail and accuracy The successful candidate will be able to streamline our financial data management processes, making it easier to access and utilize the data for various purposes within the company.
...**Scope of Work**: Your primary task will be to create a modern and minimalist style presentation deck. This deck will be a crucial aspect of our pitch to potential investors. It should be visually compelling and succinctly present our business plan and financial model. - **Skills and Experience**: I'm looking for a freelancer with: - Proven experience in creating engaging and high-quality presentation decks. - Strong design skills, especially with modern and minimalist design preferences. - Experience in business plan creation or financial modeling would be a plus. - **Deliverable**: The final output should be a comprehensive presentation deck that can effectively communicate the vision and potential of our cosmetics business to potential investors in a way t...
I'm in need of a comprehensive Stata expert to delve deep into a financial dataset and compile an insightful, actionable report based on the findings. The main objective here is to provide a detailed discussion on the trends and patterns identified within the financial data, alongside some data-driven recommendations. Key responsibilities: - Exploring and identifying trends, patterns, and anomalies in the financial dataset using Stata - Compiling a detailed report that covers the above, with a particular focus on generating actionable insights - Ensuring the report has a clear, concise and professional structure and presentation Ideal candidate should have: - Proficiency in Stata and prior experience with financial data analysis - Strong analytical skill...
I'm looking for an experienced professional to test Stock Trading applications, preferably with experience in the financial sector. Key Points: - Primarily concerned with the Stock Trading aspect - You are required to have experience in the field Please do not hesitate to include your stock trading experience in your application.
...a skilled financial modeling specialist to create a comprehensive financial model for a vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Prof...
I am in need of a LinkedIn banner update to be completed as soon as possible. Can be based on the current banner - just need to change the words as a priority but other elements could also change. The key visual elements to be incorporated include our company logo, relevant product images, and a tagline that says Automated Financial Management. The color scheme of the design should primarily be purple and white to align with our current branding (previous Linkedin banner attached) Not a complex job - just looking for something clean and quick delivery
I'm in need of detailed insights into various credit repair companies across the USA. The scope of this project is quite comprehensive and entails the following key areas: - **Reputation and Reviews**: I need a thorough analysis of the reputation and reviews for a range of credit repair companies. This data should be based on both customer feedback and industry standards. - **Services Offered**: A detailed breakdown of the services provided by each company would be crucial. This includes the scope of services, their unique selling points, and the quality of their offerings. - **Pricing and Fees**: An in-depth understanding of the pricing and fee structures of these companies is essential. This should cover both their standard packages and any additional costs that may ...
I'm seeking an HRMS solution that delivers the following functionalities for my business, which currently employs between 50-100 workers: - Employee attendance tracking - Leave management - Payroll processing In addition to these functionalities, I would like the system to generate the following types of reports: - Financial report - Leaves and attendance reports The ideal freelancer for this project will have experience developing HR Management Systems, understanding of payroll systems, and excellent knowledge in varying report generation. Knowledge of regional labor laws and standards would be a major plus. The overall goal is to have a system that offers a comprehensive snapshot of our HR activities. Leaving room for future modifications is a must, based on t...
...and professional pitch deck that effectively communicates our business model, market opportunity, competitive advantage, and potential returns for investors. - Highlight our unique selling propositions, such as cutting-edge technology, experienced team, and the potential for disruption in the biotech industry. - Ensure that the content is clear, concise, and persuasive, with a strong focus on financial projections, milestones, and scalability. Ideal Skills and Experience: - Prior experience in designing and developing successful pitch decks for early-stage biotech or tech companies is highly preferred. - Solid understanding of the biotech industry, including market trends, challenges, and opportunities. - Exceptional visual design skills, with the ability to create engaging and ...
...with in-depth experience in using Quickbooks and managing financial tasks for businesses in the USA. Key Tasks: - Managing the Quickbooks accounts for my 10-20 clients, ensuring their financial data is accurately recorded and up-to-date. - Perform bookkeeping and financial reporting tasks for the clients, maintaining a clear and detailed record of their financial transactions. - Prepare and plan taxes for the clients, keeping in line with all relevant U.S. tax laws and regulations. - Process payrolls for the clients, ensuring timely and accurate payments to their employees. Skills and Experience Required: - Extensive experience using Quickbooks, particularly in a professional accounting capacity. - Proficient in Bookkeeping, Financial Reporting, Tax...
I am in need of a skilled accountant who can prepare a Profit and Loss statement, Balance Sheet, and Trial Balance. As a retail business owner, understanding our financial position is essential. Key responsibilities include: - Creating P&L statements - Drafting balance sheets - Concocting trial balances The ideal candidate would have experience in retail accounting, giving them the ability to understand the specific needs of my business quickly. Please note the frequency of this task is undetermined at this time, to be discussed after engagment. Your flexibility and willingness to adapt to change is important. I look forward to a productive partnership.
I need a financial expert to help me with a range of tasks on the EIKON Platform. The ideal candidate will be proficient in financial planning, budgeting, and tax preparation. - Specific tasks include: - Creating a detailed breakdown of financial plans and budgets - Ensuring high accuracy in financial planning and budgeting I expect the ideal candidate to be comfortable working with Excel/Spreadsheet, as this is the tool we'll be using to integrate the financial plan and budget. Ideal Skills: - Proficiency in financial planning, budgeting and tax preparation - Proven experience in creating detailed financial breakdowns - Advanced understanding and experience with Excel/Spreadsheet - Excellent analytical and problem-solving skil...
