[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel 2000 VBa book



PureBytes Links

Trading Reference Links

I just got "Microsoft Excel 2000 Power Programming with VBa" and "'Special' Edition Using Excel 2000".  Both are about 1,000 pages and have a CD-ROM.  I recommend both.  I think with the first book I'll pretty much be able to program whatever I wish into Excel, if I ever actually finish it.  One problem is that it won't show you how to directly access the Quotes-Plus2 database or BMI/eSignal RT datafeed.  I don't really want to get into MSFT VC++ or VB programming since it would probably take forever to produce any meaningful results. For those of you who don't know, if you subscribe to BMI via cable, you would be able to get unlimited tickers.  BMI sends all of the tickers at once via cable.  Right now the only way I know how to get BMI data into Excel is via a DDE link.  This limits the number of tickers, I believe.  If you could tap into the BMI feed directly in Excel, you could theoretically track every single ticker on Nasdaq and NYSE.  You could then set up a page which would consist of alerts.  Of course, you would need a fairly powerful computer to do this.  You would need something on the order of a Pentium III 500 (or greater) with 256 MB's of memory (or more).  Nevertheless, think of the possibilities for profit this setup would create, even if you only caught a piece of the movement in a stock.  The profit potential would be nothing less than incredible.   Daniel.     Walter Lake wrote: Hi Guy A VB baby?? ... Right ... you're installing Visual Studio Professional and I'm struggling away with the "plain vanilla" VB standard version. The "Black Book" sounds interesting however, will have to check it out. Am totally amazed at the UserForms that can be created using VBA in Excel. They are so easy to make and add "stuff" too ... I can even use non-standard colours like "purple" now that I found the colour codes and the colour palette in the properties section for each UserForm. Hope that you get unblocked soon. I've heard about those nasty "blocks" that the old guys at the home develop. Best regards Walter ----- Original Message ----- From: Guy Tann To: Sent: Friday, September 24, 1999 8:42 PM Subject: VB 6.0 book @ CostCo | Walter | | Found the Programming Microsoft Visual Basic 6.0 (Microsoft Press $59.99) | for $28.99 at the local Costco.  They had the Wrox book as well I think (it | was cheaper, but I don't remember the exact price).  I was too cheap to buy | both as I already have the Visual Basic 6.0 Black Book which seems to make | more sense to me as a programmer.  It's more of a 'how do I do this task' | type book.  If you want to perform a specific task, they have the code to do | it.  I'm hoping that between the two, I'll have all the information I need | to get started. | | I'm a VB baby as I've programmed for almost 40 years in probably 10 or more | different languages, but I have never used VB.  Will install Visual Studio | Professional this weekend and get to work.  For some reason, I have a mental | block in getting started with VB, and always retreat to something I know | like Clipper or using Metastock. | | Regards, | | Guy Tann