hi randy, I was trying to use the rchgetyahooquotes function. The result is only displayed in the cell C3, where i enter the formula. My problem is that it...
11070
notkoushik
Aug 1, 2010 1:24 pm
Hi Randy, How do I use the ta-lib routines within the macro scripts? For instance: {TA_ATR(C10:C267,D10:D267,E10:E267,14)} works for me if I select the cells...
11071
Randy Harmelink
rharmelink
Aug 1, 2010 1:28 pm
When I looked at it in the past, I could not find a VBA reference library for the TA-Lib routines. If you're doing screening with TA, I would take a look at...
11072
Randy Harmelink
rharmelink
Aug 1, 2010 1:32 pm
You can't do a CONCATENATE() function on a range like that. The value of: =CONCATENATE(A3:A50,".BO") ...is simply: .BO ...which is not a valid ticker symbol,...
11073
Imran Naqvi
dillli_ka_ba...
Aug 1, 2010 1:38 pm
Oh, I see. Well, thanks, once again buddy. ... -- Ali Imran Naqvi 9327016964 "Smooth sea never makes a skillful mariner"...
11074
Felix bear
FTBear
Aug 1, 2010 2:09 pm
Thank you ... From: Randy Harmelink <rharmelink@...> Subject: Re: [smf_addin] Alternate data source To: smf_addin@yahoogroups.com Date: Saturday, July...
11075
krisha_mehta
Aug 2, 2010 3:27 am
I am unable to retreive data, but there is no error. My A7 cell has 'MSFT' and I expect this cell to show the description for MSFT? I am using Excel 2007, sp2...
11076
Randy Harmelink
rharmelink
Aug 2, 2010 3:30 am
It's because you're not using the proper double-quotes character to specify a string. Your subject line has: =RCHGetYahooQuotes(A7,”n”) It should be: ...
11077
Imran Naqvi
dillli_ka_ba...
Aug 2, 2010 6:06 am
Hey Randy, This command gives me the result as N/A, despite the fact that relevant yahoo field has data in it. =RCHGetYahooQuotes("532454.BO","o","in",NOW()) ...
11078
Randy Harmelink
rharmelink
Aug 2, 2010 6:18 am
Sorry, but the relevant Yahoo field does NOT have data in it. They do have it on the web page, but they're not providing it through their CSV file. When I...
11079
Imran Naqvi
dillli_ka_ba...
Aug 2, 2010 6:23 am
Ok great. Thanks. I was wondering if u had developed similar function for google quotes as well. ... -- Ali Imran Naqvi 9327016964 "Smooth sea never makes a...
11080
Randy Harmelink
rharmelink
Aug 2, 2010 6:29 am
They don't have a quotes file available, do they?...
11081
Imran Naqvi
dillli_ka_ba...
Aug 2, 2010 10:06 am
I dont not know about google. Anyways, is there any way I can extract the table from the following site: ...
11082
Don Guillett
donaldb36
Aug 2, 2010 1:38 pm
One way is with an external query. Don Guillett Microsoft MVP Excel SalesAid Software dguillett@... ... From: Imran Naqvi To: smf_addin@yahoogroups.com ...
11083
krisha_mehta
Aug 2, 2010 2:05 pm
I appreciate your prompt response, and you are right that was the problem. It works like a champ. Another question - How can I update Excel file every day (6...
11084
Randy Harmelink
rharmelink
Aug 2, 2010 3:38 pm
You'd need to write your own VBA (or other) routine to do that. Depending on what you're trying to get, you could just get the historical quotes using other...
11085
Randy Harmelink
rharmelink
Aug 2, 2010 3:41 pm
Just a straightforward use of the RCHGetHTMLTable() function. For example: =RCHGetHTMLTable(" ...
11086
Imran Naqvi
dillli_ka_ba...
Aug 2, 2010 4:48 pm
Hey Randy, this does not give me anything. Moreover, the cell I enter this formula into goes blank, even though I formula remains there. Where am I going...
11087
codyklein
Aug 2, 2010 5:30 pm
Using the above function if I try to get the info for SHW I get data for the Sherwood group on the LSE. If I change the symbol by adding the prefix NYSE:SHW...
11088
Randy Harmelink
rharmelink
Aug 2, 2010 6:24 pm
You need to array-enter it over a range....
11089
Randy Harmelink
rharmelink
Aug 2, 2010 6:31 pm
Using NYSE:SHW works for me. For example: =smfGetAdvFNElement("NYSE:SHW","A",2,"Total Revenue") ...returns: 7979.7...
11090
codyklein
Aug 2, 2010 7:12 pm
Yes, dumb formula mistake on my part....
11091
inglissr
Aug 2, 2010 7:57 pm
I get an 'error' message in cells that use the following formula to access data from ADVFN elements: =RCHGetElementNumber(Ticker,9506) I went to the ADVFN...
11092
Scott Inglis
inglissr
Aug 2, 2010 7:58 pm
Hi Randy - I am new member of the SMF Addin group and I am thrilled that I found you! I have been able to successfully install the add in and have been able to...
11093
jaja3279
Aug 2, 2010 8:00 pm
Hi, I just installed the add-in and tried the step-by-step example of creating a current quotes table with the command: "=RCHGetYahooQuotes(A2:A100,B1:M1)"...
11094
Randy Harmelink
rharmelink
Aug 2, 2010 8:00 pm
You need to use the new beta version of the add-in from the "Works in Progress" folder. I had to write a new function and redefine the AdvFN elements due to...
11095
Randy Harmelink
rharmelink
Aug 2, 2010 8:03 pm
Sounds like you didn't array-enter the function over the B2:M100 range....
11096
Steven
stevenletzer
Aug 2, 2010 8:03 pm
CNBC provides more comprehensive data than Morningstar for mutual fund holdings, and does not charge a fee. Morningstar premium members get the top 100...
11097
stu00537
Aug 2, 2010 8:43 pm
Hello, As far as I know, I have the most recent version of the add-in, but also had problems using the ADVFN elements today as well. It seems that the website...
11098
rafaelpin
Aug 2, 2010 8:48 pm
Hello, I just installed Win7 with Office 2010 64 bit. I copied the add-in files, but now opening any Excel file with SMFs crashes Excel. Opening Excel and...
