Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Google's Code Editor

docs.google.com

Post reply on HN
Print view View original

71–80 of 88 posts

Re: Google's Code Editor

#71

Post by notJim »

roguecoder wrote: post #62
kjhughes wrote: post #43

The link title will attract developers anxious to see what Google is offering or Googlers are using to edit code, but this is just an online editor designed for Apps Script editing. It's been around a long time and is less interesting than the link-bait title suggests. Google Apps Script is very useful in conjunction with Google's online apps and their rich libraries. JavaScript makes for a good customization languag…

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.

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.

Re: Google's Code Editor

#72

Post by niqolas »

notJim wrote: post #71
roguecoder wrote: post #62

Earlier quoted context omitted.

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.

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…

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.

Re: Google's Code Editor

#73

Post by sad_panda »

notJim wrote: post #71
roguecoder wrote: post #62

Earlier quoted context omitted.

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.

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…

What part did you use the scripting engine for? I was able to do something very similar, but purely with spreadsheet rules.

Re: Google's Code Editor

#74

Post by sad_panda »

gouranga wrote: post #35
dewitt wrote: post #31

Earlier quoted context omitted.

I don't think you're trolling; Excel is certainly an option. But for two things: Excel for Mac - $129 (http://www.amazon.com/dp/B003YCOJBC) Excel for Win - $121 (http://www.amazon.com/dp/B0039L2XG6) And you need a Windows box or Mac with Excel installed. I personally have access to dozens of machines, literally none of which have Excel. All of them have a web browser, and thus access to Google Spreadsheets and Google…

That's not a major issue.: You can use Office 2010 web apps FREE from a SkyDrive account and openly collaborate with people or you can pay $20 a month per seat for Office 365 and you will get Sharepoint and ALL Office 2010 desktop apps. The office web apps work perfectly in all browsers (I've tried Chrome, Firefox and IE). Considering the cost of playing around with Google spreadsheet with those restrictions, it's po…

Does the Excel web app support VBA? I was under the impression that the 365 apps offer a subset of the functionality of their desktop counterparts.

Re: Google's Code Editor

#75

Post by emmelaich »

lparry wrote: post #69
debacle wrote: post #56

Earlier quoted context omitted.

Excel files are simply zip files with XML in them.

What version control system will let you see the changes between the contents of two zip files again?

With Git and Svn you can specify the diff to use, so you can use something like oodiff if you are versioning OpenOffice files.

Something to diff zips of xml almost certainly exists and could be used in the same manner.

Now, patch is another thing ...

Re: Google's Code Editor

#76

Post by rkwz »

drivebyacct2 wrote: post #70
pyrotechnick wrote: post #10

It's CodeMirror - http://codemirror.net/

Tis a shame, there are far more comprehensive and impressive displays of what Code Mirror can do than this. CodeMirror makes the OP's link extremely trivial to implement. edit: Sorry, this isn't meant to be a dig on the Google's Code Editor as much as it's meant to be praise of how impressive I find CodeMirror (and it's competitor/friend Ace).

> there are far more comprehensive and impressive displays of what Code Mirror can do than this.

Can you give some examples?

Re: Google's Code Editor

#77

Post by notJim »

sad_panda wrote: post #73
notJim wrote: post #71

Earlier quoted context omitted.

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…

What part did you use the scripting engine for? I was able to do something very similar, but purely with spreadsheet rules.

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

Re: Google's Code Editor

#78

Post by notJim »

niqolas wrote: post #72
notJim wrote: post #71

Earlier quoted context omitted.

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…

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.

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-...

Re: Google's Code Editor

#79

Post by ntoshev »

notJim wrote: post #71
roguecoder wrote: post #62

Earlier quoted context omitted.

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.

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…

> 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

Re: Google's Code Editor

#80

Post by ntoshev »

selectnull wrote: post #24

Last year I've used Google Apps Script to automate a spreadsheet, it worked very well and that spreadsheet is still used inside my company. It's not very complex, all together maybe 200 lines of code, with tests. But, I'm not sure if I would do it again. Development style is not enjoyable, coding inside textarea with syntax highlighting is simply not good enough. I would prefer to use my text editor and some way to d…

The server environment is JVM-based since they expose GWT as the way to build UI. I think I remember seeing Rhino-specific error messages.

The coding environment is not very good, but you can build ERPs, CRMs, document management and similar for small businesses on Google Docs, in a way Microsoft Office / VBA never made possible. The modules it provides (spreadsheets, forms, formatted text document, gmail, calendar, wiki) seem to be very useful building blocks for describing your business processes.

Post reply on HN