15 New Messages
Digest #2724
5d
Re: AdvFN rchgetelementnumber returning wrong Qtr. End Dates [1 Atta by "Randy Harmelink" rharmelink
Messages
Tue Aug 6, 2013 6:20 am (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Thanks. I'll try that. I am trying to have an offsite browser automatically go to the annual and interim data page and save them. However, both seems to have the same url.
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=C6U:SES&subview=BalanceSheet
Is there an url that will go to annual and one that will go to interim?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sure. I've done that before. Here is an example:
>
> =RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html ",5,"?c=T,")
>
> In this case, it had been a dynamically displayed web page. But, by saving
> it to my hard drive, the dynamic data is now stored within the file.
>
> On Mon, Aug 5, 2013 at 2:36 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> >
> > Currently the RCHGetTable functions point to a url. Would it also work if
> > I already have that page saved in my local drive and want the function to
> > point to the local page instead?
> >
>
http://markets.
Is there an url that will go to annual and one that will go to interim?
--- In smf_addin@yahoogrou
>
> Sure. I've done that before. Here is an example:
>
> =RCHGetTableCell(
>
> In this case, it had been a dynamically displayed web page. But, by saving
> it to my hard drive, the dynamic data is now stored within the file.
>
> On Mon, Aug 5, 2013 at 2:36 PM, lawrence.leesh <lawrence.
>
> >
> > Currently the RCHGetTable functions point to a url. Would it also work if
> > I already have that page saved in my local drive and want the function to
> > point to the local page instead?
> >
>
Tue Aug 6, 2013 8:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't see a bookmarkable URL for the interim data...
On Tue, Aug 6, 2013 at 6:20 AM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
> Thanks. I'll try that. I am trying to have an offsite browser
> automatically go to the annual and interim data page and save them.
> However, both seems to have the same url.
>
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=C6U:SES&subview=BalanceSheet
> Is there an url that will go to annual and one that will go to interim?
>
On Tue, Aug 6, 2013 at 6:20 AM, lawrence.leesh <lawrence.leesh@
> Thanks. I'll try that. I am trying to have an offsite browser
> automatically go to the annual and interim data page and save them.
> However, both seems to have the same url.
>
> http://markets.
> Is there an url that will go to annual and one that will go to interim?
>
Tue Aug 6, 2013 12:01 pm (PDT) . Posted by:
"justvotin1" justvotin1
Kermit,
I came across the same issue. I've been manually filling in mine using Etrade. I wish there was a way to get this to work with Etrade but I'm not good enough with VBA to get it to save a cookie and present a security certificate to check the Etrade site. You don't have to have an account to check stock info including Ex date but it is still HTTPS. As far as calculating not yet announced ones, you could easily average the last couple from the dividend website.
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> Randy, Do you or anyone else know of a reliable place to get the next
> EX-Dividend Dates?
>
> Back in message 22829 you wrote: I prefer to estimate the forward
> ex-dividend date myself, because too often the dividend is declared only a
> few days ahead of the ex-dividend date.
>
> My question is how do you do that? Do you have a spreadsheet that calculates
> it? Do you do it manually? Is it just a best guess?
>
> You, also, listed several yahoo key statistic elements that contain dividend
> information.
>
> Unfortunately, there are a great many reasonable yielding dividend stocks
> that Yahoo does not have in its key statistics function.
>
> Any idea how yahoo determines which stocks they list?
>
> Here is a short list of stocks that do not have Yahoo Key statistics:
>
> ARCC
>
> GMLP
>
> PFLT
>
> BGB
>
> EOD
>
> FDUS
>
> FEI
>
> FEZ
>
> GBDC
>
> PNNT
>
> REM
>
> SIR
>
> TAN
>
> TCPC
>
> TEI
>
> WHF
>
> KAP
>
I came across the same issue. I've been manually filling in mine using Etrade. I wish there was a way to get this to work with Etrade but I'm not good enough with VBA to get it to save a cookie and present a security certificate to check the Etrade site. You don't have to have an account to check stock info including Ex date but it is still HTTPS. As far as calculating not yet announced ones, you could easily average the last couple from the dividend website.
--- In smf_addin@yahoogrou
>
> Randy, Do you or anyone else know of a reliable place to get the next
> EX-Dividend Dates?
>
> Back in message 22829 you wrote: I prefer to estimate the forward
> ex-dividend date myself, because too often the dividend is declared only a
> few days ahead of the ex-dividend date.
>
> My question is how do you do that? Do you have a spreadsheet that calculates
> it? Do you do it manually? Is it just a best guess?
>
> You, also, listed several yahoo key statistic elements that contain dividend
> information.
>
> Unfortunately, there are a great many reasonable yielding dividend stocks
> that Yahoo does not have in its key statistics function.
>
> Any idea how yahoo determines which stocks they list?
>
> Here is a short list of stocks that do not have Yahoo Key statistics:
>
> ARCC
>
> GMLP
>
> PFLT
>
> BGB
>
> EOD
>
> FDUS
>
> FEI
>
> FEZ
>
> GBDC
>
> PNNT
>
> REM
>
> SIR
>
> TAN
>
> TCPC
>
> TEI
>
> WHF
>
> KAP
>
Tue Aug 6, 2013 12:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Once I've visited a quote page on eTrade in IE, this appears to work fine:
=RCHGetTableCell("
https://www.etrade.wallst.com/v1/stocks/snapshot/snapshot.asp?symbol=MMM ",
1,">Ex-Dividend Date")
So I'm assuming visiting a quote page creates the necessary cookie for
further accesses.
On Tue, Aug 6, 2013 at 9:50 AM, justvotin1 <justvotin1@yahoo.com > wrote:
>
> I came across the same issue. I've been manually filling in mine using
> Etrade. I wish there was a way to get this to work with Etrade but I'm not
> good enough with VBA to get it to save a cookie and present a security
> certificate to check the Etrade site. You don't have to have an account to
> check stock info including Ex date but it is still HTTPS. As far as
> calculating not yet announced ones, you could easily average the last
> couple from the dividend website.
>
=RCHGetTableCell(
https://www.
1,">
So I'm assuming visiting a quote page creates the necessary cookie for
further accesses.
On Tue, Aug 6, 2013 at 9:50 AM, justvotin1 <justvotin1@yahoo.
>
> I came across the same issue. I've been manually filling in mine using
> Etrade. I wish there was a way to get this to work with Etrade but I'm not
> good enough with VBA to get it to save a cookie and present a security
> certificate to check the Etrade site. You don't have to have an account to
> check stock info including Ex date but it is still HTTPS. As far as
> calculating not yet announced ones, you could easily average the last
> couple from the dividend website.
>
Tue Aug 6, 2013 12:47 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I just tired the link and I get an Error.
=RCHGetTableCell("https://www.etrade.wallst.com/v1/stocks/snapshot/snapshot.asp?symbol=MMM ",
1,">Ex-Dividend Date")
When I post it into a browser it puts up the Etrade secure logon page.
I logged onto Etrade and it still failed.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Tuesday, August 06, 2013 3:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Next EX-Dividend Date
Once I've visited a quote page on eTrade in IE, this appears to work fine:
=RCHGetTableCell("https://www.etrade.wallst.com/v1/stocks/snapshot/snapshot.asp?symbol=MMM ",
1,">Ex-Dividend Date")
So I'm assuming visiting a quote page creates the necessary cookie for further accesses.
On Tue, Aug 6, 2013 at 9:50 AM, justvotin1 <justvotin1@yahoo.com > wrote:
I came across the same issue. I've been manually filling in mine using Etrade. I wish there was a way to get this to work with Etrade but I'm not good enough with VBA to get it to save a cookie and present a security certificate to check the Etrade site. You don't have to have an account to check stock info including Ex date but it is still HTTPS. As far as calculating not yet announced ones, you could easily average the last couple from the dividend website.
=RCHGetTableCell(
1,">
When I post it into a browser it puts up the Etrade secure logon page.
I logged onto Etrade and it still failed.
From: smf_addin@yahoogrou
Sent: Tuesday, August 06, 2013 3:16 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Next EX-Dividend Date
Once I've visited a quote page on eTrade in IE, this appears to work fine:
=RCHGetTableCell(
1,">
So I'm assuming visiting a quote page creates the necessary cookie for further accesses.
On Tue, Aug 6, 2013 at 9:50 AM, justvotin1 <justvotin1@yahoo.
I came across the same issue. I've been manually filling in mine using Etrade. I wish there was a way to get this to work with Etrade but I'm not good enough with VBA to get it to save a cookie and present a security certificate to check the Etrade site. You don't have to have an account to check stock info including Ex date but it is still HTTPS. As far as calculating not yet announced ones, you could easily average the last couple from the dividend website.
Tue Aug 6, 2013 1:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I first created it, I got "Error" as well.
Then:
1. I opened up the EXCEL Web Query dialog,
2. I went to https://us.etrade.com/home
3. I entered a ticker symbol in the box
4. After the snapshot came up, I cancelled out of the EXCEL Web Query
dialog.
5. I ran smfForceRecalculation to get a fresh copy of the web page
I got back the ex-dividend date. I then changed the ticker symbol, and got
the ex-dividend date for that ticker symbol.
And, yes, if you haven't gone through the steps above, you will get the
secure logon page.
BTW -- I'm not an eTrade customer, so I can't log on.
On Tue, Aug 6, 2013 at 12:47 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I just tired the link and I get an Error.****
>
> ** **
>
> =RCHGetTableCell("
> https://www.etrade.wallst.com/v1/stocks/snapshot/snapshot.asp?symbol=MMM ",
> 1,">Ex-Dividend Date")****
>
> ** **
>
> When I post it into a browser it puts up the Etrade secure logon page. ***
> *
>
> I logged onto Etrade and it still failed.
>
Then:
1. I opened up the EXCEL Web Query dialog,
2. I went to https://us.etrade.
3. I entered a ticker symbol in the box
4. After the snapshot came up, I cancelled out of the EXCEL Web Query
dialog.
5. I ran smfForceRecalculati
I got back the ex-dividend date. I then changed the ticker symbol, and got
the ex-dividend date for that ticker symbol.
And, yes, if you haven't gone through the steps above, you will get the
secure logon page.
BTW -- I'm not an eTrade customer, so I can't log on.
On Tue, Aug 6, 2013 at 12:47 PM, Kermit W. Prather
<kermitp@tampabay.
>
> I just tired the link and I get an Error.****
>
> ** **
>
> =RCHGetTableCell(
> https://www.
> 1,">
>
> ** **
>
> When I post it into a browser it puts up the Etrade secure logon page. ***
> *
>
> I logged onto Etrade and it still failed.
>
Tue Aug 6, 2013 12:01 pm (PDT) . Posted by:
"Robert" bfleckal
Hi,
Just joined the group. Actually, I tried joining it yesterday and sent out a message and the first two replies came back in a foreign language which I couldn't read. Used an existing profile which I know works on other Yahoo Groups. So, will try again. My question is:
Will this addin for excel spreadsheets, importing stock quotes work with MS Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS? Thanks for any help you can give me.
Bob
Just joined the group. Actually, I tried joining it yesterday and sent out a message and the first two replies came back in a foreign language which I couldn't read. Used an existing profile which I know works on other Yahoo Groups. So, will try again. My question is:
Will this addin for excel spreadsheets, importing stock quotes work with MS Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS? Thanks for any help you can give me.
Bob
Tue Aug 6, 2013 12:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure why you got something in a foreign language.
As far as I know, the add-in will work with EXCEL 2010 in either
environment.
On Tue, Aug 6, 2013 at 9:29 AM, Robert <bfleckal@yahoo.com > wrote:
> Hi,
> Just joined the group. Actually, I tried joining it yesterday and sent
> out a message and the first two replies came back in a foreign language
> which I couldn't read. Used an existing profile which I know works on other
> Yahoo Groups. So, will try again. My question is:
> Will this addin for excel spreadsheets, importing stock quotes work with
> MS Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS?
> Thanks for any help you can give me.
> Bob
>
As far as I know, the add-in will work with EXCEL 2010 in either
environment.
On Tue, Aug 6, 2013 at 9:29 AM, Robert <bfleckal@yahoo.
> Hi,
> Just joined the group. Actually, I tried joining it yesterday and sent
> out a message and the first two replies came back in a foreign language
> which I couldn't read. Used an existing profile which I know works on other
> Yahoo Groups. So, will try again. My question is:
> Will this addin for excel spreadsheets, importing stock quotes work with
> MS Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS?
> Thanks for any help you can give me.
> Bob
>
Tue Aug 6, 2013 12:26 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
It works in both. I use it on XP (yep still works), Vista 64bit and Win7
32bit and win7 64 bit.
Check out the files section. You will find templates for almost any part of
the ADDIN.
Also, look in each folder in the files section. I always do before I start a
new spreadsheet.
Randy runs the group and answers most question, no matter how dumb or
trivial, within a few hours.
He, also, will usually respond with the best way to do something, if you
have at least tried.
I recommend you read the doc and study the
RCHGetElementNumber-Element-Definitions.xls which has all the elements
defined.
The best way to find if there is an element already define is to search the
element spreadsheet before asking anyone.
Do a search all as there are multiple places where field such as YIELD are
defined.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Robert
Sent: Tuesday, August 06, 2013 12:30 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Just joined: quick question re smf_addin
Hi,
Just joined the group. Actually, I tried joining it yesterday and sent
out a message and the first two replies came back in a foreign language
which I couldn't read. Used an existing profile which I know works on other
Yahoo Groups. So, will try again. My question is:
Will this addin for excel spreadsheets, importing stock quotes work with MS
Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS? Thanks
for any help you can give me.
Bob
------------------------------------
Yahoo! Groups Links
32bit and win7 64 bit.
Check out the files section. You will find templates for almost any part of
the ADDIN.
Also, look in each folder in the files section. I always do before I start a
new spreadsheet.
Randy runs the group and answers most question, no matter how dumb or
trivial, within a few hours.
He, also, will usually respond with the best way to do something, if you
have at least tried.
I recommend you read the doc and study the
RCHGetElementNumber
defined.
The best way to find if there is an element already define is to search the
element spreadsheet before asking anyone.
Do a search all as there are multiple places where field such as YIELD are
defined.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Of Robert
Sent: Tuesday, August 06, 2013 12:30 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Just joined: quick question re smf_addin
Hi,
Just joined the group. Actually, I tried joining it yesterday and sent
out a message and the first two replies came back in a foreign language
which I couldn't read. Used an existing profile which I know works on other
Yahoo Groups. So, will try again. My question is:
Will this addin for excel spreadsheets, importing stock quotes work with MS
Office 2010 - the 64bit OS? If not, will it work on the 32 bit OS? Thanks
for any help you can give me.
Bob
------------
Yahoo! Groups Links
Tue Aug 6, 2013 12:58 pm (PDT) . Posted by:
"madispa" madispa
It looks like ADVFN might have quit loading new Quarterly earnings reports into their site. Some companies that reported back in May (like WAG and FDS as examples) still show the February quarter as the latest. I am not seeing any June quarterly numbers for any of the companies even though several have already filed their 10-Q.
Anybody have any ideas on this? I use ADVFN financials to do historical fundamental analysis on companies. May have to find another source.
Thanks,
Paul Madison
Anybody have any ideas on this? I use ADVFN financials to do historical fundamental analysis on companies. May have to find another source.
Thanks,
Paul Madison
Tue Aug 6, 2013 1:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This was discussed recently. Take a look at the message archives. I think
it was identified as a temporary issue...
On Tue, Aug 6, 2013 at 12:58 PM, madispa <madispa@gmail.com > wrote:
> It looks like ADVFN might have quit loading new Quarterly earnings reports
> into their site. Some companies that reported back in May (like WAG and
> FDS as examples) still show the February quarter as the latest. I am not
> seeing any June quarterly numbers for any of the companies even though
> several have already filed their 10-Q.
>
> Anybody have any ideas on this? I use ADVFN financials to do historical
> fundamental analysis on companies. May have to find another source.
>
it was identified as a temporary issue...
On Tue, Aug 6, 2013 at 12:58 PM, madispa <madispa@gmail.
> It looks like ADVFN might have quit loading new Quarterly earnings reports
> into their site. Some companies that reported back in May (like WAG and
> FDS as examples) still show the February quarter as the latest. I am not
> seeing any June quarterly numbers for any of the companies even though
> several have already filed their 10-Q.
>
> Anybody have any ideas on this? I use ADVFN financials to do historical
> fundamental analysis on companies. May have to find another source.
>
Tue Aug 6, 2013 1:04 pm (PDT) . Posted by:
"bablam" bablam
Hi,
I am using a sheet I previously built to analyze another stock, and noticed that unlike before, the sheet returns wrong dates for Qtr. End., and hence all the data from AdvFN is also wrong for those qtrs.
Let me explain,
Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20, which in this case would be sequentially Mar 2013, Dec 2012....
However, using the same codes I used before, for the same sheet, I am getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06, 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again and again, while the no. it is referring to are in the correct sequence 8006-8025.
Can you help?
Thanks,
Manish
I am using a sheet I previously built to analyze another stock, and noticed that unlike before, the sheet returns wrong dates for Qtr. End., and hence all the data from AdvFN is also wrong for those qtrs.
Let me explain,
Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20, which in this case would be sequentially Mar 2013, Dec 2012....
However, using the same codes I used before, for the same sheet, I am getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06, 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again and again, while the no. it is referring to are in the correct sequence 8006-8025.
Can you help?
Thanks,
Manish
Tue Aug 6, 2013 1:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think this happens when a stock doesn't have much history. What ticker
symbol did you get this for?
On Tue, Aug 6, 2013 at 1:04 PM, bablam <mbabla@gmail.com > wrote:
>
> I am using a sheet I previously built to analyze another stock, and
> noticed that unlike before, the sheet returns wrong dates for Qtr. End.,
> and hence all the data from AdvFN is also wrong for those qtrs.
>
> Let me explain,
> Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20,
> which in this case would be sequentially Mar 2013, Dec 2012....
>
> However, using the same codes I used before, for the same sheet, I am
> getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts
> with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06,
> 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again
> and again, while the no. it is referring to are in the correct sequence
> 8006-8025.
>
> Can you help?
>
symbol did you get this for?
On Tue, Aug 6, 2013 at 1:04 PM, bablam <mbabla@gmail.
>
> I am using a sheet I previously built to analyze another stock, and
> noticed that unlike before, the sheet returns wrong dates for Qtr. End.,
> and hence all the data from AdvFN is also wrong for those qtrs.
>
> Let me explain,
> Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20,
> which in this case would be sequentially Mar 2013, Dec 2012....
>
> However, using the same codes I used before, for the same sheet, I am
> getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts
> with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06,
> 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again
> and again, while the no. it is referring to are in the correct sequence
> 8006-8025.
>
> Can you help?
>
Tue Aug 6, 2013 2:06 pm (PDT) . Posted by:
"Manish Babla" bablam
Hi Randy:
Thanks for your response.
I tried this for many tickers, including MSFT. I have attached a small
sheet with just the 8006-8025 codes, with row 4 being the values pasted
from what I am getting, and row 1 having the actual codes, so you can see
what I am seeing as well. Also, I have used this previously in a large
spreadsheet, and have successfully gotten the prior quarters, but the same
spreadsheet when opened now even for the same symbol shows the above
malfunction i.e., missing quarters and repeated same quarters.
Regards,
Manish
On Tue, Aug 6, 2013 at 4:54 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> I think this happens when a stock doesn't have much history. What ticker
> symbol did you get this for?
>
>
> On Tue, Aug 6, 2013 at 1:04 PM, bablam <mbabla@gmail.com > wrote:
>
>>
>> I am using a sheet I previously built to analyze another stock, and
>> noticed that unlike before, the sheet returns wrong dates for Qtr. End.,
>> and hence all the data from AdvFN is also wrong for those qtrs.
>>
>> Let me explain,
>> Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20,
>> which in this case would be sequentially Mar 2013, Dec 2012....
>>
>> However, using the same codes I used before, for the same sheet, I am
>> getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts
>> with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06,
>> 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again
>> and again, while the no. it is referring to are in the correct sequence
>> 8006-8025.
>>
>> Can you help?
>>
>
>
>
Thanks for your response.
I tried this for many tickers, including MSFT. I have attached a small
sheet with just the 8006-8025 codes, with row 4 being the values pasted
from what I am getting, and row 1 having the actual codes, so you can see
what I am seeing as well. Also, I have used this previously in a large
spreadsheet, and have successfully gotten the prior quarters, but the same
spreadsheet when opened now even for the same symbol shows the above
malfunction i.e., missing quarters and repeated same quarters.
Regards,
Manish
On Tue, Aug 6, 2013 at 4:54 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> I think this happens when a stock doesn't have much history. What ticker
> symbol did you get this for?
>
>
> On Tue, Aug 6, 2013 at 1:04 PM, bablam <mbabla@gmail.
>
>>
>> I am using a sheet I previously built to analyze another stock, and
>> noticed that unlike before, the sheet returns wrong dates for Qtr. End.,
>> and hence all the data from AdvFN is also wrong for those qtrs.
>>
>> Let me explain,
>> Codes 8006-8025 for RCHGetElementNumber refer to Qtr End Dates FQ1-FQ20,
>> which in this case would be sequentially Mar 2013, Dec 2012....
>>
>> However, using the same codes I used before, for the same sheet, I am
>> getting instead, -- 2013/03, 2012/12, 2012/09, 2012/06, and then it starts
>> with wrong dates, the next one being, 2013/03, 2012/12, 2012/09, 2012/06,
>> 2012/03, and then again 2012/12, 2012/09, 2012/06, repeating itself again
>> and again, while the no. it is referring to are in the correct sequence
>> 8006-8025.
>>
>> Can you help?
>>
>
>
>
Attachments with this message:
1 of 1 File(s)
Tue Aug 6, 2013 2:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what to tell you. When I open your workbook, row 1 starts at
2013/03 and continues downward to 2008/06. So the formulas are working fine
here. Are you using a prefix with AdvFN? Do you need one?
AdvFN display five periods at a time, and it appears you are getting the
first five periods repeated.
What do you get with:
=smfGetADVFNElement("MSFT";,"Q",999)
=RCHGetElementNumber("HD",8006)
=smfGetTagContent("
http://www.advfn.com/p.php?pid=financials&symbol=MSFT&mode=quarterly_reports
","title")
I'm getting 77 for the first item, which is telling me there are 77
quarterly periods of data available. The second formula returns "2013/04",
because Home Depot has a different fiscal year. I'm thinking if you still
get 2013/03 from that, that any visit to AdvFN is just returning their
default page.
If you are using a prefix, use it in the third formula above. Also, try
that URL in your browser and see if it redirects you to a different URL,
and check if what is on the page is for MSFT.
On Tue, Aug 6, 2013 at 2:06 PM, Manish Babla <mbabla@gmail.com > wrote:
>
> I tried this for many tickers, including MSFT. I have attached a small
> sheet with just the 8006-8025 codes, with row 4 being the values pasted
> from what I am getting, and row 1 having the actual codes, so you can see
> what I am seeing as well. Also, I have used this previously in a large
> spreadsheet, and have successfully gotten the prior quarters, but the same
> spreadsheet when opened now even for the same symbol shows the above
> malfunction i.e., missing quarters and repeated same quarters.
>
>
2013/03 and continues downward to 2008/06. So the formulas are working fine
here. Are you using a prefix with AdvFN? Do you need one?
AdvFN display five periods at a time, and it appears you are getting the
first five periods repeated.
What do you get with:
=smfGetADVFNElement
=RCHGetElementNumbe
=smfGetTagContent(
http://www.advfn.
","
I'm getting 77 for the first item, which is telling me there are 77
quarterly periods of data available. The second formula returns "2013/04"
because Home Depot has a different fiscal year. I'm thinking if you still
get 2013/03 from that, that any visit to AdvFN is just returning their
default page.
If you are using a prefix, use it in the third formula above. Also, try
that URL in your browser and see if it redirects you to a different URL,
and check if what is on the page is for MSFT.
On Tue, Aug 6, 2013 at 2:06 PM, Manish Babla <mbabla@gmail.
>
> I tried this for many tickers, including MSFT. I have attached a small
> sheet with just the 8006-8025 codes, with row 4 being the values pasted
> from what I am getting, and row 1 having the actual codes, so you can see
> what I am seeing as well. Also, I have used this previously in a large
> spreadsheet, and have successfully gotten the prior quarters, but the same
> spreadsheet when opened now even for the same symbol shows the above
> malfunction i.e., missing quarters and repeated same quarters.
>
>
Tidak ada komentar:
Posting Komentar