Finance | quantitative finance Python programs to help you gather | Business library

I have a google sheet in which I am some Cryptocurrencies Price Data that I get using googleFinance or yahoo. However, I found it difficult to do this with some coins such as Synthetix Network Token.

I have been reading other questions in Stackoverflow and applying the suggestions but none seem to work with this particular cryptocurrency.

If there is someone who has done this before, could you tell me what approach are you using?

Update:

I have tried this:

How do I create charts pulling from the database? I've tried MorrisJS, ChartJS, CanvasJS, HighCharts. But I think the closest I got is with ChartJS so hopefully we can stick to that.

I need to create a chart that pulls data from the db and using more than 1 table in the database, for example, Database name "Finance", I need a bar chart that compares sum of Amount in dbo.Revenue and Sum of Amount in dbo.Expense by month. Month is the x-axis. Something like this , but I did this manually by adding the values in the code.

What I have tried to do to pull from the db, ar is the table name (revenue)

I trying to calculate ADX indicator using using library called ta - link

I am using yahoo finance API to get the data.

this is my code

I am using code first approach for my .net core project. We are using multiple schemas in single database. We are maintaining models in different class library projects like Inventory,Sales,Finance etc ..
Model mapping is like ( note : below they are different name spaces)

I'm having trouble with the CSV export result on a website I am trying to scrape data from.

Output Problems: Output in column but just the first column and it only output's the first column of data

Output in rows but just one row

I just want it to output the typical way

Here's a segment of the whole site's html where my particular target is:

I am trying to create a list of button/links in a menu bar ul>li>a tags using pure CSS3 transform: rotate as shown in the below image.

For this purpose, I tried the below code.

HTML

I'm trying to find a way to import Azure AD users to Dynamics 365 Finance & Operations (D365FO).

It is possible to get all system users using this endpoint (like using Postman):

I have around 50 stocks for which I need to pass the variable ticker1, ticker2, ticker3.....ticker50 in the URL. Currently, I wrote a repetitive 50 URLs where I pass Tickers from ticker1, ticker2...ticker50 seperately. How can I acheieve it without repeating the lines of code?

So intead of having url1...url2....url50, I have one single url where it loops in all the tickers for ticker1-50 and it retrieves/downloads multiple csv in a given path.

Below is my repetitive code which achieves the result but i want to optimize it and make it clutter free.

I applied case_when to a text data of thousands of rows to detect strings with multiple conditions and replace them but got a wrong result because case_when doesn't execute the remaining conditions once a condition is met. I have seen a solution in How to detect more than one regex in a case_when statement, but the solution does not have multiplicity of multiple conditions such as in my data.

Any alternative to case_when will be is appreciated.

This is the dummy data: