Search results

Lol SirJB7, Not speaking to you for nearly three days is most disappointing :>) the setup of the spreadsheet I would like is as follows: (1) Ticker name in column A, following by all the stock names underneath as follows: AAC ABC ACR AGK AIX AMC AMP ANN ANZ APA ARG ASB...

Hi SirJB7, This is the last try as I do not want this to be a never ending saga, after going through this code at length it appears that it does gat all the data from Yahoo but sends this data to hidden Excel sheets, and Finviz web page. Also the tickers, stock exchange, Indice appear to be on...

Hi SirJB7, The above file.code does achieve what I was looking for, it only provides Stock Code, Name and last trade details, not details of data for the 81 columns listed in the Stockscreener spreadsheet. Does the code for this spreadsheet only extract the codes and stock names from Google...

Hi Narayan, Thanks for agreeing with me that the project is not password protected, and that VBA code in all six VBA modules can be accessed without restriction. Yes I did asked them the same queries I posted in this forum, in the...

Hi Narayan, Yes the excel spreadsheet is the same, when you select f11 can you access the VBA code in the six VBA modules, or are they password protected. On my copy that I downloaded they are are not password protected. SirJB7, can you please use the url...

Hi SirJB7, I have changed the folder access rights from private to shared, hopefully you can now access the file via: http://rapidshare.com/files/308304725/Stock%20Screener.xls Regards, Ballterrier

Hi SirJB7, Please use the following link to access the excel file: http://rapidshare.com/files/308304725/Stock%20Screener.xls. What I would like to achieve is: (1) Download the same data from yahoo and/or another site for the same column headers as displayed in the spreadsheet ( I think...

Hi DaveTurton, I am only an old pensioner that does not know much about vba code or VBA Projects, the stock screener project is called Stock Screener.xls, which has no password on it ? The are seven vba modules as follows that are not locked: > modExtractData > modGetCSVFile &#62...

The Excel spreadsheet (ie download stockscreener) is not password protected, I just checked again. Thanks for the links I will check the out,

Hi , I did not receive a reply to my above email does anyone know how to extract the same stock data for Australian stocks from Yahoo, in regards to the excel spreadsheet and associated VBA code via the following link: http://investexcel.net/2487/stock-screener-excel/#comment-3819. Which...

Hi Chandoo, Below is a link to a free excel spreadsheet I downloaded, from the net as a free excel spreadsheet (ie stock screener), which has the necessary vba code to download stock data to excel, by extracting data from Yahoo & finviz sites. However I would like to know if this is possible...

Hi, Does anyone know why there are no Yahoo tag codes to download 1 mth, 3 mths, 1yr & 5yrs performance data. Does anyone know how to extract this data from Yahoo in csv format. There are 80 other tag codes, but I cannot see any for the above 4. Any help with this would be appreciated.

How can I dynamically display the Top ten credit values over four columns of data, and/or for each of the four columns seperately. Each column will have multiple debit or credit percentage values, data in each column will be for monthly, quarterly, yearly and five years data. Any...