Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 25th, 2005, 12:08 AM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default VBA API

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

Reply With Quote
  #2 (permalink)  
Old August 25th, 2005, 03:03 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Bournemouth, Dorset, United Kingdom.
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #3 (permalink)  
Old August 25th, 2005, 07:44 AM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #4 (permalink)  
Old August 25th, 2005, 09:34 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Bournemouth, Dorset, United Kingdom.
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old August 25th, 2005, 10:13 AM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
API mallik C++ Programming 2 February 20th, 2008 04:03 AM
VBA-API form filler for external application Dmitri_h Excel VBA 1 January 30th, 2007 04:28 AM
Java API Ibn_Aziz Java Basics 2 June 26th, 2006 05:28 AM
API Panduchandra Visual C++ 1 March 27th, 2006 11:48 PM
its about the jni API ogriddmut Dreamweaver (all versions) 1 June 29th, 2004 03:05 AM



All times are GMT -4. The time now is 01:55 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.