Excel VBA DDE data retrieval from Interactive Brokers via DDE

Ditutup Disiarkan 2 bulan lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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 untuk Aplikasi Pemprosesan Data

ID Projek: #37247705

Tentang projek

15 cadangan Projek jarak jauh Aktif 4 minggu lepas

15 pekerja bebas membida secara purata $1512 untuk pekerjaan ini


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 Lagi

$1200 HKD dalam 5 hari
(583 Ulasan)

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 Lagi

$1820 HKD dalam 4 hari
(189 Ulasan)

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 Lagi

$240 HKD dalam sehari
(56 Ulasan)

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 Lagi

$1500 HKD dalam 4 hari
(30 Ulasan)

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. Lagi

$2000 HKD dalam 7 hari
(31 Ulasan)

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 Lagi

$1800 HKD dalam 3 hari
(16 Ulasan)

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 dalam 2 hari
(7 Ulasan)

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 Lagi

$2000 HKD dalam 5 hari
(0 Ulasan)

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 Lagi

$1245 HKD dalam sehari
(0 Ulasan)

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 Lagi

$1120 HKD dalam 7 hari
(0 Ulasan)

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 dalam 7 hari
(0 Ulasan)

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 Lagi

$1120 HKD dalam 7 hari
(0 Ulasan)

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 dalam 6 hari
(0 Ulasan)