search

avibrazil / investorzilla

Use your investments spreadsheet (Excel, Google Sheets) containing assets’ ledger and balance to get powerful insights of your investments health and performance, in multiple currencies, including crypto and market indexes.
GNU General Public License v3.0
3 stars 0 forks source link

investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter / ubuntu 20 / python 3.10 #6

Closed johnfelipe closed 7 months ago

johnfelipe commented 7 months ago

SNAG-0008

- type: !!python/name:investorzilla.portfolios.google_sheets.GoogleSheetsBalanceAndLedger ''
  params:
    sheetStructure:
        # This Google Sheet is an example that should work out of the box
        sheet: 1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U

and in console show me this:

(env) root@template:~/investorzilla/investorzilla# investorzilla

Collecting usage statistics. To deactivate, set browser.gatherUsageStats to False.

  You can now view your Streamlit app in your browser.

  Network URL: http://192.168.20.14:8502
  External URL: http://181.51.32.154:8502

2023-12-11 17:22:18,657|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=USD
2023-12-11 17:22:18,659|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
            SELECT *
            FROM DataCache__BCBCurrencyConverter
            WHERE
                __DataCache_id   = 'USD' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__BCBCurrencyConverter
                WHERE __DataCache_id = 'USD'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:18,660|INFO|investorzilla.datacache.DataCache|No cache for kind=BCBCurrencyConverter and id=EUR
2023-12-11 17:22:18,661|INFO|investorzilla.datacache.DataCache|No cache for kind=gsheet•generic__ledger and id=1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U
2023-12-11 17:22:18,666|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__gsheet•generic__ledger
[SQL:
            SELECT *
            FROM DataCache__gsheet•generic__ledger
            WHERE
                __DataCache_id   = '1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__gsheet•generic__ledger
                WHERE __DataCache_id = '1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:18,666|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__BCBCurrencyConverter
[SQL:
            SELECT *
            FROM DataCache__BCBCurrencyConverter
            WHERE
                __DataCache_id   = 'EUR' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__BCBCurrencyConverter
                WHERE __DataCache_id = 'EUR'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:18,672|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBMarketIndex and id=IPCA has 526 entries and was cached at 2023-12-11 17:18:45.284489
2023-12-11 17:22:18,812|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBMarketIndex and id=CDI has 9446 entries and was cached at 2023-12-11 17:18:46.503898
2023-12-11 17:22:19,470|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBMarketIndex and id=SELIC has 9404 entries and was cached at 2023-12-11 17:18:46.914460
2023-12-11 17:22:19,998|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBMarketIndex and id=IGPM has 414 entries and was cached at 2023-12-11 17:18:45.012878
2023-12-11 17:22:20,036|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBMarketIndex and id=INPC has 535 entries and was cached at 2023-12-11 17:18:45.405681
2023-12-11 17:22:20,070|INFO|investorzilla.datacache.DataCache|No cache for kind=gsheet•generic__balance and id=1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U
2023-12-11 17:22:20,072|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^GSPC
2023-12-11 17:22:20,073|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = '^GSPC' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = '^GSPC'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,072|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__gsheet•generic__balance
[SQL:
            SELECT *
            FROM DataCache__gsheet•generic__balance
            WHERE
                __DataCache_id   = '1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__gsheet•generic__balance
                WHERE __DataCache_id = '1U2SAvRuwcA74heo2dAeFvKuH5zFLowlCGdn4-tcVC9U'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,074|INFO|investorzilla.portfolio.GoogleSheetsBalanceAndLedger|Google authentication…
2023-12-11 17:22:20,077|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=SPY
2023-12-11 17:22:20,078|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = 'SPY' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = 'SPY'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,081|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=VOO
2023-12-11 17:22:20,081|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = 'VOO' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = 'VOO'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,078|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=IVV
2023-12-11 17:22:20,082|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^BVSP
2023-12-11 17:22:20,083|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = '^BVSP' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = '^BVSP'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,083|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^DJI
2023-12-11 17:22:20,083|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = 'IVV' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = 'IVV'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:20,084|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = '^DJI' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = '^DJI'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:37,649|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=USD, time=2023-12-11 17:22:37.648424+00:00
2023-12-11 17:22:38,582|INFO|investorzilla.datacache.DataCache|Set cache to kind=BCBCurrencyConverter, id=EUR, time=2023-12-11 17:22:38.581396+00:00
2023-12-11 17:22:49,181|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=^IXIC
2023-12-11 17:22:49,182|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = '^IXIC' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = '^IXIC'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:22:49,249|INFO|investorzilla.datacache.DataCache|No cache for kind=YahooMarketIndex and id=QQQM
2023-12-11 17:22:49,249|INFO|investorzilla.datacache.DataCache|(sqlite3.OperationalError) no such table: DataCache__YahooMarketIndex
[SQL:
            SELECT *
            FROM DataCache__YahooMarketIndex
            WHERE
                __DataCache_id   = 'QQQM' AND
                __DataCache_time =
            (
                SELECT DISTINCT __DataCache_time
                FROM DataCache__YahooMarketIndex
                WHERE __DataCache_id = 'QQQM'
                ORDER BY __DataCache_time DESC
                LIMIT 1
            )

        ]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2023-12-11 17:23:06,903|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=IVV, time=2023-12-11 17:23:06.902823+00:00
2023-12-11 17:23:06,913|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^BVSP, time=2023-12-11 17:23:06.912169+00:00
2023-12-11 17:23:07,014|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=SPY, time=2023-12-11 17:23:07.013611+00:00
2023-12-11 17:23:09,282|INFO|investorzilla.datacache.DataCache|Cache empty for kind=YahooMarketIndex and id=QQQ
2023-12-11 17:23:09,293|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=VOO, time=2023-12-11 17:23:09.292406+00:00
2023-12-11 17:23:10,572|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=QQQM, time=2023-12-11 17:23:10.564232+00:00
2023-12-11 17:23:10,604|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^DJI, time=2023-12-11 17:23:10.603471+00:00
2023-12-11 17:23:10,813|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^GSPC, time=2023-12-11 17:23:10.813061+00:00
2023-12-11 17:23:11,106|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBCurrencyConverter and id=USD has 68112 entries and was cached at 2023-12-11 17:22:37.648424
2023-12-11 17:23:12,210|INFO|investorzilla.datacache.DataCache|Set cache to kind=YahooMarketIndex, id=^IXIC, time=2023-12-11 17:23:12.210234+00:00
2023-12-11 17:23:16,161|INFO|investorzilla.datacache.DataCache|Cache for kind=BCBCurrencyConverter and id=EUR has 63762 entries and was cached at 2023-12-11 17:22:38.581396
avibrazil commented 7 months ago

Forget Google Sheets. Use Google Sheets with another backend. Use the new example I just published and commented on the other bug.