Jump to content
DOSBODS
  • Welcome to DOSBODS

     

    DOSBODS is free of any advertising.

    Ads are annoying, and - increasingly - advertising companies limit free speech online. DOSBODS Forums are completely free to use. Please create a free account to be able to access all the features of the DOSBODS community. It only takes 20 seconds!

     

IGNORED

Fantasy investor 2018


Inoperational Bumblebee

Recommended Posts

Inoperational Bumblebee
Posted

Following discussion in the deflation thread, I thought I'd set this up ASAP to stop further derailment over there. This competition finishes at the stroke of midnight when it turns 2019 in the UK.
Hat tip to @stokiescum for suggesting it initally.

I'll also post an 'ending 2019' one once we've got a basic set of rules agreed.

For this thread, I propose you have £100k divided between whatever investments you choose, however you like. Anything goes, as long as there are publicly available verifiable figures to back up your valuation i.e. no classic cars or similar. Even lottery tickets are acceptable, as long as you post the numbers you'll buy until the end of the year.

Thoughts on the suggested rules welcome, as are entries.

  • Replies 85
  • Created
  • Last Reply
Posted

with only 8 weeks left you might has well go all in on an aim oil or gas firm lol.sou springs to mind just for shits and giggles.but id probably be boreing and just split it between gaw,iqe,vod,bp not looked at or followed the markets for 6-7 years.

Inoperational Bumblebee
Posted
7 minutes ago, stokiescum said:

with only 8 weeks left you might has well go all in on an aim oil or gas firm lol.sou springs to mind just for shits and giggles.but id probably be boreing and just split it between gaw,iqe,vod,bp not looked at or followed the markets for 6-7 years.

True! Is that your entry?

Happy with the vague rules?

Posted

8 weeks is super short but I'm sticking with 100% Wesdome @4cad / 2.35gbp as mentioned in the original thread. Production update next week and resource update to follow should give it a nice bump.

Posted
9 hours ago, Inoperational Bumblebee said:

True! Is that your entry?

Happy with the vague rules?

Yea those 5 even split

Nicolas Turgeon
Posted

Thanks for setting up the separate thread Bumblebee. Its not Fantasy Football, its Fantasy FTSE!

I'm thinking it's dollar down and gold up over the next 2 months so my entries are:

  • 25% UDN - Invesco DB USD Bear ETF
  • 75% GDXJ - VanEck Junior Miners

Do you want these put in that google docs spreadsheet somewhere?

Posted

Are crypto currencies allowed? if so, I will go all-in on ETH.

Or specifically 629 ETH currently valued at £99,973.26

Posted
31 minutes ago, spunko said:

Are crypto currencies allowed? if so, I will go all-in on ETH.

Or specifically 629 ETH currently valued at £99,973.26

there is a crypto api addon, ive not used it but ill add the 'add-ons' if anyone can be arsed to read and use it, dunno how accurate it is.

Have a look in add ons on tool bar.

 

I added a crypto sheet for messing in, i installed 2 addons for crypto, one is googles the other a 3rd party. Ill have a play.

 

Ok, be better working in 1 unit really and then multiplying it all out, so wants fixing, but just for a quick doss;

https://docs.google.com/spreadsheets/d/1lggMOk7ZJd0TkFQamiN_jWgyhnJ3kLuJ2BhmjFmbVwY/edit#gid=1662780564

 

Spunko test            
  Start price
03/11/2018
£/unit Num of units Total(£) P/L(£)  
ETH/GBP 96,854.86 153.98 629 96,854.86 0.00  
Posted

well done , your already £21 up

 

soon you will be £57K down knowing crypto.

 

Spunko test              
  £/unit start price
03/11/2018
£/unit NAV now Num of units Start Value(£) Value Now(£) P/L(£) P/L %
ETH/GBP 153.9800 154.0144 629 96,853.42 96,875.07 21.65 0.0223%
Posted

Not sure what to do with USD/CAD ones, should we just go on %age terms? or make an attempt at currency conversion?

https://docs.google.com/spreadsheets/d/1lggMOk7ZJd0TkFQamiN_jWgyhnJ3kLuJ2BhmjFmbVwY/edit#gid=1662780564

 

                    11/3/2018
                     
UID Invested in P/unit start 03/11/2018 P/unit NAV now Num of units Start Value(£) Value Now(£) P/L(£) P/L % Total P/L(£) per UID  
spunko ETH/GBP 15398.00 15413.08 629 96,853.42 96,948.30 94.88 0.10% 94.88  
stokiescum lon:gaw 3230.00 3230.00 1 32.30 32.30 0.00 0.00%    
  lon:iqe 96.30 96.30 1 0.96 0.96 0.00 0.00%    
  lon:vod 150.52 150.52 1 1.51 1.51 0.00 0.00%    
  lon:bp 533.30 533.30 1 5.33 5.33 0.00 0.00% 0.00  
Posted

i reckon we get shot of units and total values and just go with a notional 1 unit (ie 1 share) and just watch %ages, so total %age could be just a summary of %ages.

Anyhoo, best get back to work... already a bit behind.

Posted

I’m going all in on Shanta Gold (SHG) at 4.32 pence.

Posted

aye good shag;

 

                    11/3/2018
                     
UID Invested in P/unit start 03/11/2018 P/unit NAV now Num of units Start Value(£) Value Now(£) P/L(£) P/L % Total P/L(%) per UID Notes
spunko ETH/GBP 15398.00 15406.38 1 153.98 154.06 0.08 0.05% 0.05%  
stokiescum lon:gaw 3230.00 3230.00 1 32.30 32.30 0.00 0.00%    
  lon:iqe 96.30 96.30 1 0.96 0.96 0.00 0.00%    
  lon:vod 150.52 150.52 1 1.51 1.51 0.00 0.00%    
  lon:bp 533.30 533.30 1 5.33 5.33 0.00 0.00% 0.00%  
castlevania lon:shg 4.32 4.32 1 0.04 0.04 0.00 0.00% 0.00%  
kibuc (CAD cents) tse:wdo 404.00 404.00 1 4.04 4.04 0.00 0.00% 0.00% In cad / ca cents
nicolas turgeon nysearca:udn 2118.00 2118.00 1 21.18 21.18 0.00 0.00%   In usd / us cents
  nysearca:gdxj 2806.00 2806.00 1 28.06 28.06 0.00 0.00% 0.00% In usd / us cents

 

https://docs.google.com/spreadsheets/d/1lggMOk7ZJd0TkFQamiN_jWgyhnJ3kLuJ2BhmjFmbVwY/edit#gid=1662780564

Posted

or no grids;

                    11/3/2018
                     
UID Invested in P/unit start 03/11/2018 P/unit NAV now Num of units Start Value(£) Value Now(£) P/L(£) P/L % Total P/L(%) per UID Notes
spunko ETH/GBP 15398.00 15406.38 1 153.98 154.06 0.08 0.05% 0.05%  
stokiescum lon:gaw 3230.00 3230.00 1 32.30 32.30 0.00 0.00%    
  lon:iqe 96.30 96.30 1 0.96 0.96 0.00 0.00%    
  lon:vod 150.52 150.52 1 1.51 1.51 0.00 0.00%    
  lon:bp 533.30 533.30 1 5.33 5.33 0.00 0.00% 0.00%  
castlevania lon:shg 4.32 4.32 1 0.04 0.04 0.00 0.00% 0.00%  
kibuc (CAD cents) tse:wdo 404.00 404.00 1 4.04 4.04 0.00 0.00% 0.00% In cad / ca cents
nicolas turgeon nysearca:udn 2118.00 2118.00 1 21.18 21.18 0.00 0.00%   In usd / us cents
  nysearca:gdxj 2806.00 2806.00 1 28.06 28.06 0.00 0.00% 0.00% In usd / us cents
Posted

I'll go 50% AUY and 50% bitcoin - even though they will probably go nowhere by end of year :D Can someone add it for me?

Posted
9 minutes ago, Sound Money said:

I'll go 50% AUY and 50% bitcoin - even though they will probably go nowhere by end of year :D Can someone add it for me?

add it yourself, sheets open to all and sundry.

You can copy spunkos line and change the lookup to 'BTC/GBP'

 

(i tried /GBX to keep them all at pence but couldnt pull it in pence, so i took GBP(pound) and divides by 100 to make Pence).

auy is nyse:auy, so will come back in usd, so need to get to cents.

We could take all the unit/price on 3/11/2018 and price now columns out and just use the pulled prices since the unit is notionally always 1. Ah, ill get round to it tomorrow, unless someone else wants to do it.

 

Posted
1 hour ago, Sound Money said:

I'll go 50% AUY and 50% bitcoin - even though they will probably go nowhere by end of year :D Can someone add it for me?

sok, i did it for you, made the other changes as well and added some green/red colouring, also marooned up the winner, looks like spunko is still ahead, being crypto i expect them to be heavily negative by tuesday then up 80% by weds only to tank 400% by thursday. etc.

Actually i reckon after the schnitzel last year of crapto, its probably pretty stable now.

Posted
3 hours ago, leonardratso said:

add it yourself, sheets open to all and sundry.

You can copy spunkos line and change the lookup to 'BTC/GBP'

 

(i tried /GBX to keep them all at pence but couldnt pull it in pence, so i took GBP(pound) and divides by 100 to make Pence).

auy is nyse:auy, so will come back in usd, so need to get to cents.

We could take all the unit/price on 3/11/2018 and price now columns out and just use the pulled prices since the unit is notionally always 1. Ah, ill get round to it tomorrow, unless someone else wants to do it.

 

sorry, multiply, durr!

Posted
On 03/11/2018 at 10:12, Democorruptcy said:

I'll have all my 100 large on Man City to beat Southampton on Sunday. I'll take the 1-8 currently on offer.

I'll have 1k on Southampton to beat Man City at 30-1.

49.5k on INFA at 0.51 GBX

49.5k on TGZ at 3.53 CAD

Posted
1 hour ago, Democorruptcy said:

I was going to put mine on Enable last night but bottled it. Trying to play safe usually ends in tears so you could be right.

Kindly kick yourself in the nuts! I am trying to...

Posted
11 minutes ago, Democorruptcy said:

Man City 6 Southampton 1

Running total now £112,500

Well done, Demo Sir - 12.5% return over 90 minutes, even after 2 months, could be hard to top. I am hoping that my real money bets (I would never wager on Saints beating Man City) come good over the next 8 weeks...

This virtual investment malarkey is good fun, but on a serious note, it does demonstrate how we are all gambling, to a greater or lesser extent.

Good luck all.

Posted

https://docs.google.com/spreadsheets/d/1lggMOk7ZJd0TkFQamiN_jWgyhnJ3kLuJ2BhmjFmbVwY/edit#gid=1662780564

FANTASY INVESTOR 2018 DOSBODS
            04/11/2018
               
UID Invested in [p|c]/unit NAV @03/11/2018 [p|c]/unit NAV now Profit/Loss
[p|c]
Profit/Loss
Percent(%)
Total P/L
(%) per UID
Notes
spunko ETH/GBP 15398.00 16003.94 605.94 3.94% 3.94% gb pence
stokiescum lon:gaw 3230.00 3230.00 0.00 0.00%   gb pence
  lon:iqe 96.30 96.30 0.00 0.00%   gb pence
  lon:vod 150.52 150.52 0.00 0.00%   gb pence
  lon:bp 533.30 533.30 0.00 0.00% 0.00% gb pence
castlevania lon:shg 4.32 4.32 0.00 0.00% 0.00% gb pence
kibuc tse:wdo 404.00 404.00 0.00 0.00% 0.00% ca cents
nicolas turgeon nysearca:udn 2118.00 2118.00 0.00 0.00%   us cents
  nysearca:gdxj 2806.00 2806.00 0.00 0.00% 0.00% us cents
sound money BTC/GBP 489806.17 485789.96 -4,016.21 -0.82%   gb pence
  nyse:auy 236.00 236.00 0.00 0.00% -0.82% us cents
ponty mython lon:infa 0.51 0.51 0.00 0.00%   gb pence
  tse:tgz 353.00 353.00 0.00 0.00% 0.00% ca cents
doineedone XRP/GBP 35.74 35.86 0.12 0.34%   gb pence
  spot gold 1oz 123560.00 123560.00 0.00 0.00% 0.34% us cents
sancho panza lon:cna 145.10 145.10 0.00 0.00%   gb pence
  lon:vod 150.52 150.52 0.00 0.00% 0.00% gb pence
Posted

wont update the shares automatically until markets open, also noticed crypto wasnt updating very well, so added a pair of dummy fields to give gbp/usd & gbp/cad, (suppose i could use them to bring everything to gb pence, but its late so ill leave it until tomorrow) to force sheet changes more regularly and force crypto updates by dummying them into the arguments of the api call, anyways spunko is still ahead with eth. Should get better figures tomorrow after 8am and after 1.30pm when the yanks start bullshitting.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...