I want to do a stock screener which does a daily scan of the following markets:
All major US stocks, from the indices SP500, NYSE, Nasdaq composite and Rusell 3000
All major Canadian stocks.
Large and mid cap European stocks, from these markets: UK, Germany, Spain, Italy, France, Netherlands, Portugal, Sweden, Norway and Denmark
This scan is based on data from the API at t [login to view URL] from which I have an API Key.
No stocks should be below 0,5 billion USD in market cap.
The output should be as follows:
One sheet for each country. Sheet 1: US, Sheet 2: Canada etc.
The data should be as follows, with the following values gathered from the API:
These are the columns that should be in the Google sheet.
Stock name
Ticker code
Price/Book
Price/earnings
Market Cap
Value*
All these data values need to be captured for all stocks from the API.
The Value mentioned above should be 0,1 or 2, depending on the following:
If Price/Book is below 1, then add +1.
If Price/earnings is below 10, then add +1.
This means that stocks that meet both conditions will have the value 2, while stocks that meet one of the conditions have the value 1, and if none of the conditions are met then the value is 0.
I believe I can make 100.000 requests a day with the current API key. If what I have mentioned above is too much for one day, we can spread the requests over two days.
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
Hello? How are you today? I am Michael .
I have thoroughly read the summary of your intriguing project. With my wide range of skills, I can complete it with ease. I've successfully finished tasks like this in the past.
I'd be happy to talk to you about the project. Send me a message: I'd be happy to share my solution(s) with you.
Thanks
Hello,
We went through your project brief and would love to help you execute your project.
We are an web developers with an experience of more than 7+ years who has created websites that get traction and generate leads.
Our expertise in HTML, CSS, JavaScript, WordPress, Wix, PHP, Laravel, React, Node.js, MySQL and other languages.
With the ever-changing market, a business employs multiple tools to build its brand’s credibility and a website is the core element to increase your global presence.
We offer:
- Timely delivery within the given deadline
- Unlimited revisions until you are completely satisfied
- 24/7 availability for all your questions and concerns
- Complete handover of your project with ownership rights
We have a clear aim of bringing Our most excellent work forward and giving you 100% satisfaction. Connect with us and we can discuss this further.
Thank you.
Hi chrjk
We went through your job post and it seems like our team is a great fit for this job. We have delivered similar projects recently and are very confident that we have your required skills such as API, Google Sheets. Let's hop on a call or discuss this in the chat box.
I am ready to start working on the project asap. I am available 24/7 so feel free to connect over the phone or chat
Kind regards
Aqib