Search Results for "excel"

...VisiData works with CSV files, Excel spreadsheets, SQL databases, and many other data sources.

...The terminal allows for users to import their own proprietary datasets to use on our econometric menu. In addition, users are allowed to export any type of data to any type of format whether that is raw data in Excel or an image in PNG. This is ideal for finance content creation. Create notebook templates (through papermill) which can be run on different tickers. This level of automation allows to speed up the development of your investment thesis and reduce human error.

...You can have a look at all the API calls available in their API documentation. For code-less access to the APIs, you may also consider the official Google Sheet Add-on or the Microsoft Excel Add-on by Alpha Vantage. To get data from the API, simply import the library and call the object with your API key. Next, get ready for some awesome, free, realtime finance data. Your API key may also be stored in the environment variable ALPHAVANTAGE_API_KEY. The library supports giving its results as json dictionaries (default), pandas dataframe (if installed) or csv, simply pass the parameter output_format='pandas' to change the format of the output for all the API calls in the given class.

US Tax Forms (1040 Schedule D and 8949 supplemental forms) require that every capital gains sale is listed by line, even if no cost basis or even a 1099-B has been provided to the IRS. Entering this data into tax software like TurboTax is tedious and error prone. Some institutions provide limited export capabilities such as CSV or excel export but this is not easy to translate into tax preparation software. These python scripts convert two simple to generate input files BuyLots.csv and Sales.csv into a .TXF file that can be imported into tax prep software and a second RemainingLots.csv that can be used for next year. The scripts automatically calculate the First In First Out lots for every sale and properly tag them in the TXF format ( https://turbotax.intuit.com/txf/TXF042.jsp ). ...

...Dependencies + Python (>=2.7, <3.0) + numpy (>=1.1.0) + wxPython (>=2.8.10.1, Unicode version required) + matplotlib (>=1.1.1) + pycairo (>=1.8.8) Optional dependencies + python-gnupg (>=0.3.0, for opening own files without approval) + xlrd (>=0.9.2, for loading Excel® files) + xlwt (>=0.9.2, for saving Excel files, pyspread >=v0.3.0 required) + jedi (>=0.8.0, for tab completion and context help in the entry line, pyspread >=v0.3.0 required) + basemap (>=1.0.7, for the weather example pys file)

iTelliHashExcel is a cryptographic “one-way” hashing application designed to securely protect sensitive or private information from disclosure. Proper use of this program allows organizations, businesses, and individuals (i.e., the data owners) to share complete/intact datasets containing sensitive data with others without actually disclosing the sensitive or private information. Additionally, if such datasets are subsequently modified or enhanced through value-added services or products...

An Excel addin and server framework for implementing remote excel user-defined functions (UDFs). This framework is designed to provide a centralised warehouse of functions for Excel users (eg. within an organisation).

Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM

PythonOffice is a Python API for the Ms XML (Excel) Spreadsheet format. It allows you to read and write Excel XML documents from within the Python programming language. In future, support for other formats is planned, including OOo, Ms Open Xml.

pyXLWriter is a Python library for generating Excel compatible spreadsheets. It's a port of John McNamara's Perl Spreadsheet::WriteExcel 1.0 module (see http://www.cpan.org) to Python. Requires Python 2.1+. [Project was stopped]

The main purpose of "python2xlw" is to create an Excel-compatible file which can be sent to users via the web as an excel application. The motivation is mainly to support the display of XY Scatter plots and tabular numerical data(eg engineering data)