4 New Messages
Digest #2734
Messages
Wed Aug 14, 2013 7:02 pm (PDT) . Posted by:
"tkmurch11" tkmurch11
I just added the SMF addin to excel. When I tried to input the Last Trade price for JNJ I get a price of 93.01; however the price on MSN.com shows 90.70. Why is there an error? Am I doing something wrong? The formula I used was =RCHGetElementNumber(A2,25)
A2 was the cell I had the SYMBOL; in this case JNJ.
Thank you.
A2 was the cell I had the SYMBOL; in this case JNJ.
Thank you.
Wed Aug 14, 2013 7:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In its infinite wisdom, MSN decided to post the previous day's closing
price as "Last Price" when they redesigned their print web page last year.
In any case, for current quotes, you should be using the
RCHGetYahooQuotes() function. I am constantly regretting ever defining
element #25. Since it has been incorrect for over a year now, it may be a
good opportunity to obsolete it.
On Wed, Aug 14, 2013 at 5:53 PM, tkmurch11 <trentm4@hotmail.com > wrote:
> I just added the SMF addin to excel. When I tried to input the Last Trade
> price for JNJ I get a price of 93.01; however the price on MSN.com shows
> 90.70. Why is there an error? Am I doing something wrong? The formula I
> used was =RCHGetElementNumber(A2,25)
>
> A2 was the cell I had the SYMBOL; in this case JNJ.
>
price as "Last Price" when they redesigned their print web page last year.
In any case, for current quotes, you should be using the
RCHGetYahooQuotes(
element #25. Since it has been incorrect for over a year now, it may be a
good opportunity to obsolete it.
On Wed, Aug 14, 2013 at 5:53 PM, tkmurch11 <trentm4@hotmail.
> I just added the SMF addin to excel. When I tried to input the Last Trade
> price for JNJ I get a price of 93.01; however the price on MSN.com shows
> 90.70. Why is there an error? Am I doing something wrong? The formula I
> used was =RCHGetElementNumbe
>
> A2 was the cell I had the SYMBOL; in this case JNJ.
>
Wed Aug 14, 2013 9:26 pm (PDT) . Posted by:
"chincapie07" chincapie07
Hi Randy,
First, thanks for all your time and effort on this very useful add in. I wondered if there were any plans to make a Mac version available?
Best wishes,
Ces
First, thanks for all your time and effort on this very useful add in. I wondered if there were any plans to make a Mac version available?
Best wishes,
Ces
Wed Aug 14, 2013 9:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
None at all. I'm only sharing something I originally wrote for my own use
that I thought others might find helpful. I've never even used a Mac, nor
had a desire to, so I would have no idea what would be necessary.
On Wed, Aug 14, 2013 at 8:52 PM, chincapie07 <chincapie07@yahoo.com > wrote:
> Hi Randy,
>
> First, thanks for all your time and effort on this very useful add in. I
> wondered if there were any plans to make a Mac version available?
>
> Best wishes,
> Ces
>
that I thought others might find helpful. I've never even used a Mac, nor
had a desire to, so I would have no idea what would be necessary.
On Wed, Aug 14, 2013 at 8:52 PM, chincapie07 <chincapie07@
> Hi Randy,
>
> First, thanks for all your time and effort on this very useful add in. I
> wondered if there were any plans to make a Mac version available?
>
> Best wishes,
> Ces
>
Tidak ada komentar:
Posting Komentar