Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
Question for SKYSHIP
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Question for SKYSHIP
SKYSHIP,
I have some limited skills in the statistical language R, and also in spreadsheets.
You have mentioned that you track a number of REITs on a spreadsheet. I am toying with the idea of automatically producing such a spreadsheet, and I'm curious about which variables you capture and track on that spreadsheet, as that will tend to dictate the direction and starting point for such a project.
Any information that you can share would be welcome, and gratefully received.
My intention would be to make the resulting spreadsheet freely available to anyone who wanted it.
MDW1954
I have some limited skills in the statistical language R, and also in spreadsheets.
You have mentioned that you track a number of REITs on a spreadsheet. I am toying with the idea of automatically producing such a spreadsheet, and I'm curious about which variables you capture and track on that spreadsheet, as that will tend to dictate the direction and starting point for such a project.
Any information that you can share would be welcome, and gratefully received.
My intention would be to make the resulting spreadsheet freely available to anyone who wanted it.
MDW1954
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Re: Question for SKYSHIP
Actually, this request has been overtaken by events. I had a couple of hours spare, so I've built something already.
I used Google Sheets, because it has a few basic finance functions already, and supplemented it with data scraped from the AIC website (specifically, NAV and yield). Basically, you input a date, and the spreadsheet goes off and downloads data from Google Finance, and scrapes other data from the AIC website.
It's also easier for people to use than my other likely line of attack -- an R dataframe converted to Excel.
So... I'm now looking for a couple of folk to take a look at it, and play with it.
If you're willing, PM me with the Google email address linked to your Google account.
If people like it, I'll find some other way of making it available, perhaps by uploading it to the financial software site run by users kiloran and itsallaguess, which hosts some other TMF- and TLF- user-developed tools.
The spreadsheet currently covers every REIT listed on the AIC website, which is quite a few. So potentially, a fairly useful tool.
MDW1954
I used Google Sheets, because it has a few basic finance functions already, and supplemented it with data scraped from the AIC website (specifically, NAV and yield). Basically, you input a date, and the spreadsheet goes off and downloads data from Google Finance, and scrapes other data from the AIC website.
It's also easier for people to use than my other likely line of attack -- an R dataframe converted to Excel.
So... I'm now looking for a couple of folk to take a look at it, and play with it.
If you're willing, PM me with the Google email address linked to your Google account.
If people like it, I'll find some other way of making it available, perhaps by uploading it to the financial software site run by users kiloran and itsallaguess, which hosts some other TMF- and TLF- user-developed tools.
The spreadsheet currently covers every REIT listed on the AIC website, which is quite a few. So potentially, a fairly useful tool.
MDW1954
-
- Posts: 3
- Joined: September 18th, 2021, 2:02 pm
Re: Question for SKYSHIP
Sorry MDW.....SKYSHIP here
I've been locked out for days with no way to communicate with the site operators; so had to re-register under my wife's details.
Would like to restore my own details......so hopefully Administrators will see this & assist.
In the meantime, to answer your earlier, my Spreadsheet records:
EPIC, Sp, NAV, Discount, Dividend, Yield, Debt Cost, LTV%, WAULT, then portfolio sector mix: Off.; Ind.; W/hse; Ret.: Ret.W/hse; Spec/Alt.
The Discounts & Yields are colour coded in range brackets.
Hope that helps...
SKYSHIP
I've been locked out for days with no way to communicate with the site operators; so had to re-register under my wife's details.
Would like to restore my own details......so hopefully Administrators will see this & assist.
In the meantime, to answer your earlier, my Spreadsheet records:
EPIC, Sp, NAV, Discount, Dividend, Yield, Debt Cost, LTV%, WAULT, then portfolio sector mix: Off.; Ind.; W/hse; Ret.: Ret.W/hse; Spec/Alt.
The Discounts & Yields are colour coded in range brackets.
Hope that helps...
SKYSHIP
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Re: Question for SKYSHIP
I'll sort that out.
If you'd like to share a Google account email address, I can show you the spreadsheet as it stands, and we can maybe communicate by PM about data sources for the (relatively few) things that your spreadsheet includes, that my one doesn't.
MDW1954
If you'd like to share a Google account email address, I can show you the spreadsheet as it stands, and we can maybe communicate by PM about data sources for the (relatively few) things that your spreadsheet includes, that my one doesn't.
MDW1954
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Re: Question for SKYSHIP
SKYSHIP,
You should be in receipt of a message from admin Stooz, although I don't know which account he's sent it to.
Please report back re: progress, etc.
MDW1954
You should be in receipt of a message from admin Stooz, although I don't know which account he's sent it to.
Please report back re: progress, etc.
MDW1954
-
- Lemon Quarter
- Posts: 3529
- Joined: November 19th, 2016, 2:02 pm
- Has thanked: 1208 times
- Been thanked: 1293 times
Re: Question for SKYSHIP
Hope to hear from you soon Skyship. In the meantime, keep your chin up, and here's a tune from Bonnie Tyler to help tide you over:
https://youtu.be/-kck91JcNmk
https://youtu.be/-kck91JcNmk
-
- Posts: 3
- Joined: September 18th, 2021, 2:02 pm
Re: Question for SKYSHIP
Richfool - "Lost in France" - excellent - problem is, now can't get it out of my head!
-
- Posts: 3
- Joined: September 18th, 2021, 2:02 pm
Re: Question for SKYSHIP
Still no message from Stooz. If he sees this, please message my original email address...
Ahh - found in my Junk box - so ok stooz, will now respond. Thnx...
Ahh - found in my Junk box - so ok stooz, will now respond. Thnx...
-
- Lemon Quarter
- Posts: 2365
- Joined: November 4th, 2016, 8:46 pm
- Has thanked: 527 times
- Been thanked: 1013 times
Re: Question for SKYSHIP
SKYSHIP wrote:Almost there...WORKS - have my own profile restored. Thnx Stooz.
Excellent! Let me know if you'd like to take a look at that spreadsheet.
I can email it to you very readily.
MDW1954
Return to “REITs & Property Companies”
Who is online
Users browsing this forum: No registered users and 27 guests