5 Messages
Digest #3050
Messages
Thu Apr 24, 2014 9:17 am (PDT) . Posted by:
petekoch
It was I who originally uploaded the FWallStreet sheets. I'm invested mostly in CEFs and ETFs now, so I haven't used them in a while. I removed them from the file section because I can't guarantee that they work properly, but there's no reason you can't modify them.
I have two versions. The first uses Guru Focus data, but I have no idea whether it will work with Guru Focus today. I switched to Morningstar data, so my second sheet works fine, but you need to be a Morningstar subscriber to get a full 10 years of data. However, you could modify it to use 5 years of data. If you are interested, send me a private message with your email address and I'll get them to you.
BTW, Morningstar.Financials.Example.xlsx in the user section demonstrates the use of the GetCSVFile function, which is how I obtain data from Morningstar in the FWallStreet workbook.
I have two versions. The first uses Guru Focus data, but I have no idea whether it will work with Guru Focus today. I switched to Morningstar data, so my second sheet works fine, but you need to be a Morningstar subscriber to get a full 10 years of data. However, you could modify it to use 5 years of data. If you are interested, send me a private message with your email address and I'll get them to you.
BTW, Morningstar.
Thu Apr 24, 2014 12:52 pm (PDT) . Posted by:
"linhle1784" linhle1784
Hello,
Any chance I can take a look at your fwallstreet sheets? Thank you.
Le
-------- Original message --------
From: petekoch@yahoo.com
Date:04/24/2014 10:17 AM (GMT-07:00)
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: FWallStreet spreadsheets, anyone could reupload pls?
It was I who originally uploaded the FWallStreet sheets. I'm invested mostly in CEFs and ETFs now, so I haven't used them in a while. I removed them from the file section because I can't guarantee that they work properly, but there's no reason you can't modify them.
I have two versions. The first uses Guru Focus data, but I have no idea whether it will work with Guru Focus today. I switched to Morningstar data, so my second sheet works fine, but you need to be a Morningstar subscriber to get a full 10 years of data. However, you could modify it to use 5 years of data. If you are interested, send me a private message with your email address and I'll get them to you.
BTW, Morningstar.Financials.Example.xlsx in the user section demonstrates the use of the GetCSVFile function, which is how I obtain data from Morningstar in the FWallStreet workbook.
Any chance I can take a look at your fwallstreet sheets? Thank you.
Le
-------- Original message --------
From: petekoch@yahoo.com
Date:04/24/2014 10:17 AM (GMT-07:00)
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: FWallStreet spreadsheets, anyone could reupload pls?
It was I who originally uploaded the FWallStreet sheets. I'm invested mostly in CEFs and ETFs now, so I haven't used them in a while. I removed them from the file section because I can't guarantee that they work properly, but there's no reason you can't modify them.
I have two versions. The first uses Guru Focus data, but I have no idea whether it will work with Guru Focus today. I switched to Morningstar data, so my second sheet works fine, but you need to be a Morningstar subscriber to get a full 10 years of data. However, you could modify it to use 5 years of data. If you are interested, send me a private message with your email address and I'll get them to you.
BTW, Morningstar.
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 : /Uploads by forum members/FWallStreet.xlsm
Uploaded by : petekoch <petekoch@yahoo.com>
Description : DCF Valuation -- a Morningstar subscription and login is required
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/FWallStreet.xlsm
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
petekoch <petekoch@yahoo.com>
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 : /Uploads by forum members/FWallStreet.xlsm
Uploaded by : petekoch <petekoch@yahoo.com>
Description : DCF Valuation -- a Morningstar subscription and login is required
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/FWallStreet.xlsm
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
petekoch <petekoch@yahoo.com>
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 : /Uploads by forum members/FWallStreet_GF.xlsm
Uploaded by : petekoch <petekoch@yahoo.com>
Description : DCF Valuation using Guru Focus and Morningstar (no subscription required)
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/FWallStreet_GF.xlsm
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
petekoch <petekoch@yahoo.com>
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 : /Uploads by forum members/FWallStreet_GF.xlsm
Uploaded by : petekoch <petekoch@yahoo.com>
Description : DCF Valuation using Guru Focus and Morningstar (no subscription required)
You can access this file at the URL:
https://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/FWallStreet_GF.xlsm
To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398
Regards,
petekoch <petekoch@yahoo.com>
Thu Apr 24, 2014 2:27 pm (PDT) . Posted by:
petekoch
I received several requests for the sheet(s), so I have uploaded them to the user section.
FWallStreet.xlsm requires a subscription and login to Morningstar to get a full 10 years of data.
FWallStreet_GF.xlsm uses both Guru Focus data and Morningstar, but no subscription should be necessary. The Guru Focus tab gets errors and, since I no longer use the sheet, I am not inclined to correct them. I'll leave that up to you.
The command button 'Run List' will retrieve data for all tickers in Column 'A' of the 'List' sheet. I will echo Randy and ask that you don't abuse it and retrieve free data for long lists of stocks.
The weather's getting nice so I'm not spending much time in front of my PC, but I'll be happy to answer questions about the sheets, or at least try.
Everyone will undoubtedly encounter the problem where none of the cell values are resolved because I saved the sheets in a non-standard folder. There are several messages on this group with a workaround for that issue.
Please use petekoch@yahoo.com for queries.
Good luck...
FWallStreet.xlsm requires a subscription and login to Morningstar to get a full 10 years of data.
FWallStreet_GF.xlsm uses both Guru Focus data and Morningstar, but no subscription should be necessary. The Guru Focus tab gets errors and, since I no longer use the sheet, I am not inclined to correct them. I'll leave that up to you.
The command button 'Run List' will retrieve data for all tickers in Column 'A' of the 'List' sheet. I will echo Randy and ask that you don't abuse it and retrieve free data for long lists of stocks.
The weather's getting nice so I'm not spending much time in front of my PC, but I'll be happy to answer questions about the sheets, or at least try.
Everyone will undoubtedly encounter the problem where none of the cell values are resolved because I saved the sheets in a non-standard folder. There are several messages on this group with a workaround for that issue.
Please use petekoch@yahoo.com for queries.
Good luck...
Tidak ada komentar:
Posting Komentar