Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Question for SKYSHIP

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Question for SKYSHIP

#441608

Postby MDW1954 » September 12th, 2021, 12:46 pm

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

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: Question for SKYSHIP

#441931

Postby MDW1954 » September 13th, 2021, 4:27 pm

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

WifeinFrance
Posts: 3
Joined: September 18th, 2021, 2:02 pm

Re: Question for SKYSHIP

#443308

Postby WifeinFrance » September 18th, 2021, 2:17 pm

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

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: Question for SKYSHIP

#443407

Postby MDW1954 » September 18th, 2021, 9:22 pm

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

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: Question for SKYSHIP

#443449

Postby MDW1954 » September 18th, 2021, 11:21 pm

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

richfool
Lemon Quarter
Posts: 3492
Joined: November 19th, 2016, 2:02 pm
Has thanked: 1195 times
Been thanked: 1280 times

Re: Question for SKYSHIP

#443519

Postby richfool » September 19th, 2021, 11:01 am

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

WifeinFrance
Posts: 3
Joined: September 18th, 2021, 2:02 pm

Re: Question for SKYSHIP

#444333

Postby WifeinFrance » September 22nd, 2021, 8:49 am

Richfool - "Lost in France" - excellent - problem is, now can't get it out of my head!

WifeinFrance
Posts: 3
Joined: September 18th, 2021, 2:02 pm

Re: Question for SKYSHIP

#444334

Postby WifeinFrance » September 22nd, 2021, 8:50 am

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...

SKYSHIP
Lemon Slice
Posts: 476
Joined: November 6th, 2016, 12:24 pm
Has thanked: 2 times
Been thanked: 553 times

Re: Question for SKYSHIP

#444617

Postby SKYSHIP » September 23rd, 2021, 8:09 am

1234....1234....testing....testing....

SKYSHIP
Lemon Slice
Posts: 476
Joined: November 6th, 2016, 12:24 pm
Has thanked: 2 times
Been thanked: 553 times

Re: Question for SKYSHIP

#444620

Postby SKYSHIP » September 23rd, 2021, 8:15 am

Almost there...WORKS - have my own profile restored. Thnx Stooz.

MDW1954
Lemon Quarter
Posts: 2358
Joined: November 4th, 2016, 8:46 pm
Has thanked: 526 times
Been thanked: 1011 times

Re: Question for SKYSHIP

#444711

Postby MDW1954 » September 23rd, 2021, 1:19 pm

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 10 guests