Đã Đóng

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

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.

Kĩ năng: Excel, Kiến trúc phần mềm, VB.NET, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: vba editor alternative, vba jobs salary, work from home excel projects, excel jobs from home part time, excel vba, visual basic editor excel 2016, how to open vba editor in excel 2016, excel vba restore default view, excel expert part time job, find vba excel expert, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need a data entry part time job, i need a excel spreedsheet prepared, i need a facebook expert uk, i need a lightroom expert in the uk, i need a manufacturer of 2 2 solenoid valves, i need a numbers expert, i need a photoshop expert, i need a wamp expert, i need a wordpress expert

Về Bên Thuê:
( 0 nhận xét ) Si Racha, Thailand

ID dự án: #19089672

15 freelancer đang chào giá trung bình $547 cho công việc này

schoudhary1553

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. Thêm

$750 USD trong 10 ngày
(328 Nhận xét)
7.8
esalem

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 Thêm

$1666 USD trong 20 ngày
(41 Nhận xét)
7.4
polarjin2017

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Thêm

$500 USD trong 3 ngày
(117 Nhận xét)
6.9
keshavkalra90

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 executi Thêm

$576 USD trong 10 ngày
(99 Nhận xét)
6.8
goldsea808

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 a Thêm

$500 USD trong 10 ngày
(7 Nhận xét)
4.6
webanis

Hi, I am interested in your offer Let me know more details about this work. I'm interesting to work with you for long time like a partnership Best regard Anis Dhiflaoui

$400 USD trong 3 ngày
(21 Nhận xét)
4.1
bhupendrayadav

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 o Thêm

$450 USD trong 10 ngày
(17 Nhận xét)
4.1
STdevil22

I have 5-6years of expertise with MS Access, Excel, VBA and SQL server and will be happy to work on this project. I've developed many applications in access, excel, visual basic and visual studio as well. Let's discuss Thêm

$250 USD trong 3 ngày
(2 Nhận xét)
2.1
stanleyw12

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. Pleas Thêm

$250 USD trong 1 ngày
(8 Nhận xét)
2.1
tsft

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 per Thêm

$444 USD trong 10 ngày
(2 Nhận xét)
1.9
belireil

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. Ple Thêm

$250 USD trong 7 ngày
(31 Nhận xét)
0.0
TheVandalyst

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 require Thêm

$333 USD trong 20 ngày
(0 Nhận xét)
0.0
pukivaidhya

Thanks for The Opportunity !! Previously I have developed 2 application for financial market and have core in depth knowledge of stock market technical details. Sample Links: 1. RealTrend - [login to view URL] Thêm

$722 USD trong 8 ngày
(1 Nhận xét)
2.9
marcelogrsp

Hi, I have 8 years of experience working as data analyst! Check out my post on my personal blog where you can see I know this subject! [login to view URL] I was hired by Colorcon here in the UK to automate their pro Thêm

$250 USD trong 2 ngày
(0 Nhận xét)
0.0
vikashshah

Hello Sir, I have read your requirement and understood that you are looking a windows developer/ web application and software developer for your project. We have 6+ years experienced windows developer team and we Thêm

$863 USD trong 15 ngày
(0 Nhận xét)
0.0