Excel VBA DDE data retrieval from Interactive Brokers via DDE

Закрыт Опубликован 2 мес. назад Оплачивается при доставке
Закрыт Оплачивается при доставке

I need help with an Excel VBA project that involves retrieving Historical data from Interactive Brokers via DDE. I currently have an existing code that needs to be modified, and I need it to be done within a week. The data I need to retrieve is Historical data only. Experience with both Excel VBA and DDE is a must. If you think you can help, please let me know. Thanks!

More details summary below.

The attached sheet is working and pulls historical OHLC stock trading historical data into Excel via VBA/DDE from Interactive Brokers' TWS desktop trading platform. The excel file is a cut down version of Interactive brokers example DDE excel sheet.

The sheet currently uses a manual button click, which cycles through a list of stock codes on the Historical Data tab, and downloads the data one stock at a time per button press.

I want to adjust the VBA so that is loops though the list of stocks automatically.

I would also like to sort the retrieved stock data so the newest data is at the top. This should also be pretty easy.

Note. to get data from Interactive Brokers an account is needed (a paper trading account is fine) and then download their TWS desktop trading platform. This needs to be running with when the Excel is open.

You will also need to download and install an API bridge from Interactive brokers API ([login to view URL]).

Once API is installed, you need to run a batch file from the API folder which connects between TWS and Excel using a Java bridge in the background. Assuming you did a standard install of the API, the batch file to open the API should be located at "C:\TWS API\samples\DdeSocketBridge\[login to view URL]". Just run this to connect excel to TWS.

FYI - Java also needs to be installed. This all works well assume these things are done.

I just need help automating the button and sorting the data.

Excel Visual Basic Visual Basic для приложений Обработка данных

ID проекта: #37247705

О проекте

15 заявок(-ки) Удаленный проект Последняя активность 3 недель назад

15 фрилансеров(-а) готовы выполнить эту работу в среднем за $1512


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 look Больше

$1200 HKD за 5 дней(-я)
(583 отзывов(-а))

Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. For the tasks you want to get done, I may not have to install and run everything, but a Больше

$1820 HKD за 4 дней(-я)
(189 отзывов(-а))

Hi there! As I have read, I see you need help professional retrieving historical data from Interactive Brokers through DDE and I could help you! I'm a professional Database Administrator and Analytics Engineer with m Больше

$240 HKD за 1 день
(56 отзывов(-а))

Hi, I have gone through the Job details and am interested in taking it up. I might need to contact you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees Больше

$1500 HKD за 4 дней(-я)
(30 отзывов(-а))

Hello there! My name is Zafar, and I am a highly experienced freelancer with over 5 years of experience in the field of software development. I have the necessary skills and expertise to help you with your project. Больше

$2000 HKD за 7 дней(-я)
(31 отзывов(-а))

Hi, I am super expert in VBA, Excel and in earlier stage I done a lot of DDE as well. I love automation in excel and can use multiple technologies together to get the job done, i can make your VBA code to work exactly Больше

$1800 HKD за 3 дней(-я)
(16 отзывов(-а))

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

$1850 HKD за 2 дней(-я)
(7 отзывов(-а))

I am excited to hear about your project! With my experience in data processing, Excel and DDE, I believe I can help you reach your goal of retrieving Historical data from Interactive Brokers via DDE within a week. I h Больше

$2000 HKD за 5 дней(-я)
(0 отзывов(-а))

Yes! You are on Right Bid. I have Read All Project details and descriptions regarding Excel VBA DDE data retrieval from Interactive Brokers via DDE I will save your time by letting my work speak for you. If I am luck Больше

$1245 HKD за 1 день
(0 отзывов(-а))

My name is Gian Harfizo, and I am a data analyst with of experience in the field. I have expertise in data analysis using Excel and SQL, as well as experience in data entry and management. I am excited to apply for you Больше

$1120 HKD за 7 дней(-я)
(0 отзывов(-а))

Hi, I am an expert in VBA excel macros, Vba selenium automation, web scrapper and auto mailers scripts. i can help you with best solution.

$1120 HKD за 7 дней(-я)
(0 отзывов(-а))

I understand your need to retrieve Historical data from Interactive Brokers via DDE within a week's time. With my experience in both Excel VBA and DDE, I am confident that I can help you reach your goal faster than any Больше

$1120 HKD за 7 дней(-я)
(0 отзывов(-а))

Proposal: I can assist with various tasks such as research, writing, data entry, and more. Let's discuss your specific needs and goals.

$1120 HKD за 6 дней(-я)
(0 отзывов(-а))