Rabu, 24 Januari 2018

[smf_addin] Digest Number 4297

13 Messages

Digest #4297
2a
Last price for a stock symbol by "Tony Costello" CostelloT
2b
Re: Last price for a stock symbol by "Randy Harmelink" rharmelink
2c
Re: Last price for a stock symbol by "Tony Costello" CostelloT
3b
Re: RCHGetElementNumber() returns "Error" by "Randy Harmelink" rharmelink
4a
Excel in office 2013 by "Bernie Dudek" berniedudek
4b
Re: Excel in office 2013 by "Randy Harmelink" rharmelink
4c
Re: Excel in office 2013 by "Bernie Dudek" berniedudek
4d
Re: Excel in office 2013 by "Randy Harmelink" rharmelink
4e
Re: Excel in office 2013 by "Bernie Dudek" berniedudek
4f
Re: Excel in office 2013 by "Randy Harmelink" rharmelink

Messages

Wed Jan 24, 2018 4:11 am (PST) . Posted by:

thefish8467

Hi All,


I was successful in installing the SMF Add-In for MAC 2016 Excel based on these instructions: http://ogres-crypt.com/SMF/Works-In-Progress/MAC-Instructions.html http://ogres-crypt.com/SMF/Works-In-Progress/MAC-Instructions.html


The latest version was successfully pulled in but then the worksheet that I worked on would not resolve - the links to the file were still windows path's and not mac. I fixed the link but the errors remained.


I then tried to uninstall the SMF Add-in by deleting the folder in my desktop area on the MAC and re-installed it on my MAC Hard Drive - now Excel will not allow me to do anything with the add-in loaded.


Where can I find the macro for MAC Excel shared in the instructions from Paul Dyson - that might be the problem? Can someone send me the link to that folder as I can not seem to find it on YAHOO, Ogres or anywhere else.


Much apprciated ... I will revert to my Windows 10 machine for now but would love to move all my work to the MAC.


Thanks,


David

Wed Jan 24, 2018 7:27 am (PST) . Posted by:

"Tony Costello" CostelloT

Hi Randy,    I have been using =smfGetYahooPortfolioView(A3:A68,"15",,1) to get the last price for a stock.  Column "A" contains the symbol.  I have multiple rows in my spreadsheet that contain the same symbol.  For example cells A4 an A5 both contain "NFLX".  The problem is that the last price for NFLX for cell A4 works fine but the last price for NFLX for cell A5 shows "--".  The pattern appears to be consistent in that the first unique symbol returns a value, but any subsequent rows with the same symbol do not return any values.
    I hope this explanation is clear, but let me know if you need any additional information.  Thank you for your time and this fantastic utility.
Tony

Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; ; ; 1)

Wed Jan 24, 2018 7:59 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If you want the function to return data for the same symbol multiple times,
you need to use a third parameter with a value of "Y".

On Wed, Jan 24, 2018 at 8:27 AM, Tony Costello costellot@
​...
wrote:

>
> I have been using =smfGetYahooPortfolioView(A3:A68,"15",,1) to get
> the last price for a stock. Column "A" contains the symbol. I have
> multiple rows in my spreadsheet that contain the same symbol. For example
> cells A4 an A5 both contain "NFLX". The problem is that the last price for
> NFLX for cell A4 works fine but the last price for NFLX for cell A5 shows
> "--". The pattern appears to be consistent in that the first unique symbol
> returns a value, but any subsequent rows with the same symbol do not return
> any values.
>
> I hope this explanation is clear, but let me know if you need any
> additional information. Thank you for your time and this fantastic utility.
>
> Tony
>
>
>
>
> Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\SMF Add-In;
> Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
>
>
>

Wed Jan 24, 2018 8:55 am (PST) . Posted by:

"Tony Costello" CostelloT

That worked!  Thanks again!


On Wednesday, January 24, 2018, 9:59:39 AM CST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

If you want the function to return data for the same symbol multiple times, you need to use a third parameter with a value of "Y".
On Wed, Jan 24, 2018 at 8:27 AM, Tony Costello costellot@​... wrote:

    I have been using =smfGetYahooPortfolioView(A3: A68,"15",,1) to get the last price for a stock.  Column "A" contains the symbol.  I have multiple rows in my spreadsheet that contain the same symbol.  For example cells A4 an A5 both contain "NFLX".  The problem is that the last price for NFLX for cell A4 works fine but the last price for NFLX for cell A5 shows "--".  The pattern appears to be consistent in that the first unique symbol returns a value, but any subsequent rows with the same symbol do not return any values.

    I hope this explanation is clear, but let me know if you need any additional information.  Thank you for your time and this fantastic utility.
Tony

Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; ; ; 1)

Wed Jan 24, 2018 7:50 am (PST) . Posted by:

udpolo15

Hello I recently reinstalled the SMF Add In and I am now alll of my RCHGetElement Number() functions display "Error" in the cell. i have tried different datasources and Ticker Symbols. Any suggestions?


Chris

Wed Jan 24, 2018 8:02 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Usually, "Error" means a basic problem like a web page not existing or
something preventing the add-in from accessing the Internet. Do any other
functions work?

On Wed, Jan 24, 2018 at 7:06 AM, udpolo15@
​...
wrote:

>
> I recently reinstalled the SMF Add In and I am now alll of my
> RCHGetElement Number() functions display "Error" in the cell.. i have tried
> different datasources and Ticker Symbols. Any suggestions?
>
>
>

Wed Jan 24, 2018 10:19 am (PST) . Posted by:

udpolo15

I have tried a couple other functions from the templates and get the same error. I will try a different internet connection later. Thanks.

Chris

Wed Jan 24, 2018 1:53 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Randy –

Does the smf add-in function work in excel in office 2013?

Bernie

Wed Jan 24, 2018 2:11 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't think of a reason why it wouldn't.

On Wed, Jan 24, 2018 at 2:53 PM, 'Bernie Dudek' bdudek1172@
​...
wrote:

>
>
> Does the smf add-in function work in excel in office 2013?
>
>
>

Wed Jan 24, 2018 2:53 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Having trouble. Where can I get your sample spreadsheet to try it out?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, January 24, 2018 4:12 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Excel in office 2013

I can't think of a reason why it wouldn't.

On Wed, Jan 24, 2018 at 2:53 PM, 'Bernie Dudek' bdudek1172@

​....

wrote:

Does the smf add-in function work in excel in office 2013?

Wed Jan 24, 2018 3:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

There isn't a "sample" spreadsheet. The add-in and a number of templates
are on the website.

On Wed, Jan 24, 2018 at 3:53 PM, 'Bernie Dudek' bdudek1172@
​...
wrote:

>
> Having trouble. Where can I get your sample spreadsheet to try it out?
>
>
>

Wed Jan 24, 2018 3:16 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

Thanks. How do I get to them?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, January 24, 2018 5:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Excel in office 2013

There isn't a "sample" spreadsheet. The add-in and a number of templates are on the website.

On Wed, Jan 24, 2018 at 3:53 PM, 'Bernie Dudek' bdudek1172@

​...

wrote:

Having trouble. Where can I get your sample spreadsheet to try it out?

Wed Jan 24, 2018 3:25 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This should be at the bottom of the group messages:

For the Add-in, Documentation, Templates, Tips and FAQs, visit
http://ogres-crypt.com/SMF

On Wed, Jan 24, 2018 at 4:16 PM, 'Bernie Dudek' bdudek1172@
​...
wrote:

>
> Thanks. How do I get to them?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.06

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)