For a particular stock I would like to download the quote and a few other items from Yahoo. I can use one of the add-ins to do this, but I’d also like to...
6945
stevenletzer
Jul 1, 2009 2:10 pm
Thank you, your solution worked fine. I have another question. Change the fundid to 6098 - which is "Covered Call Select Closed-End, 13 Ticker: FCCAPX". A...
6946
Randy Harmelink
rharmelink
Jul 1, 2009 2:14 pm
Take a look at the RCHCreateComment() function. For example, this would display one of the many yearly charts by week that StockCharts has available: ...
6947
Randy Harmelink
rharmelink
Jul 1, 2009 2:25 pm
Using additional parameters with the same function, you can skip rows before picking up items. If you wanted to pick up everything cell by cell, you could use...
6948
Richard Copits
dickcopits
Jul 1, 2009 2:39 pm
OK. Thanks! To: smf_addin@yahoogroups.com From: rharmelink@... Date: Wed, 1 Jul 2009 07:14:15 -0700 Subject: Re: [smf_addin] Quote and chart question.......
6949
team1688
Jul 1, 2009 11:51 pm
I got N/A on above element for some symbols I got some yahoo quote element?...
6950
Randy Harmelink
rharmelink
Jul 2, 2009 12:12 am
In all probability, that's what Yahoo is sending. Since you didn't include ticker symbols, I can't check....
6951
team1688
Jul 2, 2009 1:40 am
... elements n p h g b b6 a a5 SMH ML SEMICOND HLDR1 21.45 22.13 21.5022 N/A N/A N/A N/A IBM INTL BUSINESS MAC 104.42 106.27 104.73 N/A N/A N/A N/A MCD...
6952
team1688
Jul 2, 2009 2:09 am
in the element list there are not too many quotes. Can one actually add to the element list? such other quote from different site?...
6953
Randy Harmelink
rharmelink
Jul 2, 2009 3:03 am
It is a Yahoo problem. "N/A" is what they're sending -- at least now in off hours. That may change when the market is open....
6954
Randy Harmelink
rharmelink
Jul 2, 2009 3:06 am
The only elements available from the Yahoo current quotes interface are the ones they provide. You can get quotes from other sites using other SMF functions,...
6955
Gyenese János
jgyenese
Jul 2, 2009 6:47 am
Hi All, I am looking for the daily Libor rates for the full termin (ON, 1w, ...) as in the historical Libor rates on the bbalibor.com. Unfortunately the...
6956
nigelfreder
Jul 3, 2009 3:35 pm
Hi there I'm looking for a way to pull EV/EBITDA, EPS and other ratios for the Yahoo industries and sectors (eg ^YHOh702 - Agricultural chemicals). For a stock...
6957
fincoolio
Jul 3, 2009 4:03 pm
hello, where can I find this smfForceRecalculation macro I see people referring to? I've installed the latest add-in and all the element numbers work fine. But...
6958
Randy Harmelink
rharmelink
Jul 3, 2009 4:09 pm
Macros from add-ins don't show up on the list of macros. But if you type the name in within the macro dialog, you'll see the "Run" button activate. I have...
6959
Randy Harmelink
rharmelink
Jul 3, 2009 4:28 pm
Does Yahoo even carry that data by industry and sector? Certainly not accessible via that ticker symbol. I do see "Agricultural chemicals" industry data on...
6960
fincoolio
Jul 3, 2009 5:02 pm
great, thanks....
6961
brigity10
Jul 4, 2009 3:47 am
Hi, I am new to this but think it could be very useful. I have a question about the Reuters site. I am trying to pull data from the financial highlights page...
6962
Randy Harmelink
rharmelink
Jul 4, 2009 4:19 am
You have an EXCEL issue, not a Reuters issue -- you need the "&Ticker" OUTSIDE of the string. That is, this: ...
6963
Randy Harmelink
rharmelink
Jul 4, 2009 4:08 pm
Many templates use a cell named "Ticker" to point to the cell containing the ticker symbol. If you are copying and pasting formulas from that template into a...
6964
mlast1
Jul 4, 2009 4:53 pm
Do any of the addins allow me to create a chart of a portfolio of stocks. EOD/weekly data would work great for my needs. The start dates for the stocks in the...
6965
Randy Harmelink
rharmelink
Jul 4, 2009 6:12 pm
I think it can do what you need, but I would need a better description to be sure. Especially with how you would handle the start dates being different. I...
6966
go_archi
Jul 4, 2009 8:08 pm
Hello, I'm newbie in this group and found some files of Randy. What does these topics mean. Didn't find any explanation Thanks Peter...
6967
Randy Harmelink
rharmelink
Jul 4, 2009 8:12 pm
Those are acronyms related to the Covered Call workbooks: RIU = Return If Unchanged (that is, the price of the underlying security) RIE = Return If Exercised...
6968
hjreed@...
hjreed...
Jul 5, 2009 5:03 am
I'm stuck. Using the RCHGetYahooHistory function, is there a way to get the daily volumes for the NYSE and the NASDAQ? I've used ticker ^NYA but it doesn't...
6969
Randy Harmelink
rharmelink
Jul 5, 2009 5:06 pm
Unfortunately, the RCHGetYahooHistory() function can only return the data that Yahoo is providing... You may be able to use something like this source: ...
6970
rlschmidt3
Jul 6, 2009 1:11 am
Randy: Is there an example of capturing the newly reformated IBD Stock Checkup data in a Horizontal line format for a limited list of stocks, one per line? I...
6971
Randy Harmelink
rharmelink
Jul 6, 2009 1:40 am
Here's the smfUpdateDownloadTable definition for Industry Group Rank that I did for an IBD group: RCHGetTableCell(" ...
6972
mlast1
Jul 7, 2009 12:30 am
Thanks. I will try the RCHGetYahooHistory() function....
6973
alagalah
Jul 7, 2009 2:54 pm
Hi there, I checked out http://finance.groups.yahoo.com/group/smf_addin/message/4563 but was wondering if there was a better way with 2.0j to extract JUST the...
