Sabtu, 06 Februari 2016

[smf_addin] Digest Number 3627

7 Messages

Digest #3627

Messages

Sat Feb 6, 2016 12:35 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Retrieve the CSV file into one worksheet using smfGetCSVFile() and pull the
data into your template with EXCEL LOOKUP functions.

Otherwise, you have the same problem -- they dynamically create their web
pages and the raw data is in JSON format.

On Sat, Feb 6, 2016 at 1:32 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> but I'm trying to automate my template, getting a csv file I would not be
> able to automate my template?
>

Sat Feb 6, 2016 12:39 am (PST) . Posted by:

perseuslim11

I'm unable to pull the income statement with the smfgetcsvfile function?

Sat Feb 6, 2016 12:41 am (PST) . Posted by:

perseuslim11

I've used this formula: =smfGetCSVFile("http://financials.morningstar.com/income-statement/is.html?t=7160®ion=mys&culture=en-US")



and is it possible to get data with rounding to thousands only?
as rounding to millions give me zeroes for many things..


Sat Feb 6, 2016 12:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's not the CSV file mentioned in the reference I gave you.

You can change the rounding by using the rounding parameter.

Use ticker symbol XKLS:7160.

On Sat, Feb 6, 2016 at 1:41 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I've used this formula:
> =smfGetCSVFile("
> http://financials.morningstar.com/income-statement/is.html?t=7160®ion=mys&culture=en-US
> ")
>
> and is it possible to get data with rounding to thousands only?
> as rounding to millions give me zeroes for many things..
>
>

Sat Feb 6, 2016 1:59 am (PST) . Posted by:

perseuslim11

hi randy, below are what you taught:

=smfGetCSVFile("http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=GOOG&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")

...where:

-- "reportType&quot; can be "is", "bs", or "cf" (which statement you want).
-- "period" can be 3 or 12 (quarterly or annual).
-- "dataType"; can be "A" or "R" (As Reported or Restated).
-- "order" can be "asc" or "desc" (order of the years/quarters going across).
-- "columnYear&quot; can be 5 or 10 (number of columns of data).
-- "denominatorView" can be "raw" or "percentage&quot;

So you could do any of those in an individual worksheet and then reference the items you want to present.



but how to set rounding to thousands? it's not stated?
default rounding is =3


what number for rounding to thousands?


Sat Feb 6, 2016 2:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Hmmm....

I think it's actually:

&number=1 for dollars
&number=2 for thousands
&number=3 for millions
&number=4 for billions

The rounding parameter may need to be set to the same value, but maybe not?

On Sat, Feb 6, 2016 at 2:59 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> hi randy, below are what you taught:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/ReportProcess4CSV.html?t=GOOG&reportType=is&period=12&dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw
> ")
>
> ...where:
>
> -- "reportType&quot; can be "is", "bs", or "cf" (which statement you want).
> -- "period" can be 3 or 12 (quarterly or annual).
> -- "dataType"; can be "A" or "R" (As Reported or Restated).
> -- "order" can be "asc" or "desc" (order of the years/quarters going
> across).
> -- "columnYear&quot; can be 5 or 10 (number of columns of data).
> -- "denominatorView" can be "raw" or "percentage&quot;
>
> So you could do any of those in an individual worksheet and then reference
> the items you want to present.
>
> but how to set rounding to thousands? it's not stated?
> default rounding is =3
>
> what number for rounding to thousands?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.20

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)