[smf_addin] Digest Number 3638[1 Attachment]

EXCEL Stock Market Functions Add-in Group

15 Messages

Digest #3638

1a

Re: by "Darryl Bonfessuto"

1b

Re: by "Randy Harmelink" rharmelink

1c

Re: by "Darryl Bonfessuto"

2a

(no subject) by "Darryl Bonfessuto"

2b

Re: [1 Attachment] by "Randy Harmelink" rharmelink

2c

Re: by "Darryl Bonfessuto"

3

(no subject) by "Darryl Bonfessuto"

4a

(no subject) by "Darryl Bonfessuto"

4b

Re: by "Randy Harmelink" rharmelink

5a

(no subject) by "Darryl Bonfessuto"

5b

Re: by "Randy Harmelink" rharmelink

5c

Re: by "Darryl Bonfessuto"

5d

Re: by "Darryl Bonfessuto"

6

NOT A NEW TOPIC, BUT CANT FIND THE ANSWER BY SEARCHING by mtopper

7

Why am I getting all #NAME? 's in my spreadsheet by zbgb952

Messages

1a

Re:

Mon Feb 15, 2016 5:39 am (PST) . Posted by:

"Darryl Bonfessuto"

Thanks Randy

I highlighted a range of cells entered the formula ,then Ctrl + Shift enter.. Now all cells have #value!, What am I missing?

Thanks Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 15, 2016 12:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

You pasted the formula incorrectly -- as HTML, into a single cell.

You need to array-enter an RCHGetHTMLTable() formula over a range if you want it to return anything more than one cell's worth of data.

On Sun, Feb 14, 2016 at 8:53 PM, Darryl Bonfessuto dmb7111@... wrote:

Randy

Here is the file

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1b

Re:

Mon Feb 15, 2016 8:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Are you not running with the current version of the add-in? If not, you
need to code three more parameters:

=RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US
Treasury Bonds",-1,"",1)

On Mon, Feb 15, 2016 at 6:38 AM, Darryl Bonfessuto dmb7111@... wrote:

>
> I highlighted a range of cells entered the formula ,then Ctrl + Shift
> enter.. Now all cells have #value!, What am I missing?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

1c

Re:

Mon Feb 15, 2016 10:49 am (PST) . Posted by:

"Darryl Bonfessuto"

Not sure where do I check?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 15, 2016 11:58 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

Are you not running with the current version of the add-in? If not, you need to code three more parameters:

=RCHGetHTMLTable("http://finance.yahoo.com/bonds/composite_bond_rates",">US Treasury Bonds",-1,"",1)

On Mon, Feb 15, 2016 at 6:38 AM, Darryl Bonfessuto dmb7111@... wrote:

I highlighted a range of cells entered the formula ,then Ctrl + Shift enter.. Now all cells have #value!, What am I missing?

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

2a

(no subject)

Mon Feb 15, 2016 7:44 am (PST) . Posted by:

"Darryl Bonfessuto"

Randy

If I am trying to reproduce this Bond table into excel so that data is align
into a separate cells. What is the correct process?

Thanks

Darryl

Attachment(s) from Darryl Bonfessuto

1 of 1 File(s)

Bond Table.xlsx

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Re: [1 Attachment]

Mon Feb 15, 2016 9:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3022-bondbnchmrk.html
",">Latest",-1,"",1)

On Mon, Feb 15, 2016 at 8:43 AM, Darryl Bonfessuto dmb7111@... wrote:

>
> If I am trying to reproduce this Bond table into excel so that data is
> align into a separate cells. What is the correct process?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

Re:

Mon Feb 15, 2016 10:57 am (PST) . Posted by:

"Darryl Bonfessuto"

Thanks Randy That worked!!! I must have and old SMF Where can I find instruction on udating SMF

Thanks Again

Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 15, 2016 12:04 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

Try:

=RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3022-bondbnchmrk.html",">Latest",-1,"",1)

On Mon, Feb 15, 2016 at 8:43 AM, Darryl Bonfessuto dmb7111@... wrote:

If I am trying to reproduce this Bond table into excel so that data is align into a separate cells. What is the correct process?

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3

(no subject)

Mon Feb 15, 2016 11:12 am (PST) . Posted by:

"Darryl Bonfessuto"

I Have this: Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\SMF
Add-In; ; 1)

Thanks Randy I will update

Thanks Again

Da

rryl

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

4a

(no subject)

Mon Feb 15, 2016 1:14 pm (PST) . Posted by:

"Darryl Bonfessuto"

Randy

Have a bit of a mess. I have a few SMF file locations. This is my main c
drive which I downloaded today and extracted-2-15-2016

Under SMF Add in

Under Program File in Main I also have

SMF is blank

But SMF addin has

1) How can I determine where excel is pointed or files being used

2) Can I delete all except Main C: SMF Add in and just have one
location in use

3) If I do # 2 will it cause problems with past spreadsheets

Thanks Darryl

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4b

Re:

Mon Feb 15, 2016 1:22 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The version information you posted earlier told you where the add-in that
you're using is located:

Stock Market Functions add-in, Version 2.1.2014.01.30 (*C:\SMF Add-In*; ; 1)

You should be able to delete anything else. Then just put the ZIP archive
with the new version in that folder and unzip it. Just overwrite files as
they unzip. Then you may want to visit the "Elements" page on the web site
and get any updated element definitions. Just download those and replace
the element definition files in that folder.

You should close EXCEL before doing any of these updates.

On Mon, Feb 15, 2016 at 2:14 PM, Darryl Bonfessuto dmb7111@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> Randy
>
> Have a bit of a mess. I have a few SMF file locations. This is my main c
> drive which I downloaded today and extracted-2-15-2016
>
>
>
>
>
> Under SMF Add in
>
>
>
>
>
>
>
> Under Program File in Main I also have
>
>
>
>
>
> SMF is blank
>
>
>
> But SMF addin has
>
>
>
>
>
> 1) How can I determine where excel is pointed or files being used
>
> 2) Can I delete all except Main C: SMF Add in and just have one
> location in use
>
> 3) If I do # 2 will it cause problems with past spreadsheets
>
> Thanks Darryl
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

5a

(no subject)

Mon Feb 15, 2016 1:23 pm (PST) . Posted by:

"Darryl Bonfessuto"

Randy

From excel ADD in location

I am thinking to uncheck addin in excel

Delete all SMF files except on Main C drive folder SMF Add-In (which is
latest version)

Open excel recheck add in

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5b

Re:

Mon Feb 15, 2016 1:28 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That would work...

On Mon, Feb 15, 2016 at 2:23 PM, Darryl Bonfessuto dmb7111@...wrote:

>
> From excel ADD in location
>
>
>
> I am thinking to uncheck addin in excel
>
> Delete all SMF files except on Main C drive folder SMF Add-In (which is
> latest version)
>
> Open excel recheck add in
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5c

Re:

Mon Feb 15, 2016 1:29 pm (PST) . Posted by:

"Darryl Bonfessuto"

Thanks Randy

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 15, 2016 4:28 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

That would work...

On Mon, Feb 15, 2016 at 2:23 PM, Darryl Bonfessuto dmb7111@...wrote:

From excel ADD in location

I am thinking to uncheck addin in excel

Delete all SMF files except on Main C drive folder SMF Add-In (which is latest version)

Open excel recheck add in

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

5d

Re:

Mon Feb 15, 2016 2:57 pm (PST) . Posted by:

"Darryl Bonfessuto"

Thanks Again Randy!!

Cleaned it up, now have latest version and works great. Appreciate All the help

Thanks Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, February 15, 2016 4:28 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin]

That would work...

On Mon, Feb 15, 2016 at 2:23 PM, Darryl Bonfessuto dmb7111@...wrote:

From excel ADD in location

I am thinking to uncheck addin in excel

Delete all SMF files except on Main C drive folder SMF Add-In (which is latest version)

Open excel recheck add in

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

6

NOT A NEW TOPIC, BUT CANT FIND THE ANSWER BY SEARCHING

Mon Feb 15, 2016 8:03 pm (PST) . Posted by:

mtopper

Just bought a new computer Surface Book running Windows 10. Cant seem to create a directory like C:/SMF Add-In


ANY SUGGESTIONS?


Thanks


Marty

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

7

Why am I getting all #NAME? 's in my spreadsheet

Mon Feb 15, 2016 11:41 pm (PST) . Posted by:

zbgb952

It is currently 11:32 PM here on the West coast. When I tried some of my previously working spreadsheets with smf-addin, all I got was #NAME? in each of the calculated fields.

I even tried some of the templates at the smf website and got he same thing. This happens when I use the alt-f8 forcerecalculation function.

What is going on? Thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

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

Visit Your Group

• New Members 29

• Privacy • Unsubscribe • Terms of Use