gesell: made a google web app script module whatever the hell they try to categorize it... that you can use in spreadsheets or other apps... that provides bitcoincharts (exchange data and weighted prices) and direct order book highs and lows from exchanges

gesell: https://script.google.com/macros/s/AKfycbxBLJGpX9Is2ZF5YfjR4XjqjEClHz_rogK-8wEup5N5LuuIGtMb/exec

gesell: waiting for it to get published to the apps gallery, then you can just install it into your spreadsheet and use the functions

gesell: if you want more markets let me know. i didnt put a donate link anywhere so, im not trying to mootch if someone has code they'd like to share

gesell: currently supports getting satoshidice counts, and mtgox, bitcoincentral and bitcoin24

gesell: in addition to ALL market data from bitcoincharts

gesell: see the link for examples

gesell: should not be hard to build an arbitrage table using googlefinance("currency:USDEUR") functions along with this stuff

gesell: if you just want the code, wait for it to show up in the gallery, or just tell me your gmail addr and ill share it

gesell: would be happy if others want to modify

gesell: okay the google code from before i think you can add to an existing spreadsheet even before it shows up in the gallery by going to "manage libraries" within your own spreadsheets script code and add the library using key "Mn6asBLgiBkIwY9lK-po6dDe4GsftYgT-"

gesell: aaaanyway

gesell: bleh, im not sure what is with google but... made a simple abitrage spreadsheet based on the Bitcoin Utilities google app I mentioned before. You can view it without a google account but apparently if you want to update the table you have to login with your google account. https://docs.google.com/spreadsheet/ccc?key=0AguYZ5-dWMgfdElhakdHQzhiQXp5emctdjZTNG9qaEE&usp=sharing#gid=0 It should then show you a BTC / Update menu. If it doesnt, go

gesell: the table doesnt take into account volume and the likes, yet

gesell: that either. not hard to add at some point

gesell: working on it

gesell: markedathome: ill add it

gesell: no i didnt

gesell: aaah. yeah i saw that

gesell: there are a couple of other abitrage tables that are public

gesell: somehow im getting close to the idea of google being the bot

gesell: grab a spreadsheet, give it your api keys and just keep your USD/EUR/GBP accounts up

gesell: would have to take into account volume and fees though

gesell: markedathome: i added btc-e to the abitrage google table

gesell: markedathome: updated google abitrate table to highlight those with possitive arbitrage percentiles. https://docs.google.com/spreadsheet/ccc?key=0AguYZ5-dWMgfdElhakdHQzhiQXp5emctdjZTNG9qaEE&usp=sharing

gesell: still, you wont see the BTC / Update menu to update the values uourself unless you have a google account

gesell: okay now the google abitrage table updates every minute

gesell: mjr_: use coinbr until you have more intense needs (api access or automated trading or just have enough btc invested you'd rather be closer to the exchange)

gesell: it just shows up on your account

gesell: you'll see the buy and sell go from coinbr onto mpex instantly

gesell: but yeah, basically coinbr owns your shares

gesell: or manages them for you

gesell: google abitrage table updated with mouse over information giving exact price

gesell: added bitstamp to the google abitrage table, as well as the google libraries "bitcoin utilities" I think im done for now https://docs.google.com/spreadsheet/ccc?key=0AguYZ5-dWMgfdElhakdHQzhiQXp5emctdjZTNG9qaEE&usp=sharing

gesell: updates once every minute

gesell: seems bitcoin-central kind of sucks

gesell: wow, welcome back to the real world bcEUR (exchange finally not giving as many arbitrage opps)

gesell: Gregoriano: dividends paid up?

gesell: update to mpex?

gesell: lovely

gesell: no

gesell: it is lovely

gesell: how does https://bitfinex.com/pages/stats determine its bear bull index?

gesell: has sdice thought about becoming a payment processor as well so that it can take USD emmediately? of course it comes with the headache of other exchanges but with sdice's current exposure in the "real world" it might bring lots of new players aand new bitcoin users

gesell: sorry

gesell: not usd

gesell: hmm

gesell: yeah guess that is out of the picture

gesell: rest of the world?

gesell: or maybe bitinstant or bitpay should have a sdice quick road

gesell: for the nonUS world

gesell: guess its all messy. but just looking at how to reduce the barrier from a gambler hearing about sdice and bitcoin, and then going off to figure out how to get started

gesell: how do online gamblers say, in the EU, deal with this now? getting funds in i mean

gesell: additional players

gesell: mircea_popescu: all true. but if you might contemplate how to make it easier for people that hear your pizza is great but dont come because the path seems complex, to make it less complex

gesell: if i had the exposure that sdice is getting i'd start to try to find ways measure the effect of bitcoin-user-bootstrap friction and process, and then reweigh the hassel of dealing with fiat depending on number of users. I mean consider the profit that MTGox makes and they have to deal with this hassel, and the profits SDice has. the question is if reduced friction for fiat entry to btc to sdice would add a logrythmic increase in profits...

gesell: i guess he's more focused on stability at the moment, which is fare

gesell: but i'd still contemplate if this friction could be measured

gesell: mircea_popescu: i think so

gesell: because someone else might. because you are going to have competitors coming in that have dealt with fiat hassels for a long time and now adding btc

gesell: noticing this small delay sometimes in bitzino blackjack where after i "stand" and the dealer contemplates what he does there is sometimes a long pause, sometimes not. could be nothign but reminds me of an article 10 years ago in 2600mag where someone saw something similar that indicated when when the dealer had 21. actually it would happen whenever it asked him if he wanted to buy insurance. there was a 5 second delay in the dialog if the dealer had 21.

gesell: the author worked out how to execute that advantage to make oodles

gesell: up, and there is the article (from 2005, hack on paradisepoker.com) http://servv89pn0aj.sn.sourcedns.com/~gbpprorg/2600/paradise_poker.txt

gesell: really? mpex? damn i would've thought mircea_popescu rolled with some textfile foo database like a boss

gesell: sorry, but gonna paste this one on how the author worked out the advantage due to delay on insurance buy (when dealer has ace showing) and working out time required and money that could be made:

gesell: "The dealer will have an Ace as his up card approximately once every 13 hands. Four out of 13 times, the dealer will also have a 10 in the hole. This means that you would get to exploit this bug approximately four times every 169 hands (1/13 x 4/13). This translates to a 2.366 percent more favorable situation for the player. Without the exploit, you would expect to lose 56 cents for every $100 bet. So with the exploit, this translates to a 1.778 percent

gesell: no, oh? nice

gesell: will go check btctalk

gesell: bitcoin is going to change the field of hacking as much as it does finance

gesell: many hackers find 0day and sit on it because publishing wont bring you more money and you already make enough to not care so much. and many companies are horrible about patching and fixing (looking at oracle/java and adobe/flash here). so you sit on it. so, lots of people in this field know that yeah they could pwn xyz companie, grab all the credit cards and then go sell them. but why deal with the hassel of the law. it just requires too much strategizin

gesell: so my point is there is going to be a lot more granularity between black market hackers and the norm, whereas today its a much larger jump mentally to go from one side of that to the other

gesell: your curosity doesnt end with the technology though. it starts to extend into manipulating feer and reaction to having their security and systems go to sht

gesell: mjr_: not really. its what drives people in this field, watching the reaction. my point is though that the step from watching something go to sht because it doesnt work or everyones passwords got dumped, to going to watching money go down the dube... the step between those too just got more granular

gesell: mjr_: yeah

gesell: that is what i mean, they are two different things with huge steps between them and the latter has some pretty clear motivations (black market mentality, edge of the law)

gesell: anyone can point me to some abitrage code that deals with volume in orderbooks (calculating prof based on volume of several bids/asks rather than just the lowest/highest which might be really really small bids)? would like to integrate this into the google abitrage spreadsheet https://docs.google.com/spreadsheet/pub?key=0AguYZ5-dWMgfdElhakdHQzhiQXp5emctdjZTNG9qaEE&gid=0

gesell: once i get the volume issue settled im going to start to code direct buy and sell code for each exchange, direcly into the mofo'ing spreadsheet ;)

gesell: get google to be my damn abitrage bot

gesell: (and yeah, already sent the link before to the code, and will release publicly once it works)

gesell: mjr_: yeah

gesell: everyone says its not profitable. want to find out for myself and then just share the spreadsheet so everyone else can as well

gesell: kinda wanting to push it a bit... maybe we'll get close to NYSE where the closer your bot is to the exchange the better :)

gesell: jurov: totally. im thinking about this as i go

gesell: eh, not really. unless i need instant cash

gesell: mjr_: what are liquidity rebates

gesell: what saa forum thing?

gesell: aah

gesell: mjr_: its not obvious to me if this is happening on btc exchanges. doesnt appear so

gesell: hmm, okay. why dont the others?

gesell: pigeons: i was the one that started it. im playing with it. i hear its not worht it but still gonna learn why

gesell: pigeons: why would it require bitinstant. havent though it through but considered that perhaps one doesnt need instant payout. I guess i've only been looking at the scenerio of "buy btc here, sell over there" but have not thought "get cash back and repeat"

gesell: assumed the "get cash back and repeat" was not as latency burdened so it could take a long while and be okay

gesell: in order to reduce fees

gesell: yeah, so i still made a profit but now im blocked from making more profit

gesell: until i get it back. but if i add more weight and cash at the start i get blocked less and make more profit, no?

gesell: jborkl: the spread of a bunch of exchange fees here https://docs.google.com/spreadsheet/pub?key=0AguYZ5-dWMgfdElhakdHQzhiQXp5emctdjZTNG9qaEE&gid=2

gesell: pigeons: i think im missing the "you didnt make prof until you buy again". sorry i feel stupid here but could you explain why i have to buy again. i took cash, put it in btc, got cash back + %2, and one week later got that cash in my hand

gesell: okay, this is the price chart of 5d for bitcoin-24. http://bitcoincharts.com/charts/chart.png?m=btc24EUR&v=1&t=S&noheader=1&height=80&width=750&r=5 its the only one ive seen like this. not huge volume but as much as many others and yet it is soooo level. I swear, many times ive seen bots respond to my bid, in less than <500ms latency. Im convinced the owners of the exchange have a bot at play on the exchange to keep prices close to mtgox or level or i do

gesell: oh wait, maybe its just the volume adjusting the scale, and since that fluctuates so mutch one doesnt see much of the price fluctuation

gesell: bleh, no, even the large chart looks odd

gesell: aah, no it was the very odd huge 40eu range bid somewhere (glitch i guess)

gesell: ignore me

gesell: funny thread. have sa heard of bitcoingem?? please someone let them know about that

gesell: What is K.KBRL on mpex, or what is the K. category?

gesell: i think google is starting to seriously throttle my all my google code since i put the arbitrage spreadsheet on reddit :/

gesell: grr

gesell: anyone got issues getting to google?

gesell: explain to them that gpg, command line foo and mpex design should be percieved like the days when the internet filled up with idiots... we'd still stick to vms to have some peace of mind from it all

gesell: nice, twitter got hacked due to ruby on rails

gesell: 200k users compromised