How to export Databank sheet to CSV file?

Hii

 

First question is

How to export Databank sheet to CSV file?

 

I copy  and paste to excel but fail

 

It shows

 

True

com.strategyquant.core.gui.tables.TableCellData@5ac381bc

com.strategyquant.core.gui.tables.TableCellData@5c998ec5

com.strategyquant.core.gui.tables.TableCellData@6b2682d4

com.strategyquant.core.gui.tables.TableCellData@2c292621

com.strategyquant.core.gui.tables.TableCellData@6a218c79

com.strategyquant.core.gui.tables.TableCellData@7a5ed85e

com.strategyquant.core.gui.tables.TableCellData@25b1c5e3

com.strategyquant.core.gui.tables.TableCellData@40cce75a

com.strategyquant.core.gui.tables.TableCellData@2668f97e

com.strategyquant.core.gui.tables.TableCellData@2a7849c5

com.strategyquant.core.gui.tables.TableCellData@1cd1fb4

com.strategyquant.core.gui.tables.TableCellData@269ccee0

com.strategyquant.core.gui.tables.TableCellData@475e6044

com.strategyquant.core.gui.tables.TableCellData@2f003f0b

com.strategyquant.core.gui.tables.TableCellData@46d9b5e0

com.strategyquant.core.gui.tables.TableCellData@6f28815

com.strategyquant.core.gui.tables.TableCellData@321a94cf

com.strategyquant.core.gui.tables.TableCellData@1ccc1de0

com.strategyquant.core.gui.tables.TableCellData@17b1cd2c

com.strategyquant.core.gui.tables.TableCellData@5914def

com.strategyquant.core.gui.tables.TableCellData@634b1d7e

com.strategyquant.core.gui.tables.TableCellData@1f942fea

True

com.strategyquant.core.gui.tables.TableCellData@6554999

com.strategyquant.core.gui.tables.TableCellData@9249289

com.strategyquant.core.gui.tables.TableCellData@32bfde3e

com.strategyquant.core.gui.tables.TableCellData@c6a4cfc

com.strategyquant.core.gui.tables.TableCellData@205fd569

com.strategyquant.core.gui.tables.TableCellData@dc2bb31

com.strategyquant.core.gui.tables.TableCellData@4140da99

com.strategyquant.core.gui.tables.TableCellData@1f1363e1

com.strategyquant.core.gui.tables.TableCellData@413919f7

com.strategyquant.core.gui.tables.TableCellData@593a39d2

com.strategyquant.core.gui.tables.TableCellData@1e69b47e

com.strategyquant.core.gui.tables.TableCellData@1a61c039

com.strategyquant.core.gui.tables.TableCellData@131e8423

com.strategyquant.core.gui.tables.TableCellData@1b62db3b

com.strategyquant.core.gui.tables.TableCellData@487b466d

com.strategyquant.core.gui.tables.TableCellData@5c8f2753

com.strategyquant.core.gui.tables.TableCellData@3b579f7d

com.strategyquant.core.gui.tables.TableCellData@3661202f

com.strategyquant.core.gui.tables.TableCellData@24bb50a0

com.strategyquant.core.gui.tables.TableCellData@1ab5edb

com.strategyquant.core.gui.tables.TableCellData@68095e4

com.strategyquant.core.gui.tables.TableCellData@395fad43

True

com.strategyquant.core.gui.tables.TableCellData@479fd498

com.strategyquant.core.gui.tables.TableCellData@1c190736

com.strategyquant.core.gui.tables.TableCellData@1e348ee4

com.strategyquant.core.gui.tables.TableCellData@5a451dd4

com.strategyquant.core.gui.tables.TableCellData@63c72910

com.strategyquant.core.gui.tables.TableCellData@37b3b2e9

com.strategyquant.core.gui.tables.TableCellData@dca5955

com.strategyquant.core.gui.tables.TableCellData@7f934e85

com.strategyquant.core.gui.tables.TableCellData@254677ce

com.strategyquant.core.gui.tables.TableCellData@fc8bd75

com.strategyquant.core.gui.tables.TableCellData@50974d28

com.strategyquant.core.gui.tables.TableCellData@3515c6d9

com.strategyquant.core.gui.tables.TableCellData@237b3fb2

com.strategyquant.core.gui.tables.TableCellData@69121dbd

com.strategyquant.core.gui.tables.TableCellData@306f3ba

com.strategyquant.core.gui.tables.TableCellData@18bede0d

com.strategyquant.core.gui.tables.TableCellData@6242e407

com.strategyquant.core.gui.tables.TableCellData@1bc4f207

com.strategyquant.core.gui.tables.TableCellData@2f6b59e6

com.strategyquant.core.gui.tables.TableCellData@414bb4b0

com.strategyquant.core.gui.tables.TableCellData@34dc1242

com.strategyquant.core.gui.tables.TableCellData@8348a14

 

 

 

 

Second question is

Is it possible to add CGAR (Compound Annual Growth Rate) to availble column in Databank sheet

 

 

Thank you!

 

Select strategies you need to export, click on arrow down of the Save button – choose Export CSV. Then open CSV in Excel and go through import wizard. Columns separator is “comma”

Sorry,

 

Save button – choose Export CSV

 

It shows ” not implemented yet”

I use SQ Ver 4.0.1

 

Does it meam not accomplished the function yet ?

 

Thank you

Hi, function is working in StategyQuant but not in Analyzer. Will ask developers about it and let you know

it is true, export to CSV is not yet implemented in QuantAnalyzer. We’ll add it in one of the future updates.

 

As fo radding CAGR value to the databank, it is simple, it is described in steps 3. and 4. of the following atricle:

https://strategyquant.com/doc/article/add-new-statistical-value.html

 

You can use the constant StatsConst.CAGR instead of string.