EXCEL Stock Market Functions Add-in Group

8 New Messages

Digest #2295

=RCHGetElementNumber() by "ufdn16" ufdn16

Re: =RCHGetElementNumber() by "Randy Harmelink" rharmelink

seems to be I am getting the previous 2 day's close, not the last da by "rr76012" rr76012

Re: seems to be I am getting the previous 2 day's close, not the las by "NicholasDavid" davidnicholas738

Re: seems to be I am getting the previous 2 day's close, not the las by "Randy Harmelink" rharmelink

Re: seems to be I am getting the previous 2 day's close, not the las by "NicholasDavid" davidnicholas738

Re: seems to be I am getting the previous 2 day's close, not the las by "Randy Harmelink" rharmelink

Messages

1a

I'm getting an error in the cell that I place =RCHGetElementNumber(Symbol,27) which is supposed to return price change over 3 months.

Is there a code to get this info by using =GetYahooQuotes()

And, is there a site that has all the codes for using =GetYahooQuotes()

Thanks, David

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

1b

Re: =RCHGetElementNumber()

Sun Jul 29, 2012 11:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element #27 is working here. What ticker symbol did you use? Do you have
the MSN element definition updates from the "Works in Progress" folder?

Documentation of the Yahoo codes is in the "Documentation" folder in the
files area of the group. Everything I am aware of is there -- I don't know
of any documentation by Yahoo.

FinViz could be another source -- see the two entries in the "Links" area
of the group for possible ways to extract data for multiple tickers.

On Sun, Jul 29, 2012 at 9:54 AM, ufdn16 <ufdn16@yahoo.com> wrote:

> I'm getting an error in the cell that I place
> =RCHGetElementNumber(Symbol,27) which is supposed to return price change
> over 3 months.
>
> Is there a code to get this info by using =GetYahooQuotes()
>
> And, is there a site that has all the codes for using =GetYahooQuotes()
>

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

2a

seems to be I am getting the previous 2 day's close, not the last da

Sun Jul 29, 2012 10:26 am (PDT) . Posted by:

"rr76012" rr76012

Hi Randy,

I updated all the files to the newest today, Sunday 7/29/2012.

I am not getting the last day's closing price, I get the previous 2 day's closing price; for example MMM, today is Sunday, friday's closing price is 91.71, the closing price on thursday the day previous closed was 90.59. I get thursday 90.59, instead of the friday 91.71 closing price?

What am I doing wrong?

Here are the answers to your usual questions, I hope this helps others, thank you.

=RCHGetElementNumber("Version")
=smfGetAParms(25)
=RCHGetElementNumber("MMM",25)

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

MSN;Last Price;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0

90.59

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

2b

Re: seems to be I am getting the previous 2 day's close, not the las

Sun Jul 29, 2012 10:51 am (PDT) . Posted by:

"NicholasDavid" davidnicholas738

I don't get it. What are we supposed to do with
=RCHGetElementNumber("Version")
=smfGetAParms(25)

----- Original Message -----
From: "rr76012" <rr76012@yahoo.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Sunday, July 29, 2012 12:25:58 PM
Subject: [smf_addin] seems to be I am getting the previous 2 day's close, not the last day's close.

Hi Randy,

I updated all the files to the newest today, Sunday 7/29/2012.

I am not getting the last day's closing price, I get the previous 2 day's closing price; for example MMM, today is Sunday, friday's closing price is 91.71, the closing price on thursday the day previous closed was 90.59. I get thursday 90.59, instead of the friday 91.71 closing price?

What am I doing wrong?

Here are the answers to your usual questions, I hope this helps others, thank you.

=RCHGetElementNumber("Version")
=smfGetAParms(25)
=RCHGetElementNumber("MMM",25)

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

MSN;Last Price; http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0

90.59

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

2c

Re: seems to be I am getting the previous 2 day's close, not the las

Sun Jul 29, 2012 11:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, MSN is posting the previous day's closing price as the "Last
Price".

On Sun, Jul 29, 2012 at 10:25 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> I updated all the files to the newest today, Sunday 7/29/2012.
>
> I am not getting the last day's closing price, I get the previous 2 day's
> closing price; for example MMM, today is Sunday, friday's closing price is
> 91.71, the closing price on thursday the day previous closed was 90.59. I
> get thursday 90.59, instead of the friday 91.71 closing price?
>
> What am I doing wrong?
>
> Here are the answers to your usual questions, I hope this helps others,
> thank you.
>
>
> =RCHGetElementNumber("Version")
> =smfGetAParms(25)
> =RCHGetElementNumber("MMM",25)
>
> Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program
> Files\SMF Add-In; 1)
>
> MSN;Last Price;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
>
> 90.59
>

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

2d

Re: seems to be I am getting the previous 2 day's close, not the las

Sun Jul 29, 2012 11:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I usually ask for the results of such function invocations so I can try to
figure out what a problem might be,

On Sun, Jul 29, 2012 at 10:49 AM, NicholasDavid
<nicholasdavid@comcast.net>wrote:

>
> I don't get it. What are we supposed to do with
> =RCHGetElementNumber("Version")
> =smfGetAParms(25)
>

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

2e

Re: seems to be I am getting the previous 2 day's close, not the las

Sun Jul 29, 2012 1:07 pm (PDT) . Posted by:

"NicholasDavid" davidnicholas738

Oh!
Here's what I get for these formulas:
Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)
MSN;Last Price;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0
Error
I've been trying to fix this problem for some time.
In Works in progress, I see two files that might help.
one: RCH_Stock_Market_Functions 2.1.2012.07.12.zip

and two: Smf-elements-1.txt

Which of these file will make =RCHGetElementNumber(T,27) reveal the 3mth price change.

Please give me the detail of how I procedurally go about updating. I thought I was smart but
I need help. Thanks, David

----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Sunday, July 29, 2012 1:41:41 PM
Subject: Re: [smf_addin] seems to be I am getting the previous 2 day's close, not the last day's close.

Unfortunately, MSN is posting the previous day's closing price as the "Last Price".

On Sun, Jul 29, 2012 at 10:25 AM, rr76012 < rr76012@yahoo.com > wrote:

I updated all the files to the newest today, Sunday 7/29/2012.

I am not getting the last day's closing price, I get the previous 2 day's closing price; for example MMM, today is Sunday, friday's closing price is 91.71, the closing price on thursday the day previous closed was 90.59. I get thursday 90.59, instead of the friday 91.71 closing price?

What am I doing wrong?

Here are the answers to your usual questions, I hope this helps others, thank you.

=RCHGetElementNumber("Version")
=smfGetAParms(25)
=RCHGetElementNumber("MMM",25)

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

MSN;Last Price; http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0

90.59

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

2f

Re: seems to be I am getting the previous 2 day's close, not the las

Sun Jul 29, 2012 1:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yes, you have the old MSN element definitions, so it's the
smf-elements-1.txt file that you need:

http://finance.groups.yahoo.com/group/smf_addin/message/18529

Best practice:

1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL

On Sun, Jul 29, 2012 at 1:05 PM, NicholasDavid <nicholasdavid@comcast.net>wrote:

>
> Oh!
> Here's what I get for these formulas:
> Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program
> Files\SMF Add-In; 1) MSN;Last Price;
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> Error
> I've been trying to fix this problem for some time.
> In Works in progress, I see two files that might help.
> one: RCH_Stock_Market_Functions 2.1.2012.07.12.zip
>
> and two: Smf-elements-1.txt
>
> Which of these file will make =RCHGetElementNumber(T,27) reveal the 3mth
> price change.
>
> Please give me the detail of how I procedurally go about updating. I
> thought I was smart but
> I need help. Thanks, David
>