hi, i'm new to this group, having seen a mention of it in the thinkscript group's discussions. i downloaded the addin to the std directory and downloaded a...
I believe the problem is that you are using "today" as a date in the smfPricesByDates() functions. I'll assume that means either the NOW() or the TODAY()...
... Ifound this Macro on Yahoo Answers: It makes all tickers blue I don't know how insert a URL maybe you could have a look: Sub ConvertToHyperlink() Dim rng...
You would need to modify the "rng" and "URL" values to be what you need them to be. Like I said, I personally prefer to use the hyperlink function in a new...
As mentioned, you can use a toggle switch to indicate whether the data should be retrieved. The disadvantage is that the data isn't available except when you...
Randy, I am having difficulty getting the RCHGetYahooHistory function to work. I have been using your excellent Add In successfully for months but when I try...
Some scanners can create an Excel spreadsheet from a scanned image - this would save you the trouble of manual entry. There are various software packages that...
Does anyone know if it is possible to retrieve the following information. Say my stop loss is 10 as example. How can I find the SPECIFIC DAY OF THE MONTH and...
Randy, the Add In has been installed and working fine for months. I tried downloading the sample spreadsheet that retrieved historical quotes for CLDN for June...
goto yahoo finance and you will find 2 symbols for cldn cldn.L cldn.F Don Guillett SalesAid Software dguillett1@... From: GaryFera Sent: Friday, December...
You probably just have unresolved links causing a location error. See the "Location Errors" item in the "Links" area of the group. It's an issue with how EXCEL...
I am also having the same issue. My excel which was working until a month ago, stopped working. "RCHGetYahooHistory" is producing "#NAME?" for IBM and all...
Are you getting when opening a new workbook and entering the formula, or when opening a template? If the latter, you may just have link errors that need to be...
I got it to work URL = "http://finviz.com/quote.ashx?t=" + cell.Value + "&ty=c&ta=1&p=d" End If I inserted a new column then copy tickers over, Run macro...
Hi All, Could somebody please tell me the correct installation place for the add-in. I have downloaded a few files and some have the add in at C:\Program...
To confirm, I've been informed, at long last, by Yahoo "customer care" that they are no longer allowed to provide downloads of historical quotes of Dow Jones...
