Messages In This Digest (3 Messages)

1a.: Re: Converting cumulative financial data for quarterly cashflow stat From: MikeM

Messages

1a.: Re: Converting cumulative financial data for quarterly cashflow stat

Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802

Sun May 27, 2012 5:56 am (PDT)

Retrieve the last 5 quarters of data and include the quarterly period number from AdvFN. Put them in sequence. Example

Quarter, Cash From Ops
2 120
1 45
4 220
3 180
2 130

Then, use an IF statement to derive the quarterly amount.

If the quarter is 1, the number is good as is. For all others just take its number and subtract the previous quarter.

For companies reporting twice/year, then if quarter is 2 the number is good as is and for period 4 its still right to subtract the previous period (which is 2). There is an indicator on AdvFN about the number of reporting periods.

I don't know what you mean about "overlapping periods" or non-uniform segments.

--- In smf_addin@yahoogroups.com, "redcorolla9999" <redcorolla9999@...> wrote:
>
> Hi,
>
> In Reuters (and most other sources), the cumulative data is given for the quarterly cash-flow statements.
> Does anyone know a good general way to convert this to individual quarters?
>
> This is especially tricky when some of the cumulative data covers over-lapping periods, and the data segments are not uniform.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: Re: Which function to use for basic company stats from advfn

Posted by: "B B" kokdari82@yahoo.com kokdari82

Sun May 27, 2012 1:34 pm (PDT)

perfect.
Thank you. I was using 1 instead of 0 which kept throwing me off.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can use RCHGetTableCell() for both. However, you're still going to have
> to do manual extraction of the data you want because of the way it's
> presented (combined with labels, etc).
>
> To retrieve the raw data from the page:
>
> =RCHGetTableCell("http://www.advfn.com/p.php?pid=qkquote&symbol=qsii",0,">Company
> Description")
> =RCHGetTableCell("http://www.advfn.com/p.php?pid=qkquote&symbol=qsii",0,">Stock
> Market")
>
> Then use smfStrExtr() to pull out the pieces you need.
>
> On Sat, May 26, 2012 at 4:53 PM, B B <kokdari82@...> wrote:
>
> > Since ADVFN seems to be the most stable of data sources at the moment, I'm
> > trying to extract the basic stats from advfn but I'm having trouble
> > extracting the information with their layout.
> >
> > http://www.advfn.com/p.php?pid=qkquote&symbol=qsii
> >
> > Which function would be best to get the company description as well as
> > which stock market it is listed in?
> >
> > RCHGetTableCell
> > RCHGetWebData
> > smfGetTagContent
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3.1.: Re: New file uploaded to smf_addin

Posted by: "dice962" derekbarrett@gmail.com dice962

Sun May 27, 2012 4:38 pm (PDT)

Thanks, solved my MSN updates. Thanks for all the hardwork on the add in !!!

--- In smf_addin@yahoogroups.com, smf_addin@yahoogroups.com wrote:
>
>
> Hello,
>
> This email message is a notification to let you know that
> a file has been uploaded to the Files area of the smf_addin
> group.
>
> File : /Works-In-Progress/smf-elements-1.txt
> Uploaded by : rharmelink <rharmelink@...>
> Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-1.txt
>
> To learn more about file sharing for your group, please visit:
> http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
> Regards,
>
> rharmelink <rharmelink@...>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (267)

Messages | Files | Photos | Polls