pftq.com
Login | Register | Follow via Email / Twitter
August 26th, 2018
Posted by pftq

Offkilted Tides (Piano)

Just something short I improvised a few days ago.  Trying to warm myself back up before doing something longer. Tongue

436 unique view(s)
July 22nd, 2018
Posted by pftq

VR Jetpack Game Website

Put together an official website for the VR Jetpack Game I've been making... Not too shabby for a day's work (or just three hrs really). Got to get back to working on the actual game! Tongue

----------------
524 unique view(s)
June 18th, 2018
Posted by pftq

Price Lookup via Cryptocurrency Screener

Extra benefit of the Cryptocurrency Screener sheet I shared earlier in the year is that you can use it to lookup prices without API limits (which @jbuty's plugin seems to hit).

Below are sample formulas you can use in Google Sheet to query my sheet for cryptocurrency prices:

1. Lookup via Cryptocurrency Screener sheet only (if you don't want to install any plugins):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), 0)

2. Lookup via both Cryptocurrency Screener and CryptoFinance plugin (latter being backup to minimize quota use):
Quote
=IFERROR(INDEX(QUERY(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/12iLyLbSI2odBy4uAIXEm7bLCTds0SApKjsso9UKJ25Q/", "Screener!A:C"), "SELECT Col3 WHERE Col2='BTC'"), 2), IFERROR(CRYPTOFINANCE( "BTC", "price") , 0))
471 unique view(s)
May 31st, 2018
Posted by pftq

Waiting for D Ocean (Piano)

Short piano improvisation done while we were waiting for a friend to be ready to go.

737 unique view(s)
May 27th, 2018
Posted by pftq

Light From Above

The light that comes from the sky but is something other than a happy ending. Short string progression that's been stuck in my head the last few days.

633 unique view(s)