4 Messages
Digest #3131
Messages
Fri Jul 25, 2014 3:58 am (PDT) . Posted by:
"Ronald Gapuz" rongapuz
Dear Randy,
Thank you very much. You are a blessing.
Regards,
On 7/24/2014 12:38 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Try something like:
>
> =smfConvertData(smfGetTagContent("http://www.stocksph.com/stocks/CEI/","span",1,">Last
> Trade Price:"))
>
> On Thu, Jul 24, 2014 at 1:07 AM, Ronald Gapuz ronald.gapuz@...wrote:
>
> i was trying to get the prices from this website
>
> http://www.stocksph.com/stocks/CEI/
>
> Unfortunately, I was not successful. Can please someone help me.
>
>
>
Thank you very much. You are a blessing.
Regards,
On 7/24/2014 12:38 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Try something like:
>
> =smfConvertData(smfGetTagContent("http://www.stocksph.com/stocks/CEI/","span",1,">Last
> Trade Price:"))
>
> On Thu, Jul 24, 2014 at 1:07 AM, Ronald Gapuz ronald.gapuz@...wrote:
>
> i was trying to get the prices from this website
>
> http://www.stocksph.com/stocks/CEI/
>
> Unfortunately, I was not successful. Can please someone help me.
>
>
>
Fri Jul 25, 2014 7:08 am (PDT) . Posted by:
fredwwright
When you are on Schwab.com you:
Click on Research/Stocks
Then on Stock Screeners
Then select some criteria from the left side - preferably a unique combination that is less than 1000 stocks - and includes the fields you want to export.
Then click on View Matches
When you see the list click on Export (it is near the upper right next to the print function.
You would then repeat for various groupings to get all the Stocks you want - the problem is with the middle group (Schwab ratings = C) since it has 1,214 stocks and you can only download 1000 at a time (so you need some other criteria to split that group into two unique parts. After you download you can copy/past each sub-group into one spreadsheet and then use VLookup to pull out what you want.
Hope that helps.
Fred
Click on Research/Stocks
Then on Stock Screeners
Then select some criteria from the left side - preferably a unique combination that is less than 1000 stocks - and includes the fields you want to export.
Then click on View Matches
When you see the list click on Export (it is near the upper right next to the print function.
You would then repeat for various groupings to get all the Stocks you want - the problem is with the middle group (Schwab ratings = C) since it has 1,214 stocks and you can only download 1000 at a time (so you need some other criteria to split that group into two unique parts. After you download you can copy/past each sub-group into one spreadsheet and then use VLookup to pull out what you want.
Hope that helps.
Fred
Data Element 971 is Yahoo's Levered Free Cash Flow. Questions:
(1) Is this the same as what other sites simply call Free Cash Flow?
(2) How come sometimes (eg, SLB, JNJ) Yahoo's Key Statistics screen display N/A for Levered Free Cash Flow whereas companies (those two certainly) generate free cash flow? Does that mean Levered is not the same as FCF? Or Is this an error on Yahoo site (and as a result on Data Element 971)?
(3) If Levered and FCF are not the same thing, where best to get Free Cash Flow information?
Thanks
Armando
(1) Is this the same as what other sites simply call Free Cash Flow?
(2) How come sometimes (eg, SLB, JNJ) Yahoo's Key Statistics screen display N/A for Levered Free Cash Flow whereas companies (those two certainly) generate free cash flow? Does that mean Levered is not the same as FCF? Or Is this an error on Yahoo site (and as a result on Data Element 971)?
(3) If Levered and FCF are not the same thing, where best to get Free Cash Flow information?
Thanks
Armando
Fri Jul 25, 2014 8:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Someone else will need to chime in, since I have no idea...
On Fri, Jul 25, 2014 at 8:16 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Data Element 971 is Yahoo's Levered Free Cash Flow. Questions:
>
> (1) Is this the same as what other sites simply call Free Cash Flow?
>
> (2) How come sometimes (eg, SLB, JNJ) Yahoo's Key Statistics screen
> display N/A for Levered Free Cash Flow whereas companies (those two
> certainly) generate free cash flow? Does that mean Levered is not the same
> as FCF? Or Is this an error on Yahoo site (and as a result on Data Element
> 971)?
>
> (3) If Levered and FCF are not the same thing, where best to get Free Cash
> Flow information?
>
On Fri, Jul 25, 2014 at 8:16 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Data Element 971 is Yahoo's Levered Free Cash Flow. Questions:
>
> (1) Is this the same as what other sites simply call Free Cash Flow?
>
> (2) How come sometimes (eg, SLB, JNJ) Yahoo's Key Statistics screen
> display N/A for Levered Free Cash Flow whereas companies (those two
> certainly) generate free cash flow? Does that mean Levered is not the same
> as FCF? Or Is this an error on Yahoo site (and as a result on Data Element
> 971)?
>
> (3) If Levered and FCF are not the same thing, where best to get Free Cash
> Flow information?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar