pricehist

https://pypi.org/project/pricehist/
Admin
A command-line tool for fetching and formatting historical price data from multiple sources with...
Tokens:4,003
Snippets:44
Trust Score:10
Update:5 months ago
Show doc for...
Tokens:
Raw
### Install pricehist with pipx

Source: https://pypi.org/project/pricehist

Install the pricehist tool using pipx for isolated environments. Ensure pipx is installed first.

```bash
pipx install pricehist

```

--------------------------------

### Show Source Information

Source: https://pypi.org/project/pricehist

Displays detailed information about a specific price data source, including its ID, name, description, URL, start date, supported types, and any relevant notes.

```bash
pricehist source alphavantage

```

```text
ID          : alphavantage
Name        : Alpha Vantage
Description : Provider of market data for stocks, forex and cryptocurrencies
URL         : https://www.alphavantage.co/
Start       : 1995-01-01
Types       : close, open, high, low, adjclose, mid
Notes       : Alpha Vantage has data on...

```

--------------------------------

### Fetch latest price using bean-price

Source: https://pypi.org/project/pricehist

Integrate pricehist with Beancount by using `bean-price` to fetch the latest price directly from the command line. Ensure the `pricehist` package is installed.

```bash
bean-price -e "USD:pricehist.beanprice.coindesk/BTC:USD"

```

--------------------------------

### CSV output of ECB prices

Source: https://pypi.org/project/pricehist

Example of the default CSV output format for fetched price data, including date, base currency, quote currency, amount, source, and type.

```csv
date,base,quote,amount,source,type
2021-01-04,EUR,AUD,1.5928,ecb,reference
2021-01-05,EUR,AUD,1.5927,ecb,reference
2021-01-06,EUR,AUD,1.5824,ecb,reference
2021-01-07,EUR,AUD,1.5836,ecb,reference
2021-01-08,EUR,AUD,1.5758,ecb,reference

```

--------------------------------

### Update Existing Price File

Source: https://pypi.org/project/pricehist

Updates an existing CSV price file by fetching new prices from the last recorded date. It uses `tail` to get the last date, `cut` to extract it, `pricehist fetch` to get new data, `sed` to remove the header, and `>>` to append.

```bash
last=$(tail -1 prices-eur-usd.csv | cut -d, -f1)
pricehist fetch ecb EUR/USD -sx $last -o csv | sed 1d >> prices-eur-usd.csv

```

--------------------------------

### List Available Symbols for a Source

Source: https://pypi.org/project/pricehist

Lists all available currency pairs or symbols supported by a specific data source, showing their mnemonics and descriptions.

```bash
pricehist source ecb --symbols

```

```text
EUR/AUD    Euro against Australian Dollar
EUR/BGN    Euro against Bulgarian Lev
EUR/BRL    Euro against Brazilian Real
EUR/CAD    Euro against Canadian Dollar
EUR/CHF    Euro against Swiss Franc
...

```

--------------------------------

### Show pricehist fetch command usage

Source: https://pypi.org/project/pricehist

Displays the help message for the 'pricehist fetch' command, outlining available options and arguments.

```bash
pricehist fetch -h

```

--------------------------------

### Fetch a series of prices with bean-price

Source: https://pypi.org/project/pricehist

Fetch a series of prices by providing a Beancount file to `bean-price`. Use the `:close` suffix to specify the closing price. Options like `--update`, `--update-rate`, `--inactive`, and `--clear-cache` can be used for managing price data.

```beancount
; input.beancount
2021-08-14 commodity BTC
  price: "USD:pricehist.beanprice.coindesk/BTC:USD:close"

```

```bash
bean-price input.beancount --update --update-rate daily --inactive --clear-cache

```

--------------------------------

### Generate BTC/USD price chart with gnuplot

Source: https://pypi.org/project/pricehist

Fetches Bitcoin to US Dollar prices from CoinDesk, processes the CSV output to extract date and price, and pipes it to gnuplot for visualization. Requires gnuplot and sed/cut utilities.

```bash
pricehist fetch coindesk BTC/USD -s 2021-01-01 | \
  sed 1d | \
  cut -d, -f1,4 | \
  gnuplot -p -e \
    "set datafile separator \",\""; \
    set xdata time; \
    set timefmt \"%Y-%m-%d\"; \
    set format x \"%b\\n%Y\"; \
    plot \"/dev/stdin\" using 1:2 with lines title \"BTC/USD\"

```

--------------------------------

### Fetch Prices with Ledger Output

Source: https://pypi.org/project/pricehist

Fetches historical price data for EUR/AUD from ECB between specified dates and outputs it in ledger format.

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-04 -e 2021-01-08 -o ledger

```

```text
P 2021-01-04 00:00:00 EUR 1.5928 AUD
P 2021-01-05 00:00:00 EUR 1.5927 AUD
P 2021-01-06 00:00:00 EUR 1.5824 AUD
P 2021-01-07 00:00:00 EUR 1.5836 AUD
P 2021-01-08 00:00:00 EUR 1.5758 AUD

```

--------------------------------

### Load Prices into GnuCash via SQL

Source: https://pypi.org/project/pricehist

Generates SQL statements to load price data into a GnuCash database and pipes them to `sqlite3`, `mysql`, or `psql` for immediate application. Ensure GnuCash commodities match the price data.

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-01 -o gnucash-sql | sqlite3 Accounts.gnucash
```

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-01 -o gnucash-sql | mysql -u username -p -D databasename
```

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-01 -o gnucash-sql | psql -U username -d databasename -v ON_ERROR_STOP=1

```

--------------------------------

### Fetch Prices with Custom Formatting

Source: https://pypi.org/project/pricehist

Fetches historical price data with custom formatting for time, date separator, base currency symbol, quote symbol, and symbol placement.

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-04 -e 2021-01-08 -o ledger \
  --fmt-time '' --fmt-datesep / --fmt-base € --fmt-quote $ --fmt-symbol left

```

```text
P 2021/01/04 € $1.5928
P 2021/01/05 € $1.5927
P 2021/01/06 € $1.5824
P 2021/01/07 € $1.5836
P 2021/01/08 € $1.5758

```

--------------------------------

### pricehist fetch command usage details

Source: https://pypi.org/project/pricehist

Detailed usage information for the 'pricehist fetch' command, including positional arguments like SOURCE and PAIR, and various optional arguments for date ranges, output formats, and formatting.

```text
usage: pricehist fetch SOURCE PAIR [-h] [-vvv] [-t TYPE] [-s DATE | -sx DATE] [-e DATE | -ex DATE]
[-o beancount|csv|json|jsonl|gnucash-sql|ledger] [--invert] [--quantize INT]
[--fmt-base SYM] [--fmt-quote SYM] [--fmt-time TIME] [--fmt-decimal CHAR] [--fmt-thousands CHAR]
[--fmt-symbol rightspace|right|leftspace|left] [--fmt-datesep CHAR]
[--fmt-csvdelim CHAR] [--fmt-jsonnums]

positional arguments:
  SOURCE                   the source identifier
  PAIR                     pair, usually BASE/QUOTE, e.g. BTC/USD

optional arguments:
  -h, --help               show this help message and exit
  -vvv, --verbose          show all log messages
  -t TYPE, --type TYPE     price type, e.g. close
  -s DATE, --start DATE    start date, inclusive (default: source start)
  -sx DATE, --startx DATE  start date, exclusive
  -e DATE, --end DATE      end date, inclusive (default: today)
  -ex DATE, --endx DATE    end date, exclusive
  -o FMT, --output FMT     output format (default: csv)
  --invert                 invert the price, swapping base and quote
  --quantize INT           round to the given number of decimal places
  --fmt-base SYM           rename the base symbol in output
  --fmt-quote SYM          rename the quote symbol in output
  --fmt-time TIME          set a particular time of day in output (default: 00:00:00)
  --fmt-decimal CHAR       decimal point in output (default: '.')
  --fmt-thousands CHAR     thousands separator in output (default: '')
  --fmt-symbol LOCATION    commodity symbol placement in output (default: rightspace)
  --fmt-datesep CHAR       date separator in output (default: '-')
  --fmt-csvdelim CHAR      field delimiter for CSV output (default: ',')
  --fmt-jsonnums           numbers not strings for JSON output (default: False)

```

--------------------------------

### Fetch historical price data with verbose output

Source: https://pypi.org/project/pricehist

Use the `--verbose` or `-vvv` option to see `curl` commands for each request. This helps in debugging and understanding the data fetching process.

```bash
pricehist fetch coindesk BTC/USD -s 2021-01-01 -e 2021-01-05 -vvv

```

--------------------------------

### Fetch historical price data

Source: https://pypi.org/project/pricehist

Use this command to fetch historical price data for a specific pair and price type from a given source. Ensure the source ID, pair, and price type are correctly specified.

```bash
pricehist fetch coindesk BTC/USD --type close
```

--------------------------------

### Search for Symbols from a Source

Source: https://pypi.org/project/pricehist

Searches for specific symbols within a data source, returning matching entries with their ticker, name, exchange, and currency.

```bash
pricehist source alphavantage --search Tesla

```

```text
TL0.DEX       Tesla, Equity, XETRA, EUR
TL0.FRK       Tesla, Equity, Frankfurt, EUR
TSLA34.SAO    Tesla, Equity, Brazil/Sao Paolo, BRL
TSLA          Tesla Inc, Equity, United States, USD
TXLZF         Tesla Exploration Ltd, Equity, United States, USD

```

--------------------------------

### Fetch historical price data using pricehist library

Source: https://pypi.org/project/pricehist

Use the `pricehist` library in Python to fetch historical price data programmatically. Import `Series` and a specific source class (e.g., `ECB`). The `fetch` method returns a `Series` object containing price data.

```python
from pricehist.series import Series
from pricehist.sources.ecb import ECB
series = ECB().fetch(Series("EUR", "AUD", "reference", "2021-01-04", "2021-01-08"))
print(series.prices)

```

--------------------------------

### Fetch ECB prices for EUR/AUD

Source: https://pypi.org/project/pricehist

Fetches European Central Bank reference exchange rates for EUR to AUD between specified dates. The default output format is CSV.

```bash
pricehist fetch ecb EUR/AUD -s 2021-01-04 -e 2021-01-08

```

--------------------------------

### Inspect verbose output and curl commands

Source: https://pypi.org/project/pricehist

This command captures verbose output, filters for `curl` commands, removes the `DEBUG` prefix, and executes them using `bash` piped to `jq` for JSON parsing. It shows the exact HTTP request made and the resulting JSON data.

```bash
pricehist fetch coindesk BTC/USD -s 2021-01-01 -e 2021-01-05 -vvv 2>&1 \
  | grep '^DEBUG curl' | sed 's/^DEBUG //' | bash | jq .

```
Tokens:
Raw