현재 싱가포르를 거점으로한 Techfin 스타트업 회사입니다. 메인 컨셉은 금융시장에서 퀀트 알고리즘 거래기술과 블록체인을 결합한 '소셜 트레이딩 플랫폼'을 개발하고자 합니다. 우선 원활한 소통을 위하여 한국어 가능한 개발자를 구하고 있으며, 책임감과 긍정적인 마인드를 가지신 분들과 함께하고자 합니다. We are based in Singapore and want to develop a social trading platform by combining our algorithm trading technology and blockchain. We want developers who have a sense of responsibility and a professional, positive mind. :)
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and a proven track record of successfully raising equity capital for companies and funds in the growth stage. SKILLS AND EXPERIENCE REQUIRED: 1. Proven experience in lead generation within the financial services sector. 2. Successful track record in raising equity capital for growth-stage companies. 3. This project requires a proactive and results-oriented approach. 4. The successful freelancer will work closely with our executive team to develop and execute a comprehensive capital-raising strategy to support our company's growth objectives...
I'm in need of an Excel data entry specialist with an intermediate level of expertise. Your primary task will be inputting data from digital files into Excel, ensuring accuracy and consistency throughout. Key Responsibilities: - Data entry from digital files to Excel - Competent use of Excel functions for sorting, filtering and basic formulas - Ensuring data is entered correctly and in the right format Ideal Candidate: - Proficient in Excel with an intermediate skill level - Experience in data entry, particularly in Excel - Detail-oriented and accurate This is an ongoing project with the potential for long-term collaboration for the right candidate.
I need an experienced financial analyst to help me develop and formulate financial projections for my technology startup. The ideal freelancer for this job would have a background in finance, specifically in the technology sector. Key Requirements: - Provide detailed revenue projections: I need a breakdown of how much income is expected to be generated on a yearly basis. This should include a clear analysis of potential income streams and growth rates. - Develop expense projections: It's important to outline the costs associated with running the business. The freelancer should be able to provide a thorough examination of potential expenses, including operating costs, salaries, and other expenditures. - Create profit projections: Based on the revenue and expense forecast...
...to my studies. Here's what I need: -Assistance with Business Consulting: A deep-dive into business models, strategies, and operations. -Direction in Market Research: Guiding in carrying out market analyses, consumer behavior study, and competitive landscape. -Training in Financial Analysis: Advice on financial forecasts, interpreting financial statements, and investment strategies. The ideal person for this job would be a seasoned freelancer with extensive experience in business consulting, market research, and financial analysis. If you've mentored others in freelancing, which I'm particularly interested in, I would find your experience even more invaluable. This is an exciting opportunity for any freelancing expert who wants to mold a you...
I'm looking for a skilled SAP FICO consultant with expertise in the Financial Accounting (FI) module. The selected professional will primarily handle: - General Ledger (GL) management - Accounts Payable (AP) - Accounts Receivable (AR) - Bank-related activities Additionally, you will be required to generate key reports including: - Profit and Loss Statement - Balance Sheet - Cash Flow Statement Ideal candidates should have in-depth experience managing the above tasks within the FI module. Extensive knowledge of SAP FICO and a keen understanding of financial reports are vital for this role.
...a skilled professional who can help us create a compelling pitch deck for our fashion and lifestyle concept store in Accra, Ghana. The pitch deck should effectively communicate our unique value proposition, target market, competitive advantage, and growth potential. Additionally, the deck should include well-researched financial projections that showcase the profitability and feasibility of our business model. Key Skills: - Pitch deck creation - Market research - Financial analysis - Presentation design - 10 to 15 Slides - Clear, concise, and engaging content - Visual appeal, mirroring fashion and design aesthetics The successful freelancer should have experience in the Fashion and Design industry or have demonstrable knowledge of it. They should also be proficient...
I need a seasoned expert to help me organize and set up a GoFundMe campaign for a senior citizen facing eviction in Los Angeles. The campaign's primary purpose is to raise $5000 to cover relocation expenses, including moving his belongings and his cat. This project needs to b...crafting compelling narratives, as the main supporting material we have is a personal story - Competency to plan and execute a campaign strategy that centers on raising funds Ideal candidates should have a passion for helping those in need and a track record of successful GoFundMe campaigns. Your responsibility will be to use the personal story we have to influence the public and help us reach our financial goal. Your input on how we can best reach our target audience and draw their support will be high...
I'm looking for a skilled and detail-oriented professional to assist me with entering handwritten data into a digital format. - The data is simple text-based, so no complex calculations or formulas are involved. - The main task will be to accurately transcribe data from scanned or handwritten documents into a spreadsheet. - Attention to detail is paramount, as even small errors could cause significant issues down the line. Ideal candidates should have a proven track record of accuracy and efficiency in data entry tasks. Prior experience handling handwritten or scanned documents is a definite plus. A keen eye for detail and the ability to maintain focus over extended periods of time will be essential for this project.
I'm looking for a skilled web developer who can create a user-friendly, web-based tool that allows our internal staff to generate cost estimates quickly and accurately. Key Features: - The to...so the tool should be intuitive, easy to use and accessible. - It should not support multiple currencies, as all our estimates will be in the same currency. Ideal Skills and Experience: - Experience in developing web-based tools or software, ideally with a focus on generating estimates. - Proficiency in UX/UI design to ensure the tool is user-friendly and intuitive. - Strong understanding of financial systems and tools, to ensure accurate cost estimates are generated. - Ability to communicate effectively and incorporate feedback, as the tool will need to meet the specific needs of our ...
I need assistance creating dashboards in Tableau. The data to be...dashboards in Tableau. The data to be visualized comes from a large database and relates to health risks, specifically the risk of heart attacks. I'm interested in assessing three factors namely age, gender and an additional one. It doesnt matter what you pick out of the data, i simply need it for seminar in college The dashboards should feature: - Enrollment data - Student performance data - Financial data. An ideal candidate should be well-versed in data visualization with industry experience in Tableau, and have proficiency in handling large data sets. Experience in health data is desirable but not mandatory. The freelancer should be able to translate complex data into easy-to-understand, visually compell...
I'm in need of a UK accountant to create financial statements for my technology company. The financials will be based on the data I provide in an Excel file. Key Requirements: - Proficiency in UK GAAP - Experience in handling technology companies The financial statements should be at a summary level, reflecting our company's financial health and performance. Use of Excel templates is preferred. The ideal freelancer has a proven track record in producing financial statements compliant with UK GAAP and an understanding of the technology sector.
...and other relevant details. - Displaying Ride Details: The API should be able to fetch and display ride details for each driver. This information is crucial for the drivers to efficiently manage their schedule and assignments. - Updating Payment Information: It is essential that the API updates payment information in our Google Sheet. This includes payments received, pending payments, and other financial details. I'm looking for a professional who can ensure that this data is updated on our Google Sheet every hour, as per our requirements. Experience in working with APIs, specifically Tranferz API, and Google Sheets is a must for this project. The ideal candidate should also have a good understanding of data management and handling secure information. If you have the nece...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical ...
...data. User Base: - The CRM system will be used by 1-50 users, so it should be user-friendly, scalable, and efficient. Integration: - It's imperative that the CRM can seamlessly integrate with other systems, particularly: - Email Platforms: For streamlined communication and lead nurturing. - Social Media: To enhance customer engagement and acquisition. - Accounting Software: To automate financial data synchronization and reporting. Ideal Freelancer: - Proven experience in CRM development, with a strong portfolio of CRM systems. - Proficiency in integrating CRMs with email platforms, social media, and accounting software. - Understanding of data analytics and sales forecasting for CRM systems. - Ability to create a user-friendly interface for a multi-user CRM system. ...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
I'm after a web and mobile application that will specifically cater to the financial management and planning needs of small business owners. The app should enhance their capabilities to handle their finances effectively. Key Features: - Comprehensive Financial Management: The app should allow users to input their financial data, including income, expenses, and capital. It should then generate insightful reports and analytics to help them make informed decisions. - Budgeting and Forecasting: The app should have a feature that assists in creating budgets and forecasts to help business owners plan their financial future. - Alerts and Reminders: The app should be able to send alerts and reminders for important financial tasks like tax payments, billing...
I'm in need of a debt collector agency with 1-5 years of experience to hel...require a set of services including: - Debt collection: Handling overdue payments across different types of debts, such as consumer, business, medical, and government debts. - Skip tracing: Locating the whereabouts of debtors who have gone off the grid, making it difficult to recover owed funds. - Credit reporting: Providing me with updated credit reports of debtors to help assess their current financial status and determine the best approach for debt recovery. Experience in this field is crucial, as it requires a deep understanding of debt collection laws and practices. The ideal agency should have a proven track record of successful debt recoveries and be able to carry out the tasks efficiently and ...
...for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I currently operate off o...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the docum...Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or ...
I am in need of a comprehensive Excel sheet that does calculation. Data entry is...Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and fin...
I need specialized assistance on visualizing my completed data analysis, encompassing sales data, financial data and customer data. To make this happen, I'm seeking a seasoned Power BI dashboard designer. Expertise required: - Proficient in creating Bar charts, Pie charts, and Line charts in Power BI - Has experience working with diverse datasets especially sales, financial and customer data - Can deliver the project urgently If you can create a comprehensive and visually appealing dashboard to delineate and amplify my data's context, your experience and skills will be indispensable to this project. Let's connect ASAP and bring this to life.
...in Lebanon - Competitor analysis to identify key players in the market - A well-thought-out marketing plan to attract our target audience of women - Financial projections and a detailed business model that's realistic and can be used for securing funding - Understanding of the unique cultural and economic aspects of the Lebanese market Ideal candidates for this project should have: - Proven experience in writing successful business plans for the beauty and wellness industry - Thorough knowledge of the Lebanese market and consumer behavior - Excellent research skills and the ability to translate data into actionable insights - Strong financial acumen and the ability to create realistic projections - An understanding of the unique challenges and opportunities in the s...
I am looking for an experienced individual to help develop a comprehensive business plan for my service-oriented venture in the beauty industry in Lebanon. This plan will cater primarily to individuals, so a deep understanding of consumer needs in this sector is need...This plan will cater primarily to individuals, so a deep understanding of consumer needs in this sector is needed. Key responsibilities include: - Crafting a business plan tailored specifically for a start-up beauty service targeting individuals - Market research and competitive analysis - Financial projections and risk analysis Ideal candidate should have: - Proven track record in developing successful business plans - Deep understanding of the beauty service industry - Excellent research and financial p...
I'm seeking a writer to compose a 25-page double-spaced report which delves into the connection between ESG scores and real estate company performance. The main questions I'm looking to address in the study are; - Are real estate companies with high ESG scores more profitable? - Does having a high ESG score increase investor interest in real estate companies? - What is the correlation between ESG scores and stock performance of real estate companies? The data for this analysis should be sourced from the past 5 years, and the report should be comprehensive and well-structured, with clear methodology and results. The study should be global in scope, encompassing a range of real estate companies and markets worldwide. This project would be best suited for someone with a backgrou...
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the da...me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a time...
I require an advanced database to streamline church operations. It must include: ...departments. Each member's record should also include household and family details, with specific fields for spouse and children. - Functionalities: Capacity to sort data based on each individual (organize by member). It should also capture other input fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database systems, with a keen understanding of how to translate our church's requirements into a user-friendly, efficient system. Knowledge of member management sys...
I'm seeking a skilled developer to create a Telegram bot that can receive and distribute trading signals from my premium indicator on TradingV...need to have a solid understanding of trading signals and how they are used. Experience with TradingView indicators and API integration is a significant plus. - Previous experience developing Telegram bots, especially those focused on the finance industry, would be highly beneficial. - A solid grasp of security protocols and data protection is crucial, as this bot will be handling sensitive financial information. I am looking for a professional who can not only build the bot, but also provide insights on how to optimize the signal delivery process for subscribers. Great communication skills and a proactive, problem-solving attitude a...
As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and exp...thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and ...
I'm a venture capitalist seeking an experienced consultant to help create financial model for a fund . The perfect candidate should have: - Proven experience in seed growth-stage investments - Deep understanding of the financial model of venture caoital - Ability to adhere to our specific investment criteria Your responsibilities will include: create the financial moddel Ideal candidates should have a strong track record of success in the startup investment landscape. Your ability to identify promising startups and contribute to their growth will be key to the success of this project.
Simple financial website needs layout updated, images changed, possible logo change, and text (copywriting) updated. You must be able to use SVN for updating. Looking for fast turnaround.
...acquiring , but before I proceed, I need a thorough background check on the company and its owner. The ideal freelancer for this job should: - Have expertise in Open-source Intelligence methods - Be able to investigate and provide comprehensive information on the company's reputation, the owner's background, and the overall trustworthiness. - Have the ability to cross-check for financial fraud, legal issues, and misconduct. - Be able to cover a global perspective in their research, especially focused on the regions of United States, Europe, and Asia. Please provide details on your relevant experience with Open-source Intelligence, as well as any similar tasks you've completed in the past. Your familiarity with conducting such research on companies will be a s...
I'm searching for an experienced Python developer to handle data collection and processing in the financial sector. Your tasks will consist of two core elements: - Data Collection: Obtaining data from diverse financial sources, including stock market data, cryptocurrency data, and financial news data. - Data Processing: Once collected, you'll perform various calculations and analyses, including statistical analysis, trend analysis, and calculations with a focus on historical data. Familiarity with these tasks and the financial sector is crucial to delivering the results needed. Your expertise in Python and financial data processing will contribute significantly to the project's success.
Seeking ML expert (MSc/PhD) to implement hybrid DCN model for Bitcoin price prediction using Python. Tasks: data collection/preprocessing, EDA, model training/evaluation, results analysis & report writing. Ideal candidate has experience in financial forecasting & cryptos.
...to assist me in taking legal action against a fraudulent website that is using a celebrity's name for illicit investment/payment activities. Key Responsibilities: - Reporting the website to the relevant authorities to ensure swift action is taken against the perpetrators. - Implementing strategies to prevent unsuspecting individuals from investing on the fake website and becoming victims of financial fraud. What I'm Looking For: - An expert in cybersecurity and fraudulent online activities, with experience in successfully combating fake websites. - A professional with a legal background who can assist in navigating the legal implications of this situation. - A quick thinker and problem-solver who can efficiently execute the necessary steps to shut down this fake webs...
...Recruitment and selection of businesses: Swipe in potential incubatees, and streamline their onboarding. - Performance tracking: Monitor and assess the development of startups enlisted. - Meetings administration: Schedule, follow up and manage meetings with respective stakeholders. - Integration with a CRM: A centralized place to manage our relationships. - Integration with payment gateway: Financial transactions can be done within the same platform. - Email marketing integration: To send, track, and manage email marketing campaigns. - Programme management: To integrate programme operations seamlessly. - Data collection, analysis and reporting tools: To gain meaningful insights from data. Ideal freelancers for this project should have extensive experience in portal deve...
I'm seeking a highly competent mobile app developer to create an intuitive mobile application for automobile insurance. The application needs to be highly user-friendly and should be accessible on both iOS and Android platforms. Key Features: - The app should collect information from various automobile insurance companies in one location which will help users to compare...previous experience creating apps for both iOS and Android. - Knowledge in integrating third-party APIs to fetch data. - An understanding of the insurance industry's standards and requirements is highly beneficial. I encourage interested and eligible freelancers with a proven track record to place their bid. Your proposal should include examples of previously developed apps, especially in the financial ...
...construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estimating and tracking costs. Please attach relevant samples of similar projects you'v...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...
I'm in need of an intricate financial model designed for a residential property that focuses on calculating equity investments. Specifically, I want: - Informative analytics on 'Return on Equity', to evaluate potential profits over time. - An illustration of 'Cash Flow Distribution', to comprehend the income dispersions. - Analysis on 'Equity Multiple', to understand the total cash received against the total equity invested. Ideal freelancers will have a strong background in financial modelling, specifically pertaining to property investments. Understanding of debt financing, equity investments and capability in generating these specific outputs is critical.
I'm looki...assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have the required skills and are committed to high-quality data entry work, I�...
I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your ...Investors, Advisors and Broker-Dealers and their deals. Our pioneering Investor Discovery Solution, removes barriers enabling Issuers (private companies and funds) to find the perfect investor match within seconds. Investors can now source the most exciting opportunities whether they are private companies, funds or even other Investors, for their primary and secondary share sales. Financial Advisors and Broker-Dealers can now gain access to issuers and investors from anywhere in the world who are unknown to them, to close their deals faster, or grow their busine...
...of an expert in financial modelling to help evaluate numerous real estate investment opportunities. This project is focused on comprehensive analysis of potential investments and to help me make informed decisions. Key Areas: - Evaluating Investment Opportunities: I need someone who can create robust and reliable financial models to assess the viability of various real estate ventures. Your models should help me identify and prioritize the most promising investments. - Financial Metrics: Your models should primarily focus on Return on Investment (ROI), Net Present Value (NPV), and Capitalization Rate (Cap Rate). These are the key metrics I need to see to make sound investment decisions. Ideal Candidate: - Proven Experience: Previous experience in real estate ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...Ramsey-Cass-Koopmans growth model. For this project, your responsibilities include but won't be limited to: - Coding in Stata and Matlab with proficiency. - Accurately interpreting and utilizing the Ramsey-Cass-Koopmans growth model. - Applying your economic and financial knowledge for effective economic modeling. We're looking to complete an advanced level of economic modeling. Therefore, you will need to demonstrate a high degree of competence and experience in complex economic theories, principles, and modeling. Your experience in financial forecasting will also be essential to ensure the accurate and reliable execution of the project. This project will also require you to effectively work autonomously, show high attention to detail, have excellent proble...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify s...
