9 New Messages
Digest #2674
Messages
Thu Jun 27, 2013 7:20 am (PDT) . Posted by:
"lexstar" lexstar
Why is it that sometimes smfPricesBetween() will give you a different price than what's reported on Yahoo.
For example yesterday's close (June 26) for LGOAX using smfPricesBetween("LGOAX";,06/03/2013,06/26/2013,"08") give a value of 13.74, but yet on Yahoo Finance, it's 13.16.
Anyone care to enlighten me on this? (It doesn't happened to every ticker, just some here and there).
Thanks.
For example yesterday'
Anyone care to enlighten me on this? (It doesn't happened to every ticker, just some here and there).
Thanks.
Thu Jun 27, 2013 11:18 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm surprised you get anything, since those aren't EXCEL serial dates.
EXCEL will interpret the first as 6 divided by 3 divided by 2013.
But usually that type of symptom is an indicator that one Yahoo server may
not have been updated properly.
On Thu, Jun 27, 2013 at 7:19 AM, lexstar <lexstar@yahoo.com > wrote:
> Why is it that sometimes smfPricesBetween() will give you a different
> price than what's reported on Yahoo.
>
> For example yesterday's close (June 26) for LGOAX using
> smfPricesBetween("LGOAX";,06/03/2013,06/26/2013,"08") give a value of 13.74,
> but yet on Yahoo Finance, it's 13.16.
>
> Anyone care to enlighten me on this? (It doesn't happened to every ticker,
> just some here and there).
>
EXCEL will interpret the first as 6 divided by 3 divided by 2013.
But usually that type of symptom is an indicator that one Yahoo server may
not have been updated properly.
On Thu, Jun 27, 2013 at 7:19 AM, lexstar <lexstar@yahoo.
> Why is it that sometimes smfPricesBetween(
> price than what's reported on Yahoo.
>
> For example yesterday'
> smfPricesBetween(
> but yet on Yahoo Finance, it's 13.16.
>
> Anyone care to enlighten me on this? (It doesn't happened to every ticker,
> just some here and there).
>
Thu Jun 27, 2013 10:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm at a loss to explain why things aren't working...
The only thing I can think to try is uncheck the add-in in the add-in
manager, exit EXCEL, restart EXCEL, and then add the add-in back to the
add-in manager.
On Wed, Jun 26, 2013 at 11:37 PM, Ron Perlman <ron125@yahoo.com > wrote:
>
> Is it checked when you go to the list of add-ins in the add-in manager?
> Yes
>
> I have the latest official version installed in the correct directory, but
> somehow the function seems not to be installed properly.
>
> Does the add-in work in excel 2010? Are there problems with OS 8?
> Any ideas on what I can try next?
>
The only thing I can think to try is uncheck the add-in in the add-in
manager, exit EXCEL, restart EXCEL, and then add the add-in back to the
add-in manager.
On Wed, Jun 26, 2013 at 11:37 PM, Ron Perlman <ron125@yahoo.
>
> Is it checked when you go to the list of add-ins in the add-in manager?
> Yes
>
> I have the latest official version installed in the correct directory, but
> somehow the function seems not to be installed properly.
>
> Does the add-in work in excel 2010? Are there problems with OS 8?
> Any ideas on what I can try next?
>
Thu Jun 27, 2013 2:46 pm (PDT) . Posted by:
"Thomas" tg.bruin
I have a list of tickers in range H12 to H36. I have elements "l1" and "p" in cells I11 and J11. I am using the following formula syntax:
RCHGetYahooQuotes(H12:H36,I11:J11,NOW()), then CTRL,SHFT,ENTER. This only returns a value in cell I12. What am I doing incorrectly? I would like to be able to update the prices during the day.
RCHGetYahooQuotes(
Thu Jun 27, 2013 5:28 pm (PDT) . Posted by:
"mguerreiro99" mguerreiro99
I'm a newbie, but have the following observations.
1. Put a blank field ",," in front of the NOW() in your formula
2. Be sure you have selected the range I12:J36 before entering your formula in cell I12, then CTRL, SHFT, ENTER.
I hope this works for you.
Matt G
--- In smf_addin@yahoogrou
>
> I have a list of tickers in range H12 to H36. I have elements "l1" and "p" in cells I11 and J11. I am using the following formula syntax:
> RCHGetYahooQuotes(
>
Thu Jun 27, 2013 5:49 pm (PDT) . Posted by:
"pete32257" pete32257
Hello,
I type in ACN for my ticker and EXCEL takes control and result is
CAN....How do I control this?
thanks so much for the group and the support, you guys make
us money
I type in ACN for my ticker and EXCEL takes control and result is
CAN....How do I control this?
thanks so much for the group and the support, you guys make
us money
Thu Jun 27, 2013 6:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's EXCEL's auto-correct feature. How to control it:
http://www.officetooltips.com/office/tips/setting_autocorrect_options.html
I usually like to keep it on, so my workaround is to do something like:
="AC"&"N"
Then, before hitting enter, hit F9 to evaluate, and then hit enter.
Or, you can do:
="ACN"
As soon as you type in the second double-quote, it will correct it. Just
hit Ctrl-Z to undo the correction, hit F9 to evaluate it, then enter.
On Thu, Jun 27, 2013 at 3:28 PM, pete32257 <pete32257@yahoo.com > wrote:
>
> I type in ACN for my ticker and EXCEL takes control and result is
> CAN....How do I control this?
>
http://www.officeto
I usually like to keep it on, so my workaround is to do something like:
="AC"
Then, before hitting enter, hit F9 to evaluate, and then hit enter.
Or, you can do:
="ACN"
As soon as you type in the second double-quote, it will correct it. Just
hit Ctrl-Z to undo the correction, hit F9 to evaluate it, then enter.
On Thu, Jun 27, 2013 at 3:28 PM, pete32257 <pete32257@yahoo.
>
> I type in ACN for my ticker and EXCEL takes control and result is
> CAN....How do I control this?
>
Fri Jun 28, 2013 1:24 am (PDT) . Posted by:
"Pete" pete32257
Ok Randy, thanks again for your support!
Sent from my iPhone
On Jun 27, 2013, at 8:59 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> That's EXCEL's auto-correct feature. How to control it:
>
> http://www.officetooltips.com/office/tips/setting_autocorrect_options.html
>
> I usually like to keep it on, so my workaround is to do something like:
>
> ="AC"&"N"
>
> Then, before hitting enter, hit F9 to evaluate, and then hit enter.
>
> Or, you can do:
>
> ="ACN"
>
> As soon as you type in the second double-quote, it will correct it. Just hit Ctrl-Z to undo the correction, hit F9 to evaluate it, then enter.
>
>
> On Thu, Jun 27, 2013 at 3:28 PM, pete32257 <pete32257@yahoo.com > wrote:
>>
>> I type in ACN for my ticker and EXCEL takes control and result is
>> CAN....How do I control this?
>
>
Sent from my iPhone
On Jun 27, 2013, at 8:59 PM, Randy Harmelink <rharmelink@gmail.
> That's EXCEL's auto-correct feature. How to control it:
>
> http://www.officeto
>
> I usually like to keep it on, so my workaround is to do something like:
>
> ="AC"
>
> Then, before hitting enter, hit F9 to evaluate, and then hit enter.
>
> Or, you can do:
>
> ="ACN"
>
> As soon as you type in the second double-quote, it will correct it. Just hit Ctrl-Z to undo the correction, hit F9 to evaluate it, then enter.
>
>
> On Thu, Jun 27, 2013 at 3:28 PM, pete32257 <pete32257@yahoo.
>>
>> I type in ACN for my ticker and EXCEL takes control and result is
>> CAN....How do I control this?
>
>
Fri Jun 28, 2013 12:07 am (PDT) . Posted by:
"Thomas" tg.bruin
I am trying to return last price and previous close for a list of tickers...placed vertically in range H12 thru H41. I am using =RCHGetYahooQuotes(H12:H41,I11:J11) in cell I12, and then CTRL/SHFT/ENTER. This only produses a price in cell I12, it doesn't complete the rest of the ticker range. ??
And assuming I can get this to work correctly, what happens at EOD close....does the code "p" return yesterdays close price or the EOD close of current day?
And assuming I can get this to work correctly, what happens at EOD close....does the code "p" return yesterdays close price or the EOD close of current day?
Tidak ada komentar:
Posting Komentar