System.FormatException: Input string was not in a correct format.

[ArtemHachaturov]

Hello, please help me, I’ve been suffering for two days now, I have a problem with converting data to a decimal fraction, float, and specifically with

import pandas as pd
from stock_indicators import Quote

Read the CSV file

df = pd.read_csv('./quotes.csv', parse_dates=['Time'])

quotes = [
Quote(date, open, high, low, close, volume)
for date, open, high, low, close, volume
in zip(df['Time'],
df['Open'],
df['High'],
df['Low'],
df['Close'],
df['Volume'], strict=True)]

print(quotes)

---

Traceback (most recent call last):
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators_cstypes\decimal.py", line 22, in new
return CsDecimal.Parse(str(decimal))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
System.FormatException: Input string was not in a correct format.
at System.Number.ThrowOverflowOrFormatException(ParsingStatus status, TypeCode type)
at System.Decimal.Parse(String s)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "e:\Binance Bot\python\13.py", line 8, in
quotes = [
^
File "e:\Binance Bot\python\13.py", line 9, in
Quote(date, open, high, low, close, volume)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators\indicators\common\quote.py", line 61, in init
self.open: Decimal = open if open else 0
^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators\indicators\common\quote.py", line 25, in _set_open
quote.Open = CsDecimal(value)
^^^^^^^^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators_cstypes\decimal.py", line 24, in new
raise ValueError("You may be using numeric data that is incompatible with your locale environment settings.\n"
ValueError: You may be using numeric data that is incompatible with your locale environment settings.
For example, you may be using decimal points instead of commas.

quotes.csv

[DaveSkender]

Let us know if these conversations helps resolve your issue:

• Help! Converting Pandas DataFrame to iterable Quotes #1165
• `FormatException` when converting pandas.DataFrame to iterable quotes #1164

[DaveSkender]

check for pd date/timestamp compatibility too, you may need to set locale category to locale.LC_ALL, or convert your dates to a compatible string format.

[DaveSkender]

does this work okay?
open_price = 123,45
open_decimal = Decimal(str(open_price))
print(type(open_decimal))

[ArtemHachaturov]

This method df = pd.read_csv('quotes.csv', parse_dates=['Time']) correctly executes parse_dates=['Time'] without any obstacles and it passes through perfectly Time datetime64[ns] there is no problem with this.

But now there is a problem with the data and locale.LC_ALL does not help (locale.LC_NUMERIC, 'en_US.UTF-8') still the same error

[ArtemHachaturov]

open_price = 123.45
open_decimal = Decimal(str(open_price))
print(type(open_decimal)) #<class 'decimal.Decimal'>

#but if

quote = Quote(date, open_decimal, 0, 0, 0, 0)

---

Traceback (most recent call last):
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators_cstypes\decimal.py", line 22, in new
return CsDecimal.Parse(str(decimal))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
System.FormatException: Input string was not in a correct format. at System.Number.ThrowOverflowOrFormatException(ParsingStatus
status, TypeCode type)
at System.Decimal.Parse(String s)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "e:\Binance Bot\python\12.py", line 51, in
quote = Quote(date, open_decimal, 0, 0, 0, 0)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators\indicators\common\quote.py", line 61, in init
self.open: Decimal = open if open else 0
^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators\indicators\common\quote.py", line 25, in _set_open
quote.Open = CsDecimal(value)
^^^^^^^^^^^^^^^^
File "C:\Users\russt\AppData\Local\Programs\Python\Python311\Lib\site-packages\stock_indicators_cstypes\decimal.py", line 24, in new
raise ValueError("You may be using numeric data that is incompatible with your locale environment settings.\n"
ValueError: You may be using numeric data that is incompatible with your locale environment settings.
For example, you may be using decimal points instead of commas.
PS E:\Binance Bot\python>

[ArtemHachaturov]

import locale
locale.setlocale(locale.LC_ALL, 'en_US.UTF-8')

Does not help

[DaveSkender]

I think we're going to need to setup a rather elaborate set of tests using different local settings on a GitHub Actions runner to better understand exactly what's happening. It's difficult to test on a local computer, and I'm not 100% confident I know what's happening.

Any one of these can be a problem if they're not aligned on locale for date/time and numerics:

• source quotes format
• environment/machine locale
• dotnet native locale
• python native locale
• Python.NET locale handling
• pandas dataFrame locale handling
• DLL compiled default locale handling

cc @LeeDongGeon1996

[DaveSkender]

I've created a tracking issue:

• System.FormatException: Input string was not in a correct format facioquo/stock-indicators-python#382