Pages:
Author

Topic: RentalStarter - A Midwest Real Estate Investment Company - page 13. (Read 120488 times)

hero member
Activity: 854
Merit: 500
^Works 4 me Undecided



Yup, if I remove the dtstart and dtend it gives me all the trades ever made. It seems they changed a feature in their API and never updated the documentation. I will start making charts now.
sr. member
Activity: 378
Merit: 254
hero member
Activity: 854
Merit: 500
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.

More annoying/difficult than a simple xls pull from Havelock alone, but you can pull trade data using the API from Havelock and the Coindesk index for this.

sorry if this is going a bit off-topic, is the api from havelock documented somewhere?

I didn't know there was one because there were no options to download a csv on the website. I found they have an API available here: https://www.havelockinvestments.com/apidoc.php

This quite a work of an API only allowed 300 requests per 600 seconds and doesn't have a price@date function. I could scrub the trade history once per hour as far back as it goes.

In addition to that, it doesn't work:

Code:
$ curl --data "cmd=trades&symbol=RENT&dtstart='2014-07-01 23:00:00'&dtend='2014-07-20 23:00:00'" https://www.havelockinvestments.com/api/index.php
{"status":"ok","trades":[],"apirate":"1"}
sr. member
Activity: 378
Merit: 254
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.

Here's the chart, using Photoshop and 15 minutes of my time.



Here's how it was made:

1.  Grab Havelock chart (first frame)
2.  Superimpose BTC price chart for the same time period, (thanks Bitcoincharts Smiley) so that dates line up (second frame)
3.  Clean up useless stuff like volume, adjust v-scale, align vertically (third frame)
4.  Invert the BTC price chart, keeping the origin at IPO price (fourth frame)
5.  Orange bands are initial and second public offering--to be ignored since RENT price is locked (fifth and longest frame)*

If RENT price reflected BTC price, the two lines (inverted BTC and RENT) would be identical.


*The problem with the chart (other than Havelock's chart making it look as if the POs ended ~ a week too soon) is, once the irrelevant data is discounted (2 months' worth), there's not enough here to to make a call.  Other than RENT price decoupling from btc price in June Sad

member
Activity: 109
Merit: 10
Bleating sense into the world
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.

More annoying/difficult than a simple xls pull from Havelock alone, but you can pull trade data using the API from Havelock and the Coindesk index for this.

sorry if this is going a bit off-topic, is the api from havelock documented somewhere?
hero member
Activity: 938
Merit: 502
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.

More annoying/difficult than a simple xls pull from Havelock alone, but you can pull trade data using the API from Havelock and the Coindesk index for this.
legendary
Activity: 1036
Merit: 1000
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.

I wish you goodluck with that, not sure havelock can afford the customer service personal to get that information to you after last months performance, 165BTC expenses  Roll Eyes Roll Eyes Roll Eyes Roll Eyes

In all seriousness, that would be a pretty good chart
hero member
Activity: 854
Merit: 500
If Havelock can make a csv file with "date,RENT_price" available I can make a neat chart to analyse USD/BTC vs BTC/RENT.
full member
Activity: 138
Merit: 100
Or it could have been caused by me buying more shares today.  Which is what happened.

With sideshows now a thing of the past, Bitcoin Securities is the last bastion of freakish human anomalies and macabre curiosities.  And while one had to pay for the privileged of viewing the sideshow attractions, here the attractions pay to be on display.

My sincere thanks, tempestb.  Whatever you have lost today was well worth it.
At least for me.

*Protip: buy through 285/285 @0.00539, it would totally take off!  Can't prime a pump by buying one share ata time.   
full member
Activity: 138
Merit: 100
Or it could have been caused by me buying more shares today.  Which is what happened.

That is how it happened, I was trying to explain why it happened.

Nah.  flip the bitcoin price upside-down (invert), line up the time, and you'll see that correlation between RENT price and the price of Bitcoin is statistically insignificant.  tempestb didn't buy because he thinks Bitcoin price is going to crash, he bought ...I guess because he likes to lose money.
You don't think bitcoin is tanking, do you, tempestb?
member
Activity: 109
Merit: 10
Bleating sense into the world
Or it could have been caused by me buying more shares today.  Which is what happened.

That is how it happened, I was trying to explain why it happened.
hero member
Activity: 729
Merit: 500
Or it could have been caused by me buying more shares today.  Which is what happened.
member
Activity: 109
Merit: 10
Bleating sense into the world
^Interesting theory, but assumes rational, informed investors, no price manipulation, and reasonable liquidity--which means it simply doesn't reflect reality.
For instance, the price today has jumped from .0042 to 0.0054 (BRAVO!).  While bitcoin has went up from $610 to 625.  
According to your theory, RENT price should have gone down Undecided

The last time bitcoin went up (when it jumped over 600), the price of RENT went down more than would correlate with the btc rise, and the RENT price is slowly rising to regain equilibrium with the bitcoin price. A bitcoin price move up or down a couple percent is just normal trading volatility and does not affect the price of RENT like a bump of 10 or 20%.

The price of RENT dropped overly much because investors expected the price of bitcoin to continue rising, as the bitcoin price remains stable the price of RENT will rise to correlate with the reported NAV per share.
full member
Activity: 138
Merit: 100
^Interesting theory, but assumes rational, informed investors, no price manipulation, and reasonable liquidity--which means it simply doesn't reflect reality.
For instance, the price today has jumped from .0042 to 0.0054 (BRAVO!).  While bitcoin has went up from $610 to 625.  
According to your theory, RENT price should have gone down Undecided
member
Activity: 109
Merit: 10
Bleating sense into the world
@ 0.0040 wall builder(s):  I, for one, am 100% convinced Cheesy

It looks like the price of bitcoins has stabilized for the time being. If the price starts jumping again, then expect the price of RENT to take a further dive.
sr. member
Activity: 378
Merit: 254
@ 0.0040 wall builder(s):  I, for one, am 100% convinced Cheesy
sr. member
Activity: 378
Merit: 254
^Attaboy!  Now if just a few more faithful follow suit, this thing'll go to da moon!
*How much did you squander away this time?
legendary
Activity: 1036
Merit: 1000
^Then why ain't you *BUYING*, bro?  Free monyz!! Cheesy

I did  Roll Eyes
hero member
Activity: 938
Merit: 502
Atta boy, Captain.
sr. member
Activity: 406
Merit: 250
Here is the financial performance report of RS for July. This one is compiled slightly differently than past ones. It counts only the marketable price of the properties as-is, and does not utilize the post-rehab value. This means the total market value reflects the non-rehabbed state of Mulberry & Scioto #3.





* - Rent is always paid for the first month in full regardless of move-in date. The second month is then pro-rated to reflect the first month's move-in date based on a average price per day.
** - I discounted first month's rent by $100 due to the fact that there was a leaking sewage connection during move in. It caused a bunch of problems and I felt it was only right to knock $100 off first month's rent.
Pages:
Jump to: