Find Jobs
Hire Freelancers

I need a vba and excel expert -- 2 updating Job details

$250-750 USD

Avslutat
Publicerad nästan fem år sedan

$250-750 USD

Betalning vid leverans
Currently using excel RTD to monitor stock data. Need a program that will interface RTD, API or ? to scan, filter and ? for stock, options based on personal criteria. I'm proficient in Excel and I know what in the program just need a good code writer. Im open to the programming language. Below, I have tried to detail what I’m looking for. It should provide a good view of what I need. If you have any background with the US market, options it would be helpful but I don’t think it’s a major deal breaker. Please, review, provide price quote, time table to complete and any questions please do not hesitate. Historical daily prices: I need to enter stock name and retrieve historical data from 2 no password sites. With the option of the time frame I need. Then, download as default cvs., avoiding data exceed errors. Typical download file size is after master worksheet is established is around 1k per stock inquiry. I already have a large historical EOD database so this would be use to update the stocks that have not been recently updated and EOD for all stocks. AND FOR THE EOD prices for Stocks: Before storing the data in the master worksheet I need to run a few basic calculations on each stock historical price day. At some point in this process I need to append the data to a master worksheet which I assume would contain the above mentioned “Historical daily prices “ in excel that I have. Once, this master worksheet is established then it would only require the end of day price updated of a file size of ~1k x 5000 individual inquires. Is this possible to do for around 5000 stocks end of day using a no password website such as CBOE without incurring a data exceeded error and block from the website? To be run after markets have closed. I’m assuming that my need for Historical daily prices: and EOD prices Stocks: would be almost identical. Earnings data: I need to enter stock name and retrieve historical data from a no password site. Then, download as default cvs., avoiding data exceed errors. Typical download file size is <1k. The data I seek would only be the earnings dates. The data would needed to append a master worksheet in excel or I’m also open to ideas and approaches. Daily scanner REAL TIME: Scan the USA markets for option able stocks meeting criteria that I can select from a list of my creation. Formulas that I use not too complicated. Communication link would be RTD provided by Ameritrade, IB (API), or To be decided. All brokers have a limit on data inquires per time frame. As, with all of the above requirements I’m open to different solutions that you might have including the use of java, C or ? All data ends at excel use. How it gets there I’m open to? This is a non commercial use program.
Project ID: 19089672

Om projektet

13 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
13 frilansar lägger i genomsnitt anbud på $581 USD för detta uppdrag
Använd avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$750 USD Om 10 dagar
4,9 (336 omdömen)
7,9
7,9
Använd avatar
Hi, In fact there are many options for your data as a source but I think number of them will need live accounts like CQG. I recommend for you to use large broker like CQG and I can do the job using their API. There are also other options like IB API but there are a limitations I think there maybe sources that should be free like Google Finance but need to check the limitations of them. Regards, Iyad
$1 666 USD Om 20 dagar
4,9 (43 omdömen)
7,5
7,5
Använd avatar
Hello i hope you are doing great i can help you with API integrations/development i am expert PHP Wordpress, Codeigniter and Laravel developer, have worked with many APIs like Quickbooks, Sage, Salesforce, Lead executive, Mindbody to get or push data via API or via scrapping.I can help you for sure let's connect for more details thanks For 11 years I’ve worked in web development and so I am accustomed to working with all sorts of products and services and in a variety of industries. I have a deep passion for research and guarantee that all of my development is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. If you are interested in a larger volume of work each month, I can offer a lower rate. Please, let me know what is needed to secure this bid! Thank you for your consideration.
$576 USD Om 10 dagar
5,0 (107 omdömen)
6,8
6,8
Använd avatar
hello,how are you. i read your bid carefully. i am C#, VB, VBA expert and have full experience for 7 years. C#, VB, VBA is my top skill and i can build your project by using that skills. I can provide most quality and high fast. if you want to success, please contact me. Then, I will give you good result. hire me.
$500 USD Om 10 dagar
4,4 (8 omdömen)
5,7
5,7
Använd avatar
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$450 USD Om 10 dagar
4,8 (24 omdömen)
4,4
4,4
Använd avatar
Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Please let me know your requirements. Regards
$250 USD Om 1 dag
5,0 (8 omdömen)
2,1
2,1
Använd avatar
Dear Sir or Madam: I am interested in doing the job. I have made similars and ready to strat. ASAP. I wait for your message. Kind regards. Remote Work Guidelines of my Software Factory -We offer a personalized service. -We offer a personal dashboard for project management -We offer a full stack service of software architecture and engineering. -Expertise since 90s in business's systems -Online distance working -Extreme programming, Agile methods. Ask Portfolio Cloud services: GAE programming, Google API services Office Excel Access programming ERPs open source programming (PHP, Python) DBA, SysAdmin: MySql, PostgreSQL ASP.NET and classic programming with VS 2017 Websites Wordpress Joomla custom Access-like for buisnesses Python for ETL crawling scraping .NET VS 2017 VB.NET app SQLite DB Extract, Convert, Transform any data any format any source any target. OCR systems.
$444 USD Om 10 dagar
5,0 (2 omdömen)
1,8
1,8
Använd avatar
Hello! Vba & Excel experienced here. Going through with the requirements in project description, I would like to take your project on board. I am an independent and professional developer with 100% completion rate. Please knock me for a quick discussion about the project.
$250 USD Om 7 dagar
5,0 (31 omdömen)
0,0
0,0
Använd avatar
I'm a seasoned veteran in Excel VBA and R. I have done a project related to performing sentiment analysis of a news website according to the temporal nature of the data. Furthermore, i have done a project which required running some calculations on stock exchange data of a country and displayed on a website. I believe my work history gives me the specific set of skills required to complete this task. Reading about your requirements, sounds like this job is right up my alley!
$333 USD Om 20 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för THAILAND
Si Racha, Thailand
0,0
0
Medlem sedan mars 29, 2019

Kundverifikation

Andra uppdrag från denna kund

I need a vba and excel expert
$250-750 USD
Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.