News for hackers. Stuff that matters.

A comment on Google's Code Editor. Parent comment

Re:Google's Code Editor by roguecoder on Wednesday May 16, 2012 @05:24PM (#3984090)
That model does work reasonably well for use cases like roleplaying game character sheets, where individual players may want to tweak the scripts for their specific character.

It is incredibly useful in general, but definitely not news.

[ Parent | on HN ]
Re:Google's Code Editor by notJim on Wednesday May 16, 2012 @10:12PM (#3985018)
I have a financial spreadsheet that I use to track the distribution of my portfolio. I follow a system where I have a target allocation for each of a small number of assets, and then I buy or sell shares when any given asset gets beyond a certain tolerance of its target allocation.

Using Google Spreadsheets and the Google finance API available with Google Apps script, I was able to automate every part of this except syncing it with my account (since there's no API to access my financial records.) All I have to do is click a button, and the cells change color based on whether I should buy, sell or hold.

[ Parent | on HN ]
Re:Google's Code Editor by niqolas on Wednesday May 16, 2012 @11:36PM (#3985270)
I'd be really interested to see how your set-up works. Would it be possible for you to share your files/code and a short description of how you implemented your set-up? I am happy for you to remove/sanitize sensitive details relating to your portfolio. However, I would love to understand how I can develop a solution like this for myself.

Thank you for your help.

[ Parent | on HN ]
Re:Google's Code Editor by notJim on Thursday May 17, 2012 @02:45AM (#3985794)
What I have is a sheet which says how many of each asset I own, and the desired allocation. Then, there is a cell that calculates the current allocation, based on the number of shares, and the current price of the share.

The current price of the share is fetched from another sheet using a vlookup. That sheet is populated by the script. The script is here! https://gist.github.com/2717042

The overall system is based on research I found here: http://seekingalpha.com/article/15134-the-seeking-alpha-etf-...

[ Parent | on HN ]
Re:Google's Code Editor by ntoshev on Thursday May 17, 2012 @03:45AM (#3985916)
> I was able to automate every part of this except syncing it with my account (since there's no API to access my financial records.)

It's actually possible to simulate a browsing session and have the App Script log in to your broker's site and scrape the data you need. Here is some prototyping code: https://gist.github.com/aaf74e50b9a281396722

[ Parent | on HN ]
Re:Google's Code Editor by sad_panda on Wednesday May 16, 2012 @11:50PM (#3985304)
What part did you use the scripting engine for? I was able to do something very similar, but purely with spreadsheet rules.
[ Parent | on HN ]
Re:Google's Code Editor by notJim on Thursday May 17, 2012 @02:40AM (#3985777)
The scripting engine fetches up-to-date stock quotes and fills them in. The rest is all done using spreadsheet rules.

Here is the scripting engine part: https://gist.github.com/2717042

[ Parent | on HN ]