I am using the get yahoo quotes for all prices for a security. Does anyone know how to make it get only monthly quotes? If you look on the yahoo site, there...
14356
Randy Harmelink
rharmelink
May 1, 2011 9:24 pm
Check the documentation for the RCHGetYahooHistory() function. There is a parameter to get monthly data instead of daily....
14357
Aubrey Williams
aubreyfsu
May 1, 2011 11:22 pm
Thanks Randy...much appreciated! ________________________________ From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Sun, May 1,...
14358
bushpilote
May 2, 2011 3:13 pm
There's' no need to feel sorry. Thanks for your comments. I just have a bunch of quick observations on them. 1.I didn't think that I needed your permission to...
14359
Dan Micsa
dmicsa
May 2, 2011 7:32 pm
Is your Value Pro spreadsheet free? Can I see the calculation? I would say that many classic approaches doesn’t have much forecasting power anymore. I can...
Many thanks Randy for getting back to me and also for sharing this useful add-in. I'll have a look to the different web sites. 2011/4/30 Randy Harmelink...
14361
Pete
petekoch
May 3, 2011 12:25 am
Just a headsup on a website problem, not an SMF add-in problem. Just noticed this while looking at financials on the AdvFN site. Had occasion to look at the...
14362
Dan Micsa
dmicsa
May 3, 2011 11:13 am
Did a quick sanity check with this ranker at p123: <RankingSystem RankType="Higher"> <StockFormula Weight="100%" RankType="Higher" Name="Name" Description=""...
14363
bob_cutillo
May 3, 2011 1:02 pm
I am capturing the new 52 week highs data from this link http://www.barchart.com/stocks/high.php?_dtp1=0 and would like to get the "Date" the new highs are...
14364
bob_cutillo
May 3, 2011 1:09 pm
I am getting it thru RCHGetHTMLTable(""http://finance.yahoo.com/q/cq?&d=v6&s=" command but am looking to try it through smfUpdateDownloadTable. Is this...
In order to use the smfUpdateDownloadTable process, you would need to use functions that return a single item. So you would need to use RCHGetTableCell()...
14367
tfullert
May 4, 2011 2:21 pm
Is there a way to do postbacks through the SMF add-in? For example, this URL...
14368
Randy Harmelink
rharmelink
May 4, 2011 3:21 pm
Not that I'm aware of, but I'm not familiar with ASP processing......
14369
David
copthornelabs
May 4, 2011 3:49 pm
Randy, Has anyone developed a spreadsheet to get the MSN Stockscouter scores for a list of stocks? Can I array enter as with Yahoo, for a list of stocks? What...
14370
Fred Wright
fredwwright
May 4, 2011 5:03 pm
Dave - I think there are defined elements for the MSN Stockscouter 542 MSN2 StockScouter Rating -- Summary 543 MSN2 StockScouter Rating -- Current 544 MSN2...
14371
David
copthornelabs
May 4, 2011 5:18 pm
Thanks Fred, I was aware of the element numbers - how about the array entering? or getting a list of scores for a watchlist? My brain isnt letting me get to a...
14372
David
copthornelabs
May 4, 2011 5:33 pm
got the problem solved - sorry for being so slow....
14373
sandip patel
sandip2325
May 4, 2011 6:21 pm
Hi Randy, I am using RCHGetElementNumber & RCHGetYahooQuotes functions in my excel file. It is working fine, but it is updating data every few seconds. Is...
14374
bob_cutillo
May 4, 2011 6:32 pm
It works. Thank you....
14375
cletealbitz
May 4, 2011 6:38 pm
I am trying to download some fund information using the RCHGetElementNumber function. I am using excel with the formula: =RCHGetElementNumber(""&B10&"",4892)...
14376
Randy Harmelink
rharmelink
May 4, 2011 6:43 pm
As far as I know, you can only grab the StockScouter rating one at a time....
14377
Randy Harmelink
rharmelink
May 4, 2011 6:46 pm
There's nothing in the add-in processing that would do such automatic updating. It would have to be something that was added to the workbook....
14378
Randy Harmelink
rharmelink
May 4, 2011 6:51 pm
I just tried it for 10 ticker symbols and all of them came back fine. Can you give me some ticker symbols that give errors? Your formula doesn't need the...
14379
sandip patel
sandip2325
May 4, 2011 8:31 pm
There is a smfforcerecalculation mcaro in my excel ribbin. But I am not sure that would cause such a problem? I also dont remember, how i had added this to my...
14380
julien0986
May 4, 2011 9:58 pm
Hello everyone, I looked for a long time on internet but was not able to find any answer. Does anyone know how to introduce automatically in my excel...
14381
Randy Harmelink
rharmelink
May 4, 2011 10:00 pm
A macro on your ribbon/toolbar only runs when you click on the icon. It sound like you actually have a VBA timer routine running....
14382
Randy Harmelink
rharmelink
May 4, 2011 10:03 pm
Are you looking for weekly MACD and RSI over time, or ending MACD and RSI on weekly pricing data? Can you give me a URL with the bigcharts example of what...
14383
julien0986
May 5, 2011 5:18 am
Sure, hereby is the URL: ...
14384
Randy Harmelink
rharmelink
May 5, 2011 6:14 am
But are you simply looking for the ending values of MACD and RSI, or are you looking for the values over the entire charted weekly values of MACD and RSI? ...
