10 Messages
Digest #3083
Messages
Mon Jun 2, 2014 7:52 am (PDT) . Posted by:
rr76012
Randy, thanks, you are awesome, you always are helpful.
I bought the new computer basically because all my friends, told me I should. I hope I like it, the learning curve has me a little bit put off, but I will work through it.
I like windows xp and ms office 2007, I hope I like windows 8.1 and ms office 2010?
Randy, I just wanted to check with you first, before I put your smf addin on.
What you do is so over my head, I am amazed at what you can do. It is so technical.
I bought an external drive over the weekend, and I plan to move the old files to the new computer sometime this week...ouch!
Thanks,
rr76012
I bought the new computer basically because all my friends, told me I should. I hope I like it, the learning curve has me a little bit put off, but I will work through it.
I like windows xp and ms office 2007, I hope I like windows 8.1 and ms office 2010?
Randy, I just wanted to check with you first, before I put your smf addin on.
What you do is so over my head, I am amazed at what you can do. It is so technical.
I bought an external drive over the weekend, and I plan to move the old files to the new computer sometime this week...ouch!
Thanks,
rr76012
Mon Jun 2, 2014 7:53 am (PDT) . Posted by:
rr76012
6/2/2014
Randy, I am so glad you put the link, that is so very helpful.
rr76012
Randy, I am so glad you put the link, that is so very helpful.
rr76012
Mon Jun 2, 2014 11:51 am (PDT) . Posted by:
"अनन्त:" ritchemie
Hello Randy,
I had old file where I have this link
RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&";/?story=financials&timewindow=2&opt=YI",5,"Income
Statement (Non-Cumulative)",$B7
is this still a working link? or has it been updated. I would appreciate
your help
Aku
I had old file where I have this link
RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&"
Statement (Non-Cumulative)
is this still a working link? or has it been updated. I would appreciate
your help
Aku
Mon Jun 2, 2014 12:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I try a version of your URL:
http://www.smartmoney.com/quote/MMM/?story=financials&timewindow=2&opt=YI
...I get redirected to::
http://www.marketwatch.com/investing/stock/MMM/financials
I don't know if that page has what you need or not. It may have a
completely different structure and line items may be defined differently.
On Mon, Jun 2, 2014 at 11:50 AM, अनन्त: 1998chemie@... wrote:
>
> I had old file where I have this link
> RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&";/?story=financials&timewindow=2&opt=YI",5,"Income
> Statement (Non-Cumulative)",$B7
>
> is this still a working link? or has it been updated. I would appreciate
> your help
>
>
http://www.smartmoney.com/quote/MMM/?story=financials&timewindow=2&opt=YI
...I get redirected to::
http://www.marketwatch.com/investing/stock/MMM/financials
I don't know if that page has what you need or not. It may have a
completely different structure and line items may be defined differently.
On Mon, Jun 2, 2014 at 11:50 AM, अनन्त: 1998chemie@... wrote:
>
> I had old file where I have this link
> RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&"
> Statement (Non-Cumulative)
>
> is this still a working link? or has it been updated. I would appreciate
> your help
>
>
Mon Jun 2, 2014 12:29 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Yes that's where the page is getting redirected. Actually what I am trying
to do is update the document so that I get the 10 year financial data for
companies.
I thought just updating the link would work but seems like its bit more
than that.
I would appreciate if you can tell me better ways to get 10 years worth of
financials.
regards
Aku
On Mon, Jun 2, 2014 at 3:20 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> When I try a version of your URL:
>
> http://www.smartmoney.com/quote/MMM/?story=financials&timewindow=2&opt=YI
>
> ...I get redirected to::
>
> http://www.marketwatch.com/investing/stock/MMM/financials
>
> I don't know if that page has what you need or not. It may have a
> completely different structure and line items may be defined differently.
>
>
> On Mon, Jun 2, 2014 at 11:50 AM, अनन्त: 1998chemie@... wrote:
>
>>
>> I had old file where I have this link
>> RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&";/?story=financials&timewindow=2&opt=YI",5,"Income
>> Statement (Non-Cumulative)",$B7
>>
>> is this still a working link? or has it been updated. I would appreciate
>> your help
>>
>>
>
>
>
to do is update the document so that I get the 10 year financial data for
companies.
I thought just updating the link would work but seems like its bit more
than that.
I would appreciate if you can tell me better ways to get 10 years worth of
financials.
regards
Aku
On Mon, Jun 2, 2014 at 3:20 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> When I try a version of your URL:
>
> http://www.smartmoney.com/quote/MMM/?story=financials&timewindow=2&opt=YI
>
> ...I get redirected to::
>
> http://www.marketwatch.com/investing/stock/MMM/financials
>
> I don't know if that page has what you need or not. It may have a
> completely different structure and line items may be defined differently.
>
>
> On Mon, Jun 2, 2014 at 11:50 AM, अनन्त: 1998chemie@... wrote:
>
>>
>> I had old file where I have this link
>> RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker&"
>> Statement (Non-Cumulative)
>>
>> is this still a working link? or has it been updated. I would appreciate
>> your help
>>
>>
>
>
>
Mon Jun 2, 2014 12:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the templates for GuruFocus or AdvFN. Although AdvFN data
hasn't been great lately.
MorningStar also has 10 years of data for members:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
See the "Tips and FAQs" page for more details on Morningstar offerings.
On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@... wrote:
>
> Yes that's where the page is getting redirected. Actually what I am trying
> to do is update the document so that I get the 10 year financial data for
> companies.
> I thought just updating the link would work but seems like its bit more
> than that.
> I would appreciate if you can tell me better ways to get 10 years worth of
> financials.
>
>
hasn't been great lately.
MorningStar also has 10 years of data for members:
=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
See the "Tips and FAQs" page for more details on Morningstar offerings.
On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@.
>
> Yes that's where the page is getting redirected. Actually what I am trying
> to do is update the document so that I get the 10 year financial data for
> companies.
> I thought just updating the link would work but seems like its bit more
> than that.
> I would appreciate if you can tell me better ways to get 10 years worth of
> financials.
>
>
Mon Jun 2, 2014 12:52 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Randy,
I do not have Morningstar subscription but I do get the data through
library for free
is there a way I can use that link?
On Mon, Jun 2, 2014 at 3:34 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Take a look at the templates for GuruFocus or AdvFN. Although AdvFN data
> hasn't been great lately.
>
> MorningStar also has 10 years of data for members:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>
> See the "Tips and FAQs" page for more details on Morningstar offerings.
>
>
> On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@... wrote:
>
>>
>> Yes that's where the page is getting redirected. Actually what I am
>> trying to do is update the document so that I get the 10 year financial
>> data for companies.
>> I thought just updating the link would work but seems like its bit more
>> than that.
>> I would appreciate if you can tell me better ways to get 10 years worth
>> of financials.
>>
>>
>
>
I do not have Morningstar subscription but I do get the data through
library for free
is there a way I can use that link?
On Mon, Jun 2, 2014 at 3:34 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Take a look at the templates for GuruFocus or AdvFN. Although AdvFN data
> hasn't been great lately.
>
> MorningStar also has 10 years of data for members:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>
> See the "Tips and FAQs" page for more details on Morningstar offerings.
>
>
> On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@.
>
>>
>> Yes that's where the page is getting redirected. Actually what I am
>> trying to do is update the document so that I get the 10 year financial
>> data for companies.
>> I thought just updating the link would work but seems like its bit more
>> than that.
>> I would appreciate if you can tell me better ways to get 10 years worth
>> of financials.
>>
>>
>
>
Mon Jun 2, 2014 1:11 pm (PDT) . Posted by:
"अनन्त:" ritchemie
Sorry to ask so many questions-
I tried this in excel
=smfGetCSVFile("http://financials.morningstar.com/
ajax/exportKR2CSV.html?t=GOOG")
This is the reply I got "Growth Profitability and Financial Ratios for
Google Inc Class C"
All in one cell, this could be because I did not have paid subscription. Do
I need to be paid member to get this data?
through my library membership I could download CSV files but for each
company I had to do 3 times. once for each data,BS, CF, IS
I would appreciate your help
On Mon, Jun 2, 2014 at 3:52 PM, अनन्त: <1998chemie@gmail.com> wrote:
> Randy,
> I do not have Morningstar subscription but I do get the data through
> library for free
> is there a way I can use that link?
>
>
>
> On Mon, Jun 2, 2014 at 3:34 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Take a look at the templates for GuruFocus or AdvFN. Although AdvFN data
>> hasn't been great lately.
>>
>> MorningStar also has 10 years of data for members:
>>
>> =smfGetCSVFile("
>> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>>
>> See the "Tips and FAQs" page for more details on Morningstar offerings.
>>
>>
>> On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@... wrote:
>>
>>>
>>> Yes that's where the page is getting redirected. Actually what I am
>>> trying to do is update the document so that I get the 10 year financial
>>> data for companies.
>>> I thought just updating the link would work but seems like its bit more
>>> than that.
>>> I would appreciate if you can tell me better ways to get 10 years worth
>>> of financials.
>>>
>>>
>>
>>
>
>
I tried this in excel
=smfGetCSVFile("http://financials.morningstar.com/
ajax/exportKR2CSV.html?t=GOOG")
This is the reply I got "Growth Profitability and Financial Ratios for
Google Inc Class C"
All in one cell, this could be because I did not have paid subscription. Do
I need to be paid member to get this data?
through my library membership I could download CSV files but for each
company I had to do 3 times. once for each data,BS, CF, IS
I would appreciate your help
On Mon, Jun 2, 2014 at 3:52 PM, अनन्त: <1998chemie@gmail.com> wrote:
> Randy,
> I do not have Morningstar subscription but I do get the data through
> library for free
> is there a way I can use that link?
>
>
>
> On Mon, Jun 2, 2014 at 3:34 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Take a look at the templates for GuruFocus or AdvFN. Although AdvFN data
>> hasn't been great lately.
>>
>> MorningStar also has 10 years of data for members:
>>
>> =smfGetCSVFile("
>> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=MMM")
>>
>> See the "Tips and FAQs" page for more details on Morningstar offerings.
>>
>>
>> On Mon, Jun 2, 2014 at 12:29 PM, अनन्त: 1998chemie@.
>>
>>>
>>> Yes that's where the page is getting redirected. Actually what I am
>>> trying to do is update the document so that I get the 10 year financial
>>> data for companies.
>>> I thought just updating the link would work but seems like its bit more
>>> than that.
>>> I would appreciate if you can tell me better ways to get 10 years worth
>>> of financials.
>>>
>>>
>>
>>
>
>
Mon Jun 2, 2014 4:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not that I'm aware of...
On Mon, Jun 2, 2014 at 12:52 PM, अनन्त: 1998chemie@...wrote:
> I do not have Morningstar subscription but I do get the data through
> library for free
> is there a way I can use that link?
>
On Mon, Jun 2, 2014 at 12:52 PM, अनन्त: 1998chemie@.
> I do not have Morningstar subscription but I do get the data through
> library for free
> is there a way I can use that link?
>
Mon Jun 2, 2014 5:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to array-enter the formula over a range...
On Mon, Jun 2, 2014 at 1:10 PM, अनन्त: 1998chemie...wrote:
>
> I tried this in excel
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/exportKR2CSV.html?t=GOOG";)
> This is the reply I got "Growth Profitability and Financial Ratios for
> Google Inc Class C"
>
> All in one cell, this could be because I did not have paid subscription.
> Do I need to be paid member to get this data?
> through my library membership I could download CSV files but for each
> company I had to do 3 times. once for each data,BS, CF, IS
>
> I would appreciate your help
>
On Mon, Jun 2, 2014 at 1:10 PM, अनन्त: 1998chemie...wrote:
>
> I tried this in excel
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/exportKR2CSV.
> This is the reply I got "Growth Profitability and Financial Ratios for
> Google Inc Class C"
>
> All in one cell, this could be because I did not have paid subscription.
> Do I need to be paid member to get this data?
> through my library membership I could download CSV files but for each
> company I had to do 3 times. once for each data,BS, CF, IS
>
> I would appreciate your help
>
Tidak ada komentar:
Posting Komentar