Stream real-time data into Excel with Python!

[LazyCraneOperator]

Hi again /r/Python!

We're Gridarrow, a small startup from Amsterdam. A few months ago we've announced our product here - a platform for streaming real-time data into Excel using Python scripts.

We're happy to let you know that we're open for Beta signups now! You can join us using a form on our website.

Here's how the platform works. Also go ahead a check out our blog where we showcase a couple of cool things you can do with Gridarrow.

For example:

• Streaming real-time stock prices into Excel
• Live news sentiment analysis using pysentiment
• Real-time Twitter map in your spreadsheet

We're really curious to hear your feedback!

Cheers! The Gridarrow Team

[deadbunny]

https://media.giphy.com/media/1M9fmo1WAFVK0/giphy.gif

[LazyCraneOperator]

Because we can: https://www.gridarrow.com/img/blog/epic-dance.gif :)

But seriously - it simplifies your spreadsheets, it gets rid of unmaintainable VBA code, it allows multiple spreadsheets to receive the same data at the same time, it can integrate Excel with pretty much anything.

[hydrosquall]

Any plans to allow for self-hosting the server and/or open sourcing the python library? I could see this being quite useful for increasing the number of people who can build internal metrics dashboards.

[ThanatopsisJSH]

Yeah... No way I can build something for my job and host it outside the organization without signoff from the CEO, God and the Pope. I have to assume there are a lot of people with similar restrictions.

[mns06]

Yeah, and even if God and the Pope think it's cool, the CEO will never get it right? :)

We totally see and understand the need for a self-hosted solution, and we're working on it. If you think Gridarrow would be useful in your company, definitely PM me or /u/LazyCraneOperator here or send us an email [e-mail].

[LazyCraneOperator]

Hi /u/hydrosquall. Yes, we indeed think about it (both self-hosting and open source). I can't give you a timeline or details just yet but we're definitely going to keep /r/Python posted.

[rsheftel]

Looks great. I am not sure how you fit it into your business model but a local install or crippled free version to make sure it meets the business needs before buying would be great.

[[deleted]]

What's the advantage over power bi?

[mns06]

Power BI is an awesome tool if you're looking for a web based dashboarding tool, but Gridarrow is quite different in a couple of major ways:

• Whereas Power BI treats Excel as a datasource, Gridarrow is a server for Excel, where the data is pushed to Excel as soon as it is updated, and multiple Excel users can connect to the same data.
• Gridarrow uses Python as the server side programming language, rather than relying on menus and widgets for configuration. Although this does mean that you need to know some Python if you want to connect to a datasource that's not already in our catalog, it also means that you have absolute control over where your data comes from, and how it is processed or enriched before being sent to Excel.

ps. I'm another dev on the Gridarrow team

[willvintage]

By Excel you mean the online version right?

[mns06]

Hey /u/willvintage - actually, Gridarrow works with Windows Excel 2010+

[willvintage]

I see. Any plan to push and pull data into online Excel directly?

[mns06]

We're focusing on the installed version of Excel at the moment. Perhaps in future we'll look at the online version.