7 New Messages
Digest #2943
Messages
Sun Jan 26, 2014 8:50 pm (PST) . Posted by:
mikemcq802
You can just use the following in a single cell to retrieve the price. A1 is the cell containing the ticker. The value in quotes is a lower case L followed by the number 1.
=RCHGetYahooQuotes(A1,"l1")
If you want to retrieve quotes for more than one ticker, or return more than a single element, you must enter the above as an array formula.
=RCHGetYahooQuotes(
If you want to retrieve quotes for more than one ticker, or return more than a single element, you must enter the above as an array formula.
Sun Jan 26, 2014 8:55 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Ah, thank you. It was a lower case L. I could not tell by looking at the table! Thanks! It works like a charm now!
Marc
To: smf_addin@yahoogroups.com
From: mikemcq802@yahoo.com
Date: Sun, 26 Jan 2014 20:50:19 -0800
Subject: [smf_addin] RE: Thanks for making! A question...
You can just use the following in a single cell to retrieve the price. A1 is the cell containing the ticker. The value in quotes is a lower case L followed by the number 1.
=RCHGetYahooQuotes(A1,"l1")
If you want to retrieve quotes for more than one ticker, or return more than a single element, you must enter the above as an array formula.
Marc
To: smf_addin@yahoogrou
From: mikemcq802@yahoo.
Date: Sun, 26 Jan 2014 20:50:19 -0800
Subject: [smf_addin] RE: Thanks for making! A question...
You can just use the following in a single cell to retrieve the price. A1 is the cell containing the ticker. The value in quotes is a lower case L followed by the number 1.
=RCHGetYahooQuotes(
If you want to retrieve quotes for more than one ticker, or return more than a single element, you must enter the above as an array formula.
Sun Jan 26, 2014 8:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Be sure to also pick up the smf-elements-*.txt files that have been updated
after the ZIP file was created. Those were additional element definition
changes. I only update the ZIP file when program code has changed.
On Sun, Jan 26, 2014 at 9:41 PM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:
>
> I will go to the Works in Progress folder to pick up the latest version of
> the add-on.
>
after the ZIP file was created. Those were additional element definition
changes. I only update the ZIP file when program code has changed.
On Sun, Jan 26, 2014 at 9:41 PM, Marc . <WHICHWAYTOBEACH@
>
> I will go to the Works in Progress folder to pick up the latest version of
> the add-on.
>
Sun Jan 26, 2014 8:58 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Thank you very much! Once I get this working, it will save me hundreds of hours typing in data...like I have been doing.
And, thank you for responding quickly.
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Sun, 26 Jan 2014 21:56:52 -0700
Subject: Re: [smf_addin] Thanks for making! A question...
Be sure to also pick up the smf-elements-
On Sun, Jan 26, 2014 at 9:41 PM, Marc . <WHICHWAYTOBEACH@
I will go to the Works in Progress folder to pick up the latest version of the add-on.
Sun Jan 26, 2014 9:35 pm (PST) . Posted by:
whichwaytobeach
Hello!,
Is there a way to go to the current quarter in the Quarterly Balance Sheet, without me having to manually go into the RCH elements and guess which one that particular company is in?
For instance, HPQ's latest reported quarter was Q1'14, yet, say TSLA's last reported quarter may be Q4'13. Right now what I am doing is double checking if I am mapped to the correct quarter by looking at the actual data. Sometimes I notice that I have the wrong latest ended quarter improperly mapped over. This, of course defeats the purpose of "automating" in the way I am mapping now...
Thanks for any help.
Marc
Is there a way to go to the current quarter in the Quarterly Balance Sheet, without me having to manually go into the RCH elements and guess which one that particular company is in?
For instance, HPQ's latest reported quarter was Q1'14, yet, say TSLA's last reported quarter may be Q4'13. Right now what I am doing is double checking if I am mapped to the correct quarter by looking at the actual data. Sometimes I notice that I have the wrong latest ended quarter improperly mapped over. This, of course defeats the purpose of "automating&qu
Thanks for any help.
Marc
Sun Jan 26, 2014 10:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure I understand the question. Where are you seeing Q1/2014 data
for HPQ? Their fiscal first quarter isn't official until the end of
January...
The FY1 element should always be the most current reported fiscal quarter
from the data source. They won't necessarily match up between companies:
-- Companies can have different fiscal periods
-- Companies may have shorter or longer lags between end of quarter to when
results are reported
-- Data sources may have lags between when those results get posted to
their site
It looks like HPQ's fiscal year ended in October, while TSLA's ended in
December. According to Zack's, both are expected to release their next
quarterly results about Feb 19th or 20th -- Q1 for HPQ and Q4 for TSLA.
On Sun, Jan 26, 2014 at 10:35 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:
>
> Is there a way to go to the current quarter in the Quarterly Balance
> Sheet, without me having to manually go into the RCH elements and guess
> which one that particular company is in?
>
> For instance, HPQ's latest reported quarter was Q1'14, yet, say TSLA's
> last reported quarter may be Q4'13. Right now what I am doing is double
> checking if I am mapped to the correct quarter by looking at the actual
> data. Sometimes I notice that I have the wrong latest ended quarter
> improperly mapped over. This, of course defeats the purpose of "automating"
> in the way I am mapping now...
>
>
for HPQ? Their fiscal first quarter isn't official until the end of
January...
The FY1 element should always be the most current reported fiscal quarter
from the data source. They won't necessarily match up between companies:
-- Companies can have different fiscal periods
-- Companies may have shorter or longer lags between end of quarter to when
results are reported
-- Data sources may have lags between when those results get posted to
their site
It looks like HPQ's fiscal year ended in October, while TSLA's ended in
December. According to Zack's, both are expected to release their next
quarterly results about Feb 19th or 20th -- Q1 for HPQ and Q4 for TSLA.
On Sun, Jan 26, 2014 at 10:35 PM, <WHICHWAYTOBEACH@
>
> Is there a way to go to the current quarter in the Quarterly Balance
> Sheet, without me having to manually go into the RCH elements and guess
> which one that particular company is in?
>
> For instance, HPQ's latest reported quarter was Q1'14, yet, say TSLA's
> last reported quarter may be Q4'13. Right now what I am doing is double
> checking if I am mapped to the correct quarter by looking at the actual
> data. Sometimes I notice that I have the wrong latest ended quarter
> improperly mapped over. This, of course defeats the purpose of "automating&qu
> in the way I am mapping now...
>
>
Sun Jan 26, 2014 10:22 pm (PST) . Posted by:
whichwaytobeach
Thanks Randy,
You answered my question: The Q1 data is always the most current when it relates to the data pull from the web.
I guess they should rename the data elements to be something like "Current Quarter", "One Quarter Back", etc.
Regards,
Marc
You answered my question: The Q1 data is always the most current when it relates to the data pull from the web.
I guess they should rename the data elements to be something like "Current Quarter"
Regards,
Marc
Tidak ada komentar:
Posting Komentar