Automated Excel Tool for Stock Market Companies - 30/07/2024 07:07 EDT

$250-750 USD

Käynnissä

Julkaistu

5 kuukautta sitten

$250-750 USD

Maksettu toimituksen yhteydessä

I'm in need of a customized tool that can list all companies listed on the NYSE, S&P, and NASDAQ stock exchanges. This tool should be able to automatically fetch and update company information from a reliable data source. Key Requirements: - Should be developed on Excel - Must list companies from NYSE, S&P, and NASDAQ - Display company details in Excel spreadsheet format - Automate the process of fetching and updating company information Tool should show following 22 fields using Yahoo Finance. There will be also intrinsic value calculation columns required (formula based columns, low effort programing needed) in the project. I'd rather an excel tool or a desktop app. If you propose building a desktop app, it should allow user to extract excel or .csv file. 1. Company Name, 2. Listed Exchange, 3. Origin Country 4. Ticker 5. Real Time Share Price [login to view URL] Return (%) -> Please check the "News" page of a stock, there is a "Performance overview" section where you can use as a source. 7. Market Cap (intraday) -> Please check the "Summary" page of a stock 8. Profit Margin (%) -> Please check the "Statistics" page of a stock 9. EBITDA -> Please check the "Statistics" page of a stock 10. Levered Free Cash Flow (ttm) -> Please check the "Statistics" page of a stock 11. Real Time 52W High 12. Real Time 52W Low 13. Share Price Proximity to 52W Low: It's a formulation resulting in a percentage -> (Current Share Price - 52W Low Share Price) / Current Share Price 14. Price/Earning (P/E) 15. Earnings Per Share: in the summary section of the stock, you may see EPS (TTM). 16 -> Last 5Y Average Growth Rate (in absolute value) -> in the analysis section of the stock, you may see "Growth Estimates" sub section. There you can see "Past 5 Years (per annum)" data. I need the absolute value of that percentage (e.g., if it shows 5.12%, your tool should show 5.12 as a number). 17-> Estimated Average Growth for Next 5Y (in absolute value) -> in the analysis section of the stock, you may see "Growth Estimates" sub section. There you can see "Next 5 Years (per annum)" data. I need the absolute value of that percentage (e.g., if it shows 5.12%, your tool should show 5.12 as a number). 18. Real Time Yield of AAA Corporate Bonds: the number is same for all stocks. And your app can get that number from below website. its 5.04% for today, and your program should return 5.04 as a number. https://www.freelancer.com/users/l.php?url=https:%2F%[login to view URL]%2Findicators%2Fmoodys_seasoned_aaa_corporate_bond_yield&sig=a7b68286939f1cff183f8ef139ca97d410180b899b795ea5f22a293198e690a6 19-> if number 23 returns "null" result, it means ticker/company is not a dividend payer, so it's a NO on your program. if number 23 returns a result, it means ticker/company IS a dividend payer, so it's a YES on your program. 20. Dividend Yield (%) -> in the statistics section of the stock, you may see Forward Annual Dividend Yield percentage. That's the value you are looking for. 21. Dividend Yield on Cost (%) -> this one needs calculation. your program needs to divide number 23 (Trailing Annual Dividend Rate in statistics section of stock), with number 5 (real time share price) and it should return a rate. 22. Real Time Annual Dividend Paid per Share: in the statistics section of the stock, you may use Trailing Annual Dividend Rate. That's equivalent to 22.

Projektin tunnus (ID): 38399054

Tietoa projektista

81 ehdotukset

Etäprojekti

Aktiivinen 5 kuukautta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@fatimatuzzohura

Hello, I just came across your job posting and I'm quite intrigued by the opportunity. As an experienced freelancer with a strong track record, I believe I could be a valuable asset to your project. I'm eager to discuss the details further and see how my skills align with your needs. Please feel free to reach out to me at your earliest convenience so we can have a more detailed conversation about the project requirements and how I can contribute to its success. I'm prepared to begin working promptly once the details are finalized. Thank you for considering my application. I look forward to the possibility of collaborating with you. Best regards, Fatima

$750 USD 7 päivässä

4,9

(251 arvostelua)

7,5

81 freelancerit tarjoavat keskimäärin $475 USD tätä projektia

@softsolution2000

Hi there I propose to develop a customized Excel tool that will list all companies listed on the NYSE, S&P, and NASDAQ stock exchanges. The tool will automatically fetch and update company information from a reliable data source. It will display company details such as Company Name, Listed Exchange, Origin Country, Ticker, Real Time Share Price, Real Time 52W High, Real Time 52W Low, Share Price Proximity to 52W Low, Price/Earning (P/E), Earnings Per Share, Last 5Y Average Growth Rate, Estimated Average Growth for Next 5Y, Real Time Yield of AAA Corporate Bonds, Real Time Corporate Credit Rating of the Company, Dividend Payer (Yes/No), Dividend Yield (%), Dividend Yield on Cost (%), and Real Time Annual Dividend Paid per Share. This tool will efficiently automate the process of fetching and updating company information in Excel spreadsheet format. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah

$488 USD 7 päivässä

4,9

(409 arvostelua)

8,6

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$500 USD 7 päivässä

4,9

(675 arvostelua)

8,7

@n2rtechnologies

Hi, I checked your requirements and I am extremely interested in taking your project. We would like to grab this opportunity and will work till you get 100% satisfied with our work. I am flexible in prices, as quality & long-term relationships are more important. Note:- This is a place holder bid. So the Actual price and time will be given after complete discussion. Looking forward to the opportunity to work together. Regards Nurul Hasan

$750 USD 20 päivässä

4,9

(275 arvostelua)

8,5

@AwaisChaudhry

Hello Good afternoon , I hope you are doing great. Just finished reading the brief details of your job . I see you have been looking for a freelancer who has experience with Data Entry, Excel, Visual Basic, PHP and Software Architecture. Upon the first look I feel confident about getting it done because of having experience doing similar jobs My Experience? I have 9 years of experience working with those technologies. Its been 8 years since I have been working on freelancer.com, Please review my profile. Check: Skills, Portfolio, Customer Feedbacks. Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern US Time I would like you to start the chat so we could discuss it in detail and we will continue from there. Thanks! Awais

$750 USD 14 päivässä

4,9

(57 arvostelua)

8,2

@livegoodlife

Hello there, I am experienced in web scraping and building scripts or a Windows desktop application using python. I am also experienced in large data scraping from a given website, bypassing IP, Captcha, and anti-bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards

$250 USD 3 päivässä

4,9

(392 arvostelua)

8,1

@einnovention

With over 25 dedicated professionals in Einnovention, we have successfully completed more than 248 projects on Freelancer.com alone, holding a remarkable 4.9/5 rating. Our extensive knowledge in software architecture and our prowess in CMS development and integration through platforms such as Classlink and Clever positions us to perfectly execute your 'Automated Excel Tool for Stock Market Companies' project. As proficient developers, your project’s framework and language requirements align with our skills, allowing us to comfortably meet your expectations. Additionally, we excel in creating tools that pull real-time dynamic data from reliable sources, ensuring accuracy and timely updates. This set of skills directly corresponds with the key requirements of your project; starting from fetching and listing companies from NYSE, S&P, and NASDAQ to displaying the intricate financial details such as dividends, earnings per share, growth rates etc into a user-friendly spreadsheet.

$500 USD 7 päivässä

4,9

(182 arvostelua)

7,7

@imtyzooel71n

Hi, I am Senior Python script developer with 10 years of experience. I can build a script/bot by python with your instructions very short time. Can we discuss please? Thanks

$250 USD 3 päivässä

4,9

(234 arvostelua)

7,6

@rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$500 USD 1 päivässä

5,0

(199 arvostelua)

7,1

@daniyal3214

Hello, Excel expert here. I can perfectly assist you in developing such an automated Excel based tool and can start on an immediate basis. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project. I will be happy to share my portfolio of similar work performed in past.

$250 USD 1 päivässä

4,8

(250 arvostelua)

7,4

@Giovanni704

Hi there! As I have read, I see you need help creating a customized tool to list all companies listed on the NYSE, S&P, and NASDAQ stock exchanges and automatically fetch and update company information from a reliable data source. I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.

$250 USD 1 päivässä

4,9

(64 arvostelua)

7,1

@zeeshanysf

Hello Oskar K., I understand that you are looking for a customized tool that can automatically fetch and update company information from the NYSE, S&P, and NASDAQ stock exchanges. I propose to develop this tool using PHP and Visual Basic to ensure seamless integration and functionality. With my expertise in PHP and experience in software architecture, I will create a user-friendly Excel tool that lists companies from the specified exchanges and displays relevant details such as company name, ticker, share price, 52W high/low, P/E ratio, earnings per share, growth rates, dividend information, and more. I am committed to maintaining effective communication throughout the project to ensure that your requirements are met accurately and timely. Best regards, Zeeshan

$500 USD 7 päivässä

5,0

(78 arvostelua)

6,5

@jayprakashyadav

With over 15 years of experience as a Web Developer and proficiency in Excel, PHP, and Software Architecture, I'm confident that I can create the perfect automated Excel tool for your stock market company listing needs. As a developer with a knack for simplicity and efficiency, I understand the importance of having a streamlined and up-to-date database of companies. I will ensure that your tool displays all the key information you need for each company listed on NYSE, S&P & NASDAQ exchanges while automatically fetching and updating data from reliable platforms. My skillset with data entry and Excel is second to none. I am well-versed in extracting and organizing complex datasets, which directly aligns with your project's requirements. Moreover, my proficiency in PHP and Software Architecture can also help in effectively integrating the tool with your existing systems for maximum productivity. By choosing me for this project, you're not only opting for an experienced professional but someone who listens attentively to client requirements. I vow to deliver an accurate tool that not only meets but exceeds your expectations. Let my passion for simple, efficient solutions revolutionize your stock market company data management process!

$500 USD 7 päivässä

5,0

(47 arvostelua)

6,4

@zeeshan411

Hi, I have a couple of questions about your project: 1. Is your project documentation prepared? 2. What is your timeline for this project? I have reviewed your project, “Automated Excel Tool for Stock Market Companies - 30/07/2024 07:07 EDT”, and I am sure I can handle it effectively. Best regards,

$426 USD 3 päivässä

4,8

(63 arvostelua)

6,1

@intelliresponse

As a seasoned software developer, Python and C are two languages close to my heart, searching for which led me here - to you and your needs. With an extensive background in building custom-tailored coding projects, it's safe to say that I'm the ideal professional to create your Automated Excel Tool for Stock Market Companies. My skillset in data entry, PHP, and software architecture align perfectly with this task. My experience in automation bridges seamlessly to your project demands. I've developed numerous tools designed to streamline intricate data-based tasks like yours before. A perfect illustration of this is my experience in web scraping—a crucial skill that you're precisely seeking. I'll deploy efficient systems to automatically fetch and update company information from reliable sources, ensuring you benefit from real-time accuracy. Lastly, I want to emphasize on my compliance with your key requirements. Microsoft Excel is a platform I comfortably work on regularly, so crafting the tool on it is an easy win for both of us. Additionally, being an American Software Developer gives me the advantage of better understanding the specificities of NYSE, S&P, NASDAQ stock exchanges and their listing process; something that will greatly inform my approach in producing the excel spreadsheet you need. Choose me today and let's commence on this journey towards simplifying stock market analysis!

$250 USD 1 päivässä

4,9

(9 arvostelua)

5,4

@litioman5

Hi, there. I am very interesting in your job posting. I believe that my programming knowledge and experience are highly relevant for developing an automated Excel tool. Throughout my career, I've built complex systems that require fetching and managing real-time data. My proficiency in PHP, a versatile programming language, will be invaluable in creating a tool that can efficiently retrieve and update company information. Building on my ability to design user-friendly interfaces, I can ensure a seamless experience for you. My PHP and software architecture skills foster efficient and scalable solutions - essential attributes for a tool that needs to handle large datasets and remain adaptable to future requirements. I understand the significance of real-time information in the stock market industry, thus ensuring the data source used is reliable and up-to-date will be a priority. In conclusion, my cross-disciplinary skills as an electrical engineer with emphasis on program development make me an ideal candidate for this task. Let me bring my blend of creativity and technical expertise to develop a customized Excel tool that perfectly aligns with your needs. Looking forward to hearing from you. Best Regards.

$500 USD 7 päivässä

5,0

(2 arvostelua)

5,0

@devbaloni1983

I have more than 15 years of experience in the development As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as possible. I offer excellent software quality work and provide the best support for your project. If you give me this job, I will do my best to finish your job by your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss this with you about the task now. Thank you for the reading.

$250 USD 7 päivässä

4,8

(14 arvostelua)

4,6

@Rsolitario

Hello, I am a Python and VBA programmer, so I can design the Excel sheet as a result of the Python application or VBA macros that retrieves the data you need from the API. Do not hesitate to contact me, greetings.

$250 USD 2 päivässä

4,9

(16 arvostelua)

4,6

@Automate007

★★★ PAY AFTER WORK ★★★ Pay only when you got 100% work done ✅ Hi There. I have done the Similar work before. I hope this proposal finds you well. I am writing to express my keen interest in your Python Selenium automation project. With a comprehensive background in test automation and [7 years] of experience working with Python and Selenium, I am confident in delivering a robust and efficient solution tailored to your specific needs. Proposal Highlights: Project Understanding: Having reviewed your project requirements, I am excited about the opportunity to automate your testing processes using Python and Selenium. My approach involves creating scalable and maintainable automation scripts that improve efficiency and reduce manual effort. Selenium Proficiency: I bring a wealth of experience in utilizing Selenium for test automation. My expertise extends to creating dynamic and data-driven test scripts, handling complex scenarios, and ensuring the reliability of test outcomes across different browsers and platforms. I am enthusiastic about the opportunity to contribute to the success of your app project. Please find my detailed proposal attached for your review. Thank you for considering my bid. I look forward to the possibility of collaborating with you on this exciting project.

$250 USD 2 päivässä

5,0

(32 arvostelua)

4,1

@freddyho

Hello, I am an application developer with over 10 years of expertise in VB.NET, VBA, and other programming platforms. Additionally: - I am mastering advanced levels of programming, including web-crawling, image manipulation, and more. - I have completed several projects related to retrieving yahoo finance data - I prefer to make a desktop app (Windows platform), that able to provide either excel format or csv. - I can apply your requested filtering or formula. I have made a complex formulas and filtering for stock analysis. - I can automate Excel charts at the result - With additional price, I can make special charts as well (like candle charts) that is not supported by excel. "However, I cannot suggest any formulas or filterings". I just apply as your instruction. Thank you for considering my proposal. I look forward to working with you. Please let me know if you have any further questions about this proposal. Best regards, Freddy Ho

$250 USD 4 päivässä

4,8

(15 arvostelua)

4,4

@rosscarter1011

Hi dear friend I am proficient in programming in asp.net core, vb.net, SQL, Excel, VBA ,Powershell Scripts and automation tools in the Windows environment. Plus 10 years of challenging experience in organizations and 5 years in freelance work. I have done more than 100 projects, including sales CRM applications and graphic PDF invoices, management dashboards in Excel, SAP Excel warehousing, automation programs for technical calculations and human resource management, personnel salary, fuzzy calculations, calculation of technical service rates and mass document format convertors like word to mysql. and also Im expert in Windows Automation Systems and developing system and security programs in windows networks. There is nothing that I can't handle in Excel VBA ! once our chat starts ofcourse If you were interested, I will gladly send you some of my work samples that may not be in my current portfolio yet. In addition, I have strong problem-solving and creativity skills that have attracted my clients in the past. i may automate most of the manual operations for you! I invite you to try my services and see the quality of work I offer. Hoping for a successful and long-term cooperation

$270 USD 5 päivässä