Sabtu, 06 Februari 2016

[smf_addin] Digest Number 3626

15 Messages

Digest #3626

Messages

Fri Feb 5, 2016 2:29 am (PST) . Posted by:

perseuslim11

Hi Randy, I would like to know whether you or anyone else here know of how to construct a peter lynch chart in excel? like in this example (Gurufocus) Wal-Mart Stores Inc Interactive Charts --GuruFocus.com http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0



Wal-Mart Stores Inc Interactive Charts --GuruFocus.com http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0 Build Your Own Customized Series - step 1 of 2 Please input the mathematical formula below with financial series name and Math symbols + - * / ( ) .



View on www.gurufocus.com http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0
Preview by Yahoo





and please suggest of a website (preferably non-premium sites) from which I could get data for "EPS" and "Quarterly Prices" which are needed for peter lynch chart, thanks ^^



Fri Feb 5, 2016 7:01 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Just do an internet search with stock charts in excel

Here is a short video – not a professional video but it helps

<https://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjeptyB8eDKAhWFFx4KHa6lCK4QtwIIKzAB&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DBeuWBeGCBys&usg=AFQjCNE1Fz5sYgoVi80Yfwj358EitgbBYA> How to create Stock chart in Excel 2010 - YouTube
<https://www.youtube.com/watch?v=BeuWBeGCBys> ▶ 2:02
https://www.youtube.com/watch?v=BeuWBeGCBys
Mar 19, 2010 - Uploaded by CatchTheWolf
How to create Stock chart in Excel 2010. ... How-to Create an Excel Candle Stick Stock Chart (Open-High-Low ...


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, February 05, 2016 5:29 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..


Hi Randy, I would like to know whether you or anyone else here know of how to construct a peter lynch chart in excel? like in this example (Gurufocus) Wal-Mart Stores Inc Interactive Charts --GuruFocus.com <http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0>



<http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0> Wal-Mart Stores Inc Interactive Charts --GuruFocus.com
Build Your Own Customized Series - step 1 of 2 Please input the mathematical formula below with financial series name and Math symbols + - * / ( ) .


<http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0> View on www.gurufocus.com
Preview by Yahoo





and please suggest of a website (preferably non-premium sites) from which I could get data for "EPS" and "Quarterly Prices" which are needed for peter lynch chart, thanks ^^


Fri Feb 5, 2016 7:36 am (PST) . Posted by:

perseuslim11

actually, what I meant was Peter Lynch chart?

and also, how to choose the PE used for deriving the price?
and how to make the chart become logarithmic?

Fri Feb 5, 2016 8:13 pm (PST) . Posted by:

perseuslim11

Hi Randy, is it possible to get the Balance sheet, Income statement and Cash flow statement from this link? https://online.capitalcube.com/#!/stock/my/malaysia/5053/financials https://online.capitalcube.com/#!/stock/my/malaysia/5053/financials


CapitalCube - Fundamental Analysis On Demand https://online.capitalcube.com/#!/stock/my/malaysia/5053/financials {{$route.current.scope.metaDescription}}



View on online.capitalcube.com https://online.capitalcube.com/#!/stock/my/malaysia/5053/financials
Preview by Yahoo





Thanks! :)

Fri Feb 5, 2016 11:09 pm (PST) . Posted by:

perseuslim11

I've tried : =RCHGetHTMLTable("https://online.capitalcube.com/#!/stock/my/malaysia/7160/financials/income-statement","company (",1,"",1)



but unable to get the table..


Also tried this:
=RCHGetHTMLTable("https://online.capitalcube.com/#!/stock/my/malaysia/7160/financials/income-statement","Sales/Revenue&quot;,1,"",1)



Your help will be greatly appreciated ^^ , sorry, I've really tried but couldn't figure out what I've done wrong so as to not being able to get the table.. hmm..





Fri Feb 5, 2016 11:19 pm (PST) . Posted by:

perseuslim11

oh ya, forgot to mention that I would like to pull both the annual and quarterly tables for income statement, balance sheet and cash flow statements, thanks ^^

Quarterly one is as shown in this url:
https://online.capitalcube.com/#!/stock/my/malaysia/7160/financials/income-statement?duration=2 https://online.capitalcube.com/#!/stock/my/malaysia/7160/financials/income-statement?duration=2



the annual one is in my previous msg :)


Thanks so much Randy, and sorry for troubling you again... :(

Fri Feb 5, 2016 11:40 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You should be able to get the EPS from AdvFN and the quarterly prices from
Yahoo Historical prices (using smfPricesByDates).

On Fri, Feb 5, 2016 at 3:29 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, I would like to know whether you or anyone else here know of how
> to construct a peter lynch chart in excel? like in this example (Gurufocus) Wal-Mart
> Stores Inc Interactive Charts --GuruFocus.com
> <http://www.gurufocus.com/chart/WMT#&serie=,,id:price,s:WMT,,id:custompe,s:WMT&log=0&per=0>
>
> and please suggest of a website (preferably non-premium sites) from which
> I could get data for "EPS" and "Quarterly Prices" which are needed for
> peter lynch chart, thanks ^^
>
>

Fri Feb 5, 2016 11:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The Microsoft protocol I use with the add-in doesn't allow the positioning
character in the URL (i.e. "#"). Besides that, the web page is dynamically
created, so there is no data to extract from the source code of the web
page.

As far as I can see, the only choice would be to extract the statements and
time periods from the JSON output used to build the web page, such as:

https://online.capitalcube.com/api/companies/5053-my/reports/financials/balance-sheet?currency=1&dataType=&duration=0

Not a trivial process.

On Fri, Feb 5, 2016 at 9:13 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, is it possible to get the Balance sheet, Income statement and
> Cash flow statement from this link?
> https://online.capitalcube.com/#!/stock/my/malaysia/5053/financials
> Thanks! :)
>
>

Fri Feb 5, 2016 11:52 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but that's where the data is...

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

>
> hmm.. there's no other way?
>
>
>

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

perseuslim11

i see, ok, thanks for your clarification ^^ I'll try finding other sites first haha

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

perseuslim11

can you please give me an example of formla to pull data from morningstar then? I would need the annual data and also quarterly data for:
income statement, balance sheet, cash flow statement, key ratios tab


thanks Randy ^^

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

perseuslim11

preferably with the numbers rounding set to thousands only, because initially the morningstar rounding sets to millions.. which for many companies, the values get rounded to zero...

hope that you can guide me on getting the annual and quarterly datas rounded to thousands only, thanks! :)

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

"Randy Harmelink" rharmelink

The best way to get the financial statements from MorningStar is by using
their CSV files. Check the "Tips and FAQs" page for a link to info on those
files.

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

>
> can you please give me an example of formla to pull data from morningstar
> then?
> I would need the annual data and also quarterly data for:
> income statement, balance sheet, cash flow statement, key ratios tab
>
>
>

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

perseuslim11

but I'm trying to automate my template, getting a csv file I would not be able to automate my template?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 00.32

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)