Hi,

I am newer in VBA development. Thank you in advance for viewing my post.

I have a problem in developing code to connect with API from a broker. The broker only gave me IP address, port, and account, PWD.

What kind of technology should I use? Using FTP or something else? Does anybody have some idea?

Sorry for the simple questions.

Karen

Hello Karen,

So, you're a bit of a newbie hey, dont worry, we will hold your hand through the good times and the bad.

Now enough of the office flirting, your problem is unfortunately a little vague, but here goes.
I presume you are looking to download some data from a secure web server?
Is this data formatted using html tables or is it available in xml format or better still a csv file?
What relationship do you have with this providor, i.e. can you set up a VPN to securely transmit the data afrom one source to another using an ftp poller?

Maybe I should approach this differently, What technology should I use? You should always tailor the technology to be the most up to date available. Unforunately Technology can mean hardware, software and operating systems, so to ask 'what technology' needs to be narrowed down a little as to what the overall requirement is.
Using FTP or something else? Are you part of a large company with firewall issues and security in place that a sqeeking mouse would set off alarm bells, or can you download any kind of file from any source you want leaving yourself open to the entertainment that is known as viruses and adware popups.

VBA Development is generally able to do anything except have a sensible conversation. These posts are really good if you have a specific problem that needs to be resolved.

Unfortunately without knowing the products and processes involved we can't be much more helpful than...a the scarecrow at the crossing of the yellow brick road when all you need is directions.

Can I suggest you get a cup of tea, maybe a warm scone and some clotted cream and jam, digest your problem and revise the question. I promise to be more consise next time.

Cheers

Matt

Thanks, Matt.

Let me explain my question more clearly. I am linking my GUI to a stock broker to do cybertrading for fun. The broker gave me account, PWD, IP address and port. I am wondering which technology I should use to connect with API of the broker. Since I will do cybertrading, I am going to use command like, buy/sell...

Hi Karen,

Right, for trading you will want to analyse a massive amount of data quickly. I recommend that for the analysis of the data Excel is excellent, to connect to the data if it is being held in a database you should be able to connect to this via the web directly from excel's backend application MS Query. Although to be more robust I would recommend using a backend of Access and use a frontend of Excel to draw down data locally using ADO data retrieval rather than ODBC. This will keep your work/data sheets to a minimal size and allow a friendly user interface.

Provided you have the necessary References installed (VBA References) in your version of Excel you should have no problem in using the data.

If you are accessing data that is 15minutes behind, such as most of the free sources of data, then FTP would be a good idea as it may take time to download the data. If you want real time prices, then you would be better off looking at a different transfer protocol. Unfortunately this is not an area I am familiar with as much as the rest of the software stuff.

Hope this is a step closer to your solution.

Cheers

Matt

Matt,

Actually just now I searched several hours for the solution. I found that socket technology should be used.But I don't how to create socket function in VBA.

Karen