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...
Take a look at the RCHCreateComment() function. For example, this would display one of the many yearly charts by week that StockCharts has available: ...
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...
... 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...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Unfortunately, the RCHGetYahooHistory() function can only return the data that Yahoo is providing... You may be able to use something like this source: ...
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...
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...
The message you refer to is using Smart Money because that person felt they were the best source for getting competitors. The information can vary quite a bit...
