5 Messages
Digest #4235
Messages
Mon Nov 13, 2017 4:25 pm (PST) . Posted by:
"Craig Passow" passow
It appears like your data field identifiers (87, 15, 17, 52) are in Row
2 and you're specifying the row headers to be included, so try this:
{=smfGetYahooPortfolioView(A3:A6,B2:E2,,1)} as an array entered with B-E
3-6 highlighted, then Crl-Shft-Enter
On 11/13/2017 5:59 PM, lk1_2000@yahoo.com [smf_addin] wrote:
>
>
> Version 2.1.2017.11.11
>
> Windows 7
>
> Excel 2003
>
>
> I'm trying to make an array of about 25 Mutual Funds and Stocks, with
> the following fields:
>
>
> Trade Date/Time
>
> Last Trade
>
> Change
>
> Change %.
>
>
> {=smfGetYahooPortfolioView(A4:A6,B3:E3,,1)} as an array entered with
> B-E 4-6 highlighted, then Crl-Shft-Enter, results in all "--"
>
>
>
> 87 15 17 52
> Ticker Trade Date/Time Last Trade Change Change %
> WMCVX -- -- -- --
> OAKLX -- -- -- --
> OAKBX -- -- -- --
>
>
> What am I doing wrong?
>
>
2 and you're specifying the row headers to be included, so try this:
{=smfGetYahooPortfolioView(A3:A6,B2:E2,,1)} as an array entered with B-E
3-6 highlighted, then Crl-Shft-Enter
On 11/13/2017 5:59 PM, lk1_2000@yahoo.com [smf_addin] wrote:
>
>
> Version 2.1.2017.11.
>
> Windows 7
>
> Excel 2003
>
>
> I'm trying to make an array of about 25 Mutual Funds and Stocks, with
> the following fields:
>
>
> Trade Date/Time
>
> Last Trade
>
> Change
>
> Change %.
>
>
> {=smfGetYahooPortfo
> B-E 4-6 highlighted, then Crl-Shft-Enter, results in all "--"
>
>
>
> 87 15 17 52
> Ticker Trade Date/Time Last Trade Change Change %
> WMCVX -- -- -- --
> OAKLX -- -- -- --
> OAKBX -- -- -- --
>
>
> What am I doing wrong?
>
>
Mon Nov 13, 2017 4:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
As Craig noted, your formula doesn't appear match your example.
Array-entering this over the B3:E6 range:
=smfGetYahooPortfolioView(A4:A6,B2:E2,,1)
...gives me:
87 15 17 52
*Ticker* *Last Traded Date/Time* *Last Price* *Change* *% Chg*
WMCVX 2017-11-13 06:45 PM $7.95 $0.03 0.379%
OAKLX 2017-11-13 06:45 PM $48.55 -$0.21 -0.431%
OAKBX 2017-11-13 06:45 PM $33.86 $0.01 0.030%
On Mon, Nov 13, 2017 at 4:59 PM, lk1_2000@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Version 2.1.2017.11.11
>
> Windows 7
>
> Excel 2003
>
> I'm trying to make an array of about 25 Mutual Funds and Stocks, with the
> following fields:
>
> Trade Date/Time
>
> Last Trade
>
> Change
>
> Change %.
>
> {=smfGetYahooPortfolioView(A4:A6,B3:E3,,1)} as an array entered with B-E
> 4-6 highlighted, then Crl-Shft-Enter, results in all "--"
>
>
> 87 15 17 52
> Ticker Trade Date/Time Last Trade Change Change %
> WMCVX -- -- -- --
> OAKLX -- -- -- --
> OAKBX -- -- -- --
>
> What am I doing wrong?
>
Array-entering this over the B3:E6 range:
=smfGetYahooPortfolioView(A4:A6,B2:E2,,1)
...gives me:
87 15 17 52
*Ticker* *Last Traded Date/Time* *Last Price* *Change* *% Chg*
WMCVX 2017-11-13 06:45 PM $7.95 $0.03 0.379%
OAKLX 2017-11-13 06:45 PM $48.55 -$0.21 -0.431%
OAKBX 2017-11-13 06:45 PM $33.86 $0.01 0.030%
On Mon, Nov 13, 2017 at 4:59 PM, lk1_2000@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Version 2.1.2017.11.
>
> Windows 7
>
> Excel 2003
>
> I'm trying to make an array of about 25 Mutual Funds and Stocks, with the
> following fields:
>
> Trade Date/Time
>
> Last Trade
>
> Change
>
> Change %.
>
> {=smfGetYahooPortfo
> 4-6 highlighted, then Crl-Shft-Enter, results in all "--"
>
>
> 87 15 17 52
> Ticker Trade Date/Time Last Trade Change Change %
> WMCVX -- -- -- --
> OAKLX -- -- -- --
> OAKBX -- -- -- --
>
> What am I doing wrong?
>
Mon Nov 13, 2017 5:48 pm (PST) . Posted by:
lk1_2000
Thank you, Craig and Randy! That worked perfectly! I knew it had to be something simple. Beautiful!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
As Craig noted, your formula doesn't appear match your example. Array-entering this over the B3:E6 range:
=smfGetYahooPortfolioView(A4:A6,B2:E2,,1)
...gives me:
87 15 17 52 Ticker Last Traded Date/Time Last Price Change % Chg WMCVX 2017-11-13 06:45 PM $7.95 $0.03 0.379% OAKLX 2017-11-13 06:45 PM $48.55 -$0.21 -0.431% OAKBX 2017-11-13 06:45 PM $33.86 $0.01 0.030%
On Mon, Nov 13, 2017 at 4:59 PM, lk1_2000@... mailto:lk1_2000@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Version 2.1.2017.11.11
Windows 7
Excel 2003
I'm trying to make an array of about 25 Mutual Funds and Stocks, with the following fields:
Trade Date/Time
Last Trade
Change
Change %.
{=smfGetYahooPortfolioView(A4:A6,B3:E3,,1)} as an array entered with B-E 4-6 highlighted, then Crl-Shft-Enter, results in all "--"
87 15 17 52 Ticker Trade Date/Time Last Trade Change Change % WMCVX -- -- -- -- OAKLX -- -- -- -- OAKBX -- -- -- -- What am I doing wrong?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
As Craig noted, your formula doesn't appear match your example. Array-entering this over the B3:E6 range:
=smfGetYahooPortfolioView(A4:A6,B2:E2,,1)
...gives me:
87 15 17 52 Ticker Last Traded Date/Time Last Price Change % Chg WMCVX 2017-11-13 06:45 PM $7.95 $0.03 0.379% OAKLX 2017-11-13 06:45 PM $48.55 -$0.21 -0.431% OAKBX 2017-11-13 06:45 PM $33.86 $0.01 0.030%
On Mon, Nov 13, 2017 at 4:59 PM, lk1_2000@... mailto:lk1_2000@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Version 2.1.2017.11.
Windows 7
Excel 2003
I'm trying to make an array of about 25 Mutual Funds and Stocks, with the following fields:
Trade Date/Time
Last Trade
Change
Change %.
{=smfGetYahooPortfo
87 15 17 52 Ticker Trade Date/Time Last Trade Change Change % WMCVX -- -- -- -- OAKLX -- -- -- -- OAKBX -- -- -- -- What am I doing wrong?
Mon Nov 13, 2017 4:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
As far as I know, MSNMoneyCentral Investor Stock Quotes was not "native"
to EXCEL.
Basically, you'll need to install the latest version of the add-in
(2017.11.11) and use the new smfGetYahooPortfolioView() function. You could
grab the example workbook from the blog or the website.
Basically, your array-entered:
=RCHGetYahooQuotes(A2:A20,B1:B1)
...would become either of these, array-entered:
=smfGetYahooPortfolioView(A2:A20,"15")
...or:
=smfGetYahooPortfolioView(A2:A20,B1:B1)
...with a string value of "15" in cell B15
On Mon, Nov 13, 2017 at 3:21 PM, cutler@
...
wrote:
>
> Thank you very much for answering. Sorry, yes it is RCHGetYahooQuotes(),
> which I have discovered calls
>
> http://download.finance.yahoo.com/d/quotes.csv?s=
>
> And this returns:
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.com.
>
> You refer to a Blog but I looked at that and did not see information that
> I found very helpful. Let me be more clear (and honest). I frankly do not
> understand how this spreadsheet works, even though I wrote it (many years
> ago). I got it to work by copying stuff I didn't understand. In
> particular, the call to RCHGetYahooQuotes is in the context of an array
> operation that I don't understand the syntax of. Specifically, {
>
> =RCHGetYahooQuotes(A2:A20,B1:B1)} with a |1 in B1. I'm sorry, I don't
> understand that.
>
> What I want to do seems simple (sort of). I have a list of stock names
> (VTSAX,VAIPX,VTIAX,BWX,VGSLX,VGHAX,VGELX,CVX,VPMAX to be specific) in
> cells A2-A10. I would like the stock prices to appear in B2-B10 so that I
> can pick them up from other worksheets in the spreadsheet. This seems like
> a modest goal, and I am even willing to put the stock names in by hand one
> by one instead of reading them from cells (since I don't change these
> stocks very often). The smf_addin approach seems extremely complicated to
> me, but that was OK by me as long as it worked.
>
> I have also tried to use
>
> MSNMoneyCentral Investor Stock Quotes, which Excel provides natively, but
> I haven't been able to make that work either. It returns an error message
> saying that it can't respond or something like that.
>
> I'm using Excel 2010 on Win 10.
>
>
>
to EXCEL.
Basically, you'll need to install the latest version of the add-in
(2017.11.11) and use the new smfGetYahooPortfolioView() function. You could
grab the example workbook from the blog or the website.
Basically, your array-entered:
=RCHGetYahooQuotes(A2:A20,B1:B1)
...would become either of these, array-entered:
=smfGetYahooPortfolioView(A2:A20,"15")
...or:
=smfGetYahooPortfolioView(A2:A20,B1:B1)
...with a string value of "15" in cell B15
On Mon, Nov 13, 2017 at 3:21 PM, cutler@
...
wrote:
>
> Thank you very much for answering. Sorry, yes it is RCHGetYahooQuotes(),
> which I have discovered calls
>
> http://download.finance.yahoo.com/d/quotes.csv?s=
>
> And this returns:
>
> It has come to our attention that this service is being used in violation
> of the Yahoo Terms of Service. As such, the service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.
>
> You refer to a Blog but I looked at that and did not see information that
> I found very helpful. Let me be more clear (and honest). I frankly do not
> understand how this spreadsheet works, even though I wrote it (many years
> ago). I got it to work by copying stuff I didn't understand. In
> particular, the call to RCHGetYahooQuotes is in the context of an array
> operation that I don't understand the syntax of. Specifically, {
>
> =RCHGetYahooQuotes(
> understand that.
>
> What I want to do seems simple (sort of). I have a list of stock names
> (VTSAX,VAIPX,
> cells A2-A10. I would like the stock prices to appear in B2-B10 so that I
> can pick them up from other worksheets in the spreadsheet. This seems like
> a modest goal, and I am even willing to put the stock names in by hand one
> by one instead of reading them from cells (since I don't change these
> stocks very often). The smf_addin approach seems extremely complicated to
> me, but that was OK by me as long as it worked.
>
> I have also tried to use
>
> MSNMoneyCentral Investor Stock Quotes, which Excel provides natively, but
> I haven't been able to make that work either. It returns an error message
> saying that it can't respond or something like that.
>
> I'm using Excel 2010 on Win 10.
>
>
>
Mon Nov 13, 2017 4:33 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
As I indicated with the link I sent, EXCEL is probably not allowing the
add-in to be loaded automatically, because of the Microsoft security
update. Their work-around is to unblock the XLA file.
Unless I am misunderstanding your reference to "existing link"? If you are
referring to unresolved links in the worksheet (i.e. disk locations in
front of function invocations), you may simply need to run the smfFixLinks
macro.
On Mon, Nov 13, 2017 at 4:03 PM, Thomas J Strouse thomas.strouse@
...
wrote:
>
> Thanks so much! I now have the M* 10-year data!
>
> Not catching the wrong directory structure is embarrassing!!! However, I
> still have to select ALT+T+I to get the Add-Ins window, browse to the
> correct Add-In directory location (C\SMF Add-In) and overwrite the existing
> link to get rid of the #NAME? error. Below is the Excel Options Add-in
> screen:
>
> [image: Inline image 1]
>
> Does it have anything to do with my dir structure?
>
> [image: Inline image 2]
>
> [image: Inline image 3]
>
>
>
add-in to be loaded automatically, because of the Microsoft security
update. Their work-around is to unblock the XLA file.
Unless I am misunderstanding your reference to "existing link"? If you are
referring to unresolved links in the worksheet (i.e. disk locations in
front of function invocations)
macro.
On Mon, Nov 13, 2017 at 4:03 PM, Thomas J Strouse thomas.strouse@
...
wrote:
>
> Thanks so much! I now have the M* 10-year data!
>
> Not catching the wrong directory structure is embarrassing!
> still have to select ALT+T+I to get the Add-Ins window, browse to the
> correct Add-In directory location (C\SMF Add-In) and overwrite the existing
> link to get rid of the #NAME? error. Below is the Excel Options Add-in
> screen:
>
> [image: Inline image 1]
>
> Does it have anything to do with my dir structure?
>
> [image: Inline image 2]
>
> [image: Inline image 3]
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar