Selasa, 21 Juli 2015

[smf_addin] Digest Number 3464

15 Messages

Digest #3464
4b
Re: Help for a new user in the United Kingdom by "Randy Harmelink" rharmelink

Messages

Tue Jul 21, 2015 5:31 am (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

Well, I've tried repeatedly to update the xla file, opening and closing Excel, even rebooting the computer and I still show the old version. Inactivating it and activating it again. And it still works, but the only version for it to see is the new one. Don't get it.

Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\Program Files\SMF Add-In; ; ; 1)

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 20, 2015 11:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: FW: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Did you exit EXCEL before you updated the XLA? EXCEL only loads add-ins at start-up time.

Check the version EXCEL is using with:

=RCHGetElementNumber("Version")

BTW, it takes me about 60 seconds to get the whole template calculated.

On Mon, Jul 20, 2015 at 8:43 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

OK, I see I needed to update the xla as of 7/8/2015. Did that and re-Browsed to the Add-In file, etc.

But I'm getting #NAME in every cell of the smfGetGuruFocusItem-Full-Template.xls when I open it.

All the data is there for MMM until I Enable Editing. Then it goes fubar.

What am I missing?

Tue Jul 21, 2015 6:16 am (PDT) . Posted by:

"Jim Ranum" amt2100

A good night sleep fixes many computer problems…

Got the new version working.

Best regards,

Jim

From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Tuesday, July 21, 2015 8:31 AM
To: 'smf_addin@yahoogroups.com'
Subject: RE: FW: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Hi Randy,

Well, I've tried repeatedly to update the xla file, opening and closing Excel, even rebooting the computer and I still show the old version. Inactivating it and activating it again. And it still works, but the only version for it to see is the new one. Don't get it.

Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\Program Files\SMF Add-In; ; ; 1)

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 20, 2015 11:49 PM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: FW: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Did you exit EXCEL before you updated the XLA? EXCEL only loads add-ins at start-up time.

Check the version EXCEL is using with:

=RCHGetElementNumber("Version")

BTW, it takes me about 60 seconds to get the whole template calculated.

On Mon, Jul 20, 2015 at 8:43 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

OK, I see I needed to update the xla as of 7/8/2015. Did that and re-Browsed to the Add-In file, etc.

But I'm getting #NAME in every cell of the smfGetGuruFocusItem-Full-Template.xls when I open it.

All the data is there for MMM until I Enable Editing. Then it goes fubar.

What am I missing?

Tue Jul 21, 2015 7:15 am (PDT) . Posted by:

"Jim Ranum" amt2100

Hi Randy,

So it's kind of working, but I'm not getting results in all the cells. The years left of 2010 all say "Premium". I am logged in to Gurufocus through Excel.

So not sure why I'm getting this.

MMM

Fiscal Periods

Dec00

Dec01

Dec02

Dec03

Dec04

Dec05

Dec06

Dec07

Dec08

Dec09

Dec10

Dec11

Dec12

Dec13

Dec14

TTM

Mar13

Jun13

Sep13

Dec13

Mar14

Jun14

Sep14

Dec14

Mar15

Revenue per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

36.75

41.18

42.52

44.51

48.07

48.14

10.87

11.09

11.44

11.11

11.61

12.24

12.37

11.86

11.67

EBITDA per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

9.75

10.37

11.1

11.65

12.95

13.06

2.84

2.93

3.02

2.86

3.08

3.34

3.43

3.1

3.19

EBIT per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

8.16

8.59

9.22

9.61

10.78

10.89

2.34

2.43

2.51

2.32

2.54

2.79

2.89

2.55

2.66

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 20, 2015 7:18 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus - again - data from TTM column on Financials page

The new function/formula automates it completely. For example, that "Revenue per Share" row has these formulas:

=smfGetGuruFocusItem(Ticker,1,"L")
=smfGetGuruFocusItem(Ticker,1,"A",14)
=smfGetGuruFocusItem(Ticker,1,"A",13)
=smfGetGuruFocusItem(Ticker,1,"A",12)
=smfGetGuruFocusItem(Ticker,1,"A",11)
=smfGetGuruFocusItem(Ticker,1,"A",10)
=smfGetGuruFocusItem(Ticker,1,"A",9)
=smfGetGuruFocusItem(Ticker,1,"A",8)
=smfGetGuruFocusItem(Ticker,1,"A",7)
=smfGetGuruFocusItem(Ticker,1,"A",6)
=smfGetGuruFocusItem(Ticker,1,"A",5)
=smfGetGuruFocusItem(Ticker,1,"A",4)
=smfGetGuruFocusItem(Ticker,1,"A",3)
=smfGetGuruFocusItem(Ticker,1,"A",2)
=smfGetGuruFocusItem(Ticker,1,"A",1)
=smfGetGuruFocusItem(Ticker,1,"A",0)
=smfGetGuruFocusItem(Ticker,1,"TTM")
=smfGetGuruFocusItem(Ticker,1,"Q",8)
=smfGetGuruFocusItem(Ticker,1,"Q",7)
=smfGetGuruFocusItem(Ticker,1,"Q",6)
=smfGetGuruFocusItem(Ticker,1,"Q",5)
=smfGetGuruFocusItem(Ticker,1,"Q",4)
=smfGetGuruFocusItem(Ticker,1,"Q",3)
=smfGetGuruFocusItem(Ticker,1,"Q",2)
=smfGetGuruFocusItem(Ticker,1,"Q",1)
=smfGetGuruFocusItem(Ticker,1,"Q",0)

The "L" is for the label, "A"nnual periods from 14 thru 0 (0=current FY), "TTM" for TTM value, "Q"uarterly periods from 8 to 0 (0=current FQ).

The second parameter varies from 0 to 185, for the various line items I found on GuruFocus (including a few that are specific to financial companies). I should be able to expand that if I missed any, or if they add any. The function shouldn't care how many years or quarters they carry, but it does requires the same layout of a line -- annuals, TTM, quarters.

Each formula stands on its own, so you can cut and paste whichever columns/rows/sections you'd like. Here's one that has 15 years of data:

MMM

Fiscal Periods

Dec00

Dec01

Dec02

Dec03

Dec04

Dec05

Dec06

Dec07

Dec08

Dec09

Dec10

Dec11

Dec12

Dec13

Dec14

TTM

Mar13

Jun13

Sep13

Dec13

Mar14

Jun14

Sep14

Dec14

Mar15

Revenue per Share

20.91

20.07

20.65

22.92

25.12

27.09

30.12

33.42

35.73

32.72

36.75

41.18

42.52

44.51

48.07

48.14

10.87

11.09

11.44

11.11

11.61

12.24

12.37

11.86

11.67

EBITDA per Share

5.14

4.25

5.11

5.92

7.06

7.55

8.97

10.11

9.16

8.5

9.75

10.37

11.1

11.65

12.95

13.06

2.84

2.93

3.02

2.86

3.08

3.34

3.43

3.1

3.19

EBIT per Share

3.82

2.84

3.85

4.67

5.75

6.21

7.48

8.46

7.38

6.81

8.16

8.59

9.22

9.61

10.78

10.89

2.34

2.43

2.51

2.32

2.54

2.79

2.89

2.55

2.66

Like I said, it returns "N/A" if the data is less than the 15 years or 9 quarters of carried data. And should return "Premium" for fields that aren't available because you're not logged in as a subscriber.

On Mon, Jul 20, 2015 at 2:54 PM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

OK, I understand what you responded below, up to the point that it is unclear if you have automated this to being able to just enter the ticker or if you have to verify what columns come back and then input a column offset number. (a 2-step process)

I had a variation of this as a 2-step, enter ticker, see what column comes back as the date in first column after "Fiscal Periods" and then input my offset number.

Unless I'm misunderstanding, that is still what you are doing. I just don't have the entire line showing, just the result of first column.

If I misunderstood, and there is a way to automate the entry to find the TTM column from your lines below and have it go into the other formulas, could you please give the complete formula that would go in the cell?

If you are still doing a 2-step entry, like I am, I am still confused as to what my spreadsheet is doing. If I put in a 5, I get the column before the TTM and if I put in a 6, I get the column after the TTM. But if I put in a 5.5, I get the TTM column.

Tue Jul 21, 2015 7:49 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Well, at least I got confirmation that the "Premium" label works properly.
:)

If you logged in AFTER you got the first data for MMM, you'll need to use
smfForceRecalculation to tell the add-in to get a fresh copy of the web
page. The add-in saves a local copy of the web page, then extracts data
from that saved copy of the web page. So that saved copy needs to be purged
before you can get the "after login" version of the web page.

On Tue, Jul 21, 2015 at 7:15 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> So it's kind of working, but I'm not getting results in all the cells. The
> years left of 2010 all say "Premium". I am logged in to Gurufocus through
> Excel.
>
> So not sure why I'm getting this.
>
>
>
> *MMM*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Fiscal Periods
>
> Dec00
>
> Dec01
>
> Dec02
>
> Dec03
>
> Dec04
>
> Dec05
>
> Dec06
>
> Dec07
>
> Dec08
>
> Dec09
>
> Dec10
>
> Dec11
>
> Dec12
>
> Dec13
>
> Dec14
>
> TTM
>
> Mar13
>
> Jun13
>
> Sep13
>
> Dec13
>
> Mar14
>
> Jun14
>
> Sep14
>
> Dec14
>
> Mar15
>
>
>
> Revenue per Share
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> 36.75
>
> 41.18
>
> 42.52
>
> 44.51
>
> 48.07
>
> 48.14
>
> 10.87
>
> 11.09
>
> 11.44
>
> 11.11
>
> 11.61
>
> 12.24
>
> 12.37
>
> 11.86
>
> 11.67
>
>
>
> EBITDA per Share
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> 9.75
>
> 10.37
>
> 11.1
>
> 11.65
>
> 12.95
>
> 13.06
>
> 2.84
>
> 2.93
>
> 3.02
>
> 2.86
>
> 3.08
>
> 3.34
>
> 3.43
>
> 3.1
>
> 3.19
>
>
>
> EBIT per Share
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> Premium
>
> 8.16
>
> 8.59
>
> 9.22
>
> 9.61
>
> 10.78
>
> 10.89
>
> 2.34
>
> 2.43
>
> 2.51
>
> 2.32
>
> 2.54
>
> 2.79
>
> 2.89
>
> 2.55
>
> 2.66
>
>
>
>
>

Tue Jul 21, 2015 7:53 am (PDT) . Posted by:

"Jim Ranum" amt2100

Working!

Thanks Randy.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 21, 2015 10:50 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Well, at least I got confirmation that the "Premium" label works properly. :)

If you logged in AFTER you got the first data for MMM, you'll need to use smfForceRecalculation to tell the add-in to get a fresh copy of the web page. The add-in saves a local copy of the web page, then extracts data from that saved copy of the web page. So that saved copy needs to be purged before you can get the "after login" version of the web page.

On Tue, Jul 21, 2015 at 7:15 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

So it's kind of working, but I'm not getting results in all the cells. The years left of 2010 all say "Premium". I am logged in to Gurufocus through Excel.

So not sure why I'm getting this.

MMM

Fiscal Periods

Dec00

Dec01

Dec02

Dec03

Dec04

Dec05

Dec06

Dec07

Dec08

Dec09

Dec10

Dec11

Dec12

Dec13

Dec14

TTM

Mar13

Jun13

Sep13

Dec13

Mar14

Jun14

Sep14

Dec14

Mar15

Revenue per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

36.75

41.18

42.52

44.51

48.07

48.14

10.87

11.09

11.44

11.11

11.61

12.24

12.37

11.86

11.67

EBITDA per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

9.75

10.37

11.1

11.65

12.95

13.06

2.84

2.93

3.02

2.86

3.08

3.34

3.43

3.1

3.19

EBIT per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

8.16

8.59

9.22

9.61

10.78

10.89

2.34

2.43

2.51

2.32

2.54

2.79

2.89

2.55

2.66

Tue Jul 21, 2015 8:05 am (PDT) . Posted by:

"Jim Ranum" amt2100

Question about your new Guru format.

I don't really want all 185 of these parameters in my day to day use. I don't even want all the years/quarters info.

So if I only want about of dozen parameters, with 5—10 years, in a clean spreadsheet, a few questions:

Does the "Ticker" have to be in the B2 position in all spreadsheets?

Can I put my parameters in different columns vs. rows? So the Label is attached to the number vs. what is in the 'B' column in your Template?

And the Full Template file has to be located where Excel can find it? Where specifically, or is it built into the VBA?

Thanks again.

Best regards,

Jim

From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Tuesday, July 21, 2015 10:53 AM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Working!

Thanks Randy.

Best regards,

Jim

From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 21, 2015 10:50 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] Gurufocus - again - data from TTM column on Financials page

Well, at least I got confirmation that the "Premium" label works properly. :)

If you logged in AFTER you got the first data for MMM, you'll need to use smfForceRecalculation to tell the add-in to get a fresh copy of the web page. The add-in saves a local copy of the web page, then extracts data from that saved copy of the web page. So that saved copy needs to be purged before you can get the "after login" version of the web page.

On Tue, Jul 21, 2015 at 7:15 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

So it's kind of working, but I'm not getting results in all the cells. The years left of 2010 all say "Premium". I am logged in to Gurufocus through Excel.

So not sure why I'm getting this.

MMM

Fiscal Periods

Dec00

Dec01

Dec02

Dec03

Dec04

Dec05

Dec06

Dec07

Dec08

Dec09

Dec10

Dec11

Dec12

Dec13

Dec14

TTM

Mar13

Jun13

Sep13

Dec13

Mar14

Jun14

Sep14

Dec14

Mar15

Revenue per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

36.75

41.18

42.52

44.51

48.07

48.14

10.87

11.09

11.44

11.11

11.61

12.24

12.37

11.86

11.67

EBITDA per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

9.75

10.37

11.1

11.65

12.95

13.06

2.84

2.93

3.02

2.86

3.08

3.34

3.43

3.1

3.19

EBIT per Share

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

Premium

8.16

8.59

9.22

9.61

10.78

10.89

2.34

2.43

2.51

2.32

2.54

2.79

2.89

2.55

2.66

Tue Jul 21, 2015 8:48 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I agree that you don't want the entire template, especially since it takes
nearly a minute to fill everything in. That's why all of the formulas are
self-contained -- so you can copy and paste just the items you want. The
template just shows everything that is available, so you can pick and
choose the pieces you want.

From the "Tips and FAQs" page on the web site is my preferred method to
handle the "Ticker" situation:

Link
<https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/6963>9.1
- Tip: Using the cell named "Ticker"
But you can change "Ticker" to be anything you want, just as if it were a
normal cell reference.

For example, suppose I open up a new spreadsheet, rather than what the tip
above suggests, you could:

1. Put "MMM" into cell C5
2. Copy O5:R5 from the template to D5:G5. Now, the defined name "Ticker"
still refers back to cell B2 of the template.
3. You could continue copying other items from the template into the same
row. As many as you need.
4. Now, just do a "Find and Replace All" and change "Ticker" to "$C5". You
now have no references back to the template.

After those 4 steps, you can copy down the row and have all of the formulas
in each row refer to the ticker symbol in the corresponding C column.

Another option if you want selected data items and selected years -- just
start from the template and delete the rows and columns you don't want.
Then save it under a new name.

On Tue, Jul 21, 2015 at 8:05 AM, 'Jim Ranum' amt2100@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Question about your new Guru format.
>
> I don't really want all 185 of these parameters in my day to day use. I
> don't even want all the years/quarters info.
>
> So if I only want about of dozen parameters, with 5—10 years, in a clean
> spreadsheet, a few questions:
>
>
>
> Does the "Ticker" have to be in the B2 position in all spreadsheets?
>
> Can I put my parameters in different columns vs. rows? So the Label is
> attached to the number vs. what is in the 'B' column in your Template?
>
> And the Full Template file has to be located where Excel can find it?
> Where specifically, or is it built into the VBA?
>
>
>
>

Tue Jul 21, 2015 10:08 am (PDT) . Posted by:

"Jim Ranum" amt2100

Thanks Randy.

I'll work on it this week. Really appreciate your help and extra work on Gurufocus.

Best regards,

Jim

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 21, 2015 11:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus - again - data from TTM column on Financials page

I agree that you don't want the entire template, especially since it takes nearly a minute to fill everything in. That's why all of the formulas are self-contained -- so you can copy and paste just the items you want. The template just shows everything that is available, so you can pick and choose the pieces you want.

From the "Tips and FAQs" page on the web site is my preferred method to handle the "Ticker" situation:

Link <https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/6963>

9.1 - Tip: Using the cell named "Ticker"

But you can change "Ticker" to be anything you want, just as if it were a normal cell reference.

For example, suppose I open up a new spreadsheet, rather than what the tip above suggests, you could:

1. Put "MMM" into cell C5

2. Copy O5:R5 from the template to D5:G5. Now, the defined name "Ticker" still refers back to cell B2 of the template.

3. You could continue copying other items from the template into the same row. As many as you need.

4. Now, just do a "Find and Replace All" and change "Ticker" to "$C5". You now have no references back to the template.

After those 4 steps, you can copy down the row and have all of the formulas in each row refer to the ticker symbol in the corresponding C column.

Another option if you want selected data items and selected years -- just start from the template and delete the rows and columns you don't want. Then save it under a new name.

On Tue, Jul 21, 2015 at 8:05 AM, 'Jim Ranum' amt2100@gmail.com <mailto:amt2100@gmail.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Question about your new Guru format.

I don't really want all 185 of these parameters in my day to day use. I don't even want all the years/quarters info.

So if I only want about of dozen parameters, with 5—10 years, in a clean spreadsheet, a few questions:

Does the "Ticker" have to be in the B2 position in all spreadsheets?

Can I put my parameters in different columns vs. rows? So the Label is attached to the number vs. what is in the 'B' column in your Template?

And the Full Template file has to be located where Excel can find it? Where specifically, or is it built into the VBA?

Tue Jul 21, 2015 1:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

By the way, did you see the GuruFocus announcement today of their API and
EXCEL add-in that can allow you to grab the raw data from GuruFocus? Only
for subscribers.

The API has a limit of 2000 requests per month.

http://www.gurufocus.com/news/347921/both-gurufocus-excel-addin-and-api-are-available-to-premium-members-now

http://www.gurufocus.com/api.php

http://www.gurufocus.com/excel_Add_in.php

On Tue, Jul 21, 2015 at 10:08 AM, 'Jim Ranum' amt2100@...wrote:

>
> I'll work on it this week. Really appreciate your help and extra work on
> Gurufocus.
>
>
>

Tue Jul 21, 2015 8:58 am (PDT) . Posted by:

tbrayman

Hi Randy

Thank you for the detailed description. After I load the shortcut key in the Macro Options window and press the OK button, the shortcut key works as expected.

However, if I exit out of Excel completely and reload the spreadsheet I am working with, smfUpdateDownloadTable-Sample as an example, the shortcut key doesn't work again.

Will I have to reload the shortcut key every time I startup Excel?

Tue Jul 21, 2015 9:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I wouldn't have thought so, but your experience indicates maybe? I don't
really use assigned keyboard shortcuts any more. And I don't know if
they've changed how they work over different versions of EXCEL. I thought
they were saved with EXCEL, but apparently not.

I now assign the macros to buttons on my toolbar.

On Tue, Jul 21, 2015 at 8:58 AM, tbrayman@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thank you for the detailed description. After I load the shortcut key in
> the Macro Options window and press the OK button, the shortcut key works as
> expected.
>
> However, if I exit out of Excel completely and reload the spreadsheet I am
> working with, smfUpdateDownloadTable-Sample as an example, the shortcut key
> doesn't work again.
>
> Will I have to reload the shortcut key every time I startup Excel?
>

Tue Jul 21, 2015 2:07 pm (PDT) . Posted by:

robin301249

Are there any examples showing the experiences of a user in the UK extracting data for:-
- US Equities (Ticker example :USD:IBM)
- UK Equities (Ticker example :UK:RDW)
- UK Funds (Ticker example :
GB0033228197)

My requirements are very simple - all I really need at this stage is:-
- Current price
- Company Name
- PE
- Today's Change
- 52 Week High
- 52 Week Low


I am a new user of the add-in and would value any assistance to get started please.



Many thanks, Robin Saunders


Tue Jul 21, 2015 2:18 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should be able to use the RCHGetYahooQuotes() function. For example:

=RCHGetYahooQuotes("IBM,RDW.L,GB0033228197.L","l1nrc1jk&quot;)

...or, referring to the ticker symbols and Yahoo codes in cells:

=RCHGetYahooQuotes(C11:C13,D10:I10)

...results in:

l1 n r c1 j k IBM 163.07 International Business Machines 13.59 -10.15
149.52 196.4 RDW.L 450.4 REDROW 1172.92 -8.3 224 473.2
GB0033228197.L 535 Aberdeen
Emerging Markets Equi N/A -2 N/A N/A
At least that's what works for me here in the US.

On Tue, Jul 21, 2015 at 1:53 PM, robin301249@.... wrote:

>
> Are there any examples showing the experiences of a user in the UK
> extracting data for:-
>
> - US Equities (Ticker example :USD:IBM)
>
> - UK Equities (Ticker example :UK:RDW)
>
> - UK Funds (Ticker example :
> GB0033228197)
>
> My requirements are very simple - all I really need at this stage is:-
>
> - Current price
>
> - Company Name
>
> - PE
>
> - Today's Change
>
> - 52 Week High
>
> - 52 Week Low
>
> I am a new user of the add-in and would value any assistance to get
> started please.
>
>

Tue Jul 21, 2015 3:04 pm (PDT) . Posted by:

robin301249

Many thanks - I am on the case! Your quick reply appreciated

Tue Jul 21, 2015 4:46 pm (PDT) . Posted by:

robin301249

Randy Right, I am making progress and think I am understanding the basics, however, as in your example there are some data elements ((Latest Price -l1 above) that are not populated in Yahoo Finance.
Are there any other sources I can use please? I note that this field is 'obsolete&#39; in MSN and I cannot see an equivalent field in the RCHGetElementNumber-Element-Definitions file provided in the download.
Any help would be appreciated
Robin
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar