... <phillips4739@y...> wrote: Happy New Year Marco and to all! The results for the year 2005 recently posted are showing returns for a buy and hold for...
Hello. I had posted an earlier request for help and I have gotten some very helpful and insightful information. I am new to Excel and even newer to Excel as it...
i have a column full of company names. how can i check if these are public companies using VBA ? i need the method and the code! best regards, rob ... ho...
... Here's a quick and dirty PHP routine that will do it: http://ogres-crypt.com/php/yahoo-get-ticker-symbol.php?s=Microsoft|General+Mills|Circuit+City Just...
thanks Randy. if anyone else has the vba code that would be helpful. Randy, if i have php access on my web server, is all i have to do is upload this script in...
... Yup. Or just execute where I have it now... ... You'd need to import the subroutine PHP file as well. I do have VBA equivalents of what I gave you, but...
Kermit asked me offline about the "LinkBuilder" function that is available as part of my Excel add-in. Rather than responding to him directly figured others...
Hi, I am trying to achieve this but no luck. I would like to left click on a cell, ie a cell that display an asset's name. and it pop up a user-defined form...
... Take a look at Popup-WebBrowser.xls I just uploaed to the library. Basically, I have a cell containing a shape and a ticker symbol. When the shape is...
How about a right click event right click the sheet tab>view code>select worksheet>select right click>write your macro here.You probably want to restrict it to...
I Added it in. It is pretty neat stuff. Thank you, Charles ... than ... <http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535 ... On...
... Nice. That was my first attempt at using the web browser control. Useful little item. Some items I've learned in playing with it: 1. The Navigate method...
Kinda reminds me of the good old days of using Procomm+ scripting language and DDE to write to spreadsheets from Dow Jones News Retrieval, all though a x.25...
FYI -- I ran into this introductory article on creating Web Queries and automating them: http://www.jkp-ads.com/Articles/WebQuery.htm The .SetParam method was...
... I've been migrating towards PHP for data extraction. It seems to work faster and if I format the output as a table, it can either go to the browser or...
Does anyone have/know where is any VBA code to make P&F charts in XL sheets? There seem to be several add-ins availabe (I don't mind paying), BUT you cannot...
Don't know if it will help, but here below some TAS code I used to use to generate P&F text charts. It basically steps through the historical data to create...
Randy, Ronald, Dick, and others, This may be of interest to you. I have no affiliation nor knowledge of this event other then receiving this reminder (BTW:...
If you are looking for a great P&F charting software try. http://www.stockblocks.com/ Insider TAT, developed by Stock Blocks, Inc., is an end-of-day...
My workbooks are becoming very bloated as I have upwards of 20 stock charts in each, each with several extra added series, some on the secondary axis. What I...
