7 Messages
Digest #4190
Messages
Wed Nov 1, 2017 3:56 pm (PDT) . Posted by:
smmarder
I have the same problem - I hope it is a temp Yahoo problem??!!!
Wed Nov 1, 2017 4:23 pm (PDT) . Posted by:
midhenry1
I still get all blanks.
Here is the version reported (which does work)
Stock Market Functions add-in, Version 2.1.2017.10.24 (C:\SMFtest Add-in; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
Here is the version reported (which does work)
Stock Market Functions add-in, Version 2.1.2017.10.
Wed Nov 1, 2017 4:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It wasn't a fix for RCHGetYahooQuotes(). It was to provide a work-around
until Yahoo fixes their problem with current quotes.
On Wed, Nov 1, 2017 at 4:22 PM, midhenry1@
...
wrote:
>
> I still get all blanks.
>
> Here is the version reported (which does work)
> Stock Market Functions add-in, Version 2.1.2017.10.24 (C:\SMFtest Add-in;
> Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
>
until Yahoo fixes their problem with current quotes.
On Wed, Nov 1, 2017 at 4:22 PM, midhenry1@
...
wrote:
>
> I still get all blanks.
>
> Here is the version reported (which does work)
> Stock Market Functions add-in, Version 2.1.2017.10.
> Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
>
Wed Nov 1, 2017 4:37 pm (PDT) . Posted by:
john_hoel
I downloaded your example workbook of smfGetYahooPortfolioView() and tried to use it as a guide. I have never coded array-entry so I simply copied every cell as shown in your example. All I got was "Symbol" in every cell.
Is there a tutorial anywhere that explains how to do array entry, and that would be applicable to this situation?
Is there a tutorial anywhere that explains how to do array entry, and that would be applicable to this situation?
Wed Nov 1, 2017 4:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you enter the smfGetYahooPortfolioView() formula in a single cell,
you'll only get the value in the first row and column of the requested
array of data.
To array-enter a formula in EXCEL, first *highlight the range* of cells
where you would like the returned data to appear -- the number of rows for
the range should be AT LEAST the number of ticker symbols you are
requesting from the function, while the number of columns for the range
should be AT LEAST the number of data items you are requesting for each
ticker symbol from the function. Next, enter your formula and then *press
Ctrl-Shift-Enter*.
For the example I gave on the blog:
1. Highlight a 3 row (2 tickers symbols + header row) by 3 column (3 data
items) range.
2. Type in or paste the formula:
=smfGetYahooPortfolioView("MMM,IBM","010215",,1)
3. Press Ctrl+shift+enter
Symbol Long Name Last Price
MMM 3M Company 230.18
IBM International Business Machines Corporation 154.03
Note that an array-entered range cannot be sorted.
On Wed, Nov 1, 2017 at 4:37 PM, john@
...
wrote:
>
> I downloaded your example workbook of smfGetYahooPortfolioView() and tried
> to use it as a guide. I have never coded array-entry so I simply copied
> every cell as shown in your example. All I got was "Symbol" in every cell.
>
> Is there a tutorial anywhere that explains how to do array entry, and that
> would be applicable to this situation?
>
you'll only get the value in the first row and column of the requested
array of data.
To array-enter a formula in EXCEL, first *highlight the range* of cells
where you would like the returned data to appear -- the number of rows for
the range should be AT LEAST the number of ticker symbols you are
requesting from the function, while the number of columns for the range
should be AT LEAST the number of data items you are requesting for each
ticker symbol from the function. Next, enter your formula and then *press
Ctrl-Shift-Enter*
For the example I gave on the blog:
1. Highlight a 3 row (2 tickers symbols + header row) by 3 column (3 data
items) range.
2. Type in or paste the formula:
=smfGetYahooPortfol
3. Press Ctrl+shift+enter
Symbol Long Name Last Price
MMM 3M Company 230.18
IBM International Business Machines Corporation 154.03
Note that an array-entered range cannot be sorted.
On Wed, Nov 1, 2017 at 4:37 PM, john@
...
wrote:
>
> I downloaded your example workbook of smfGetYahooPortfoli
> to use it as a guide. I have never coded array-entry so I simply copied
> every cell as shown in your example. All I got was "Symbol" in every cell.
>
> Is there a tutorial anywhere that explains how to do array entry, and that
> would be applicable to this situation?
>
Wed Nov 1, 2017 6:54 pm (PDT) . Posted by:
"Joe Mo" joe_mo37
Randy,I downloaded the 2.1.2017.10.31 zip file from your link, closed Excel, put the new version in my smf folder and restarted Excel. Now, =RCHGetElementNumber("Version") is returning:
Stock Market Functions add-in, Version 2.1.2017.10.24 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.01; 14.0; ; ; 1)
not 10.31. Is 10.24 the correct version despite the discrepancy?
As always, many thanks for your expertise and dedication!
Stock Market Functions add-in, Version 2.1.2017.10.
not 10.31. Is 10.24 the correct version despite the discrepancy?
As always, many thanks for your expertise and dedication!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar