Jumat, 26 Desember 2014

[smf_addin] Digest Number 3276

5 Messages

Digest #3276
1a
Re: SMF Add In by "Kermit W. Prather" kermitpra
1b
Re: SMF Add In by "Bernie Dudek" berniedudek
1c
Re: SMF Add In by "Randy Harmelink" rharmelink
2a
2b
Re: SMF add-in on MAC by "Randy Harmelink" rharmelink

Messages

Thu Dec 25, 2014 11:26 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

I'll second that. Randy is amazing

Thank you, Randy and have a great holiday


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, December 24, 2014 5:35 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] SMF Add In


I would like to say Thank You and Happy Holidays to Randy…..for all the time and effort you have given to this group, it is very much appreciated!

Charlie

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, December 24, 2014 2:08 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In


Gotta make money if you want to be able to give some away! :)

On Wed, Dec 24, 2014 at 2:47 PM, Fred Rockwell fredmrockwell@... wrote:

It is Xmas eve, stop counting your money at the office Scrooge.



Thu Dec 25, 2014 1:28 pm (PST) . Posted by:

"Bernie Dudek" berniedudek

I'm still having trouble on figuring out how to code =RCHGetYahooQuotes to get the last price for IBM. I know the example you referenced me to show the last price as |1 but I can't find an element number for |1.

Thanks

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, December 24, 2014 4:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add In

Take a look at the RCHGetYahooQuotes() function. The documentation will have examples of using the function. There are also templates that show several examples of using the function.

A message on the group gives a quick step-by-step process of setting up a small table:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/124

On Wed, Dec 24, 2014 at 2:36 PM, 'Bernie Dudek' bdudek1172... wrote:

I want to update my portfolio with the closing price for the day. Are there any sample spreadsheets showing sample portfolios containing this information?

Thu Dec 25, 2014 2:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetYahooQuotes("IBM","l1")

That 2-charter "l1" a lower case letter L and a number 1. I'm assuming they
did it because it's kind of like, "Last one". :)

On Thu, Dec 25, 2014 at 2:29 PM, 'Bernie Dudek' bdudek1172@... wrote:

>
> I'm still having trouble on figuring out how to code =RCHGetYahooQuotes to
> get the last price for IBM. I know the example you referenced me to show
> the last price as |1 but I can't find an element number for |1.
>
>
>
>

Thu Dec 25, 2014 1:20 pm (PST) . Posted by:

lewglenn

Randy,

I have the feeling that you've answered this before but do you know whether your add-in works in VBA on the Mac OS X architecture?

If not, what calls might need to be re-written?

Thanks.


Thu Dec 25, 2014 2:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

In order to use it on the Mac, you need to run it under a simulated Windows
environment. The add-in has a number of calls to Microsoft's Windows
dynamic link libraries...

On Thu, Dec 25, 2014 at 2:20 PM, lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have the feeling that you've answered this before but do you know
> whether your add-in works in VBA on the Mac OS X architecture?
>
> If not, what calls might need to be re-written?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar