Has anybody computed liquidity Measures computation in Excel?

06 February 2016 1 316 Report

Folks,

May someone please share any excel where they have computed various measures of liquidity? e.g Amihud, ILLQ, Turnover Ration etc.

I am not good to decode the mathematical notations in white papers. So, if excel has formula it will be very easy and quick for me to understand.

My data includes closing prices, volume, float-able number of shares etc

Any help please?

Tom Udelson

hi amir

I llke to look at

1. volume/shares outstanding

2.cum volume adjusted prorata for time elapsed during trading day/ 10 or 30 day average volume or( a mav of volume of period of choice)

3. relationship of bidsize to asksize time weighted

Badges
Science topic

More Ankur Sancheti's questions See All

RNA-seq DEGs downstream analysis and reporting in literature?

I used EdgeR to get the list of DEGs (differentially expressed genes) from my liver RNA-seq experiment. I have done the gene overrepresentation and GSEA based pathway analysis. I am currently...

23 February 2021 8,969 1 View

Is thr any simplest way to Sync or connect Android SQLite Database with Server using PHP and MySQL?

I need to connect my Android application Sqlite database with PHPMyAdmin mysql database to change the application data dynamically. I need the simplest way to do this this thing. Currently my...

08 February 2021 942 3 View

How to do meta analysis with agronomic data related to tillage and residue management. Pls tell software availability and result presentation?

Basis of meta analysis and whether we should take an average of data, if experiment was conducted in different years or each year results reflect a separate observation

07 June 2020 2,504 2 View

Can you please describe the below microstructure?

The below micro structure of Spindle which failed during rolling process hot rolled plates , this is having 0.39%carbon, can anyone please explain the micro structure.

12 May 2020 2,116 1 View

How to update inbuilt SQLite DB which is not updating itself while updating App from Play Store even after increment the database version?

how to update inbuilt SQLite DB which is not updating itself while updating App from Play Store even after increment the database version? When Database records changed in existing Database and...

05 March 2020 3,620 4 View

Design steps of LC filter for grid connected inverter in detail?

Inverter is spwm driven. Grid is operating at upf mode.

27 December 2019 642 2 View

Is there need to downscale CORDEX (RCM) data for our region? or Can we directly apply them after bias correcting them?

I have a query regarding data collected from CORDEX models and CMIP5 models. After reading about both, I have concluded that data from CMIP5 have to statistical downscale first then can apply for...

22 December 2019 2,655 5 View

Why pearlite shows different colours at 500 magnification?

In eutectoid rail steel , Mostly at 500 magnification it shows dark brown , yellowish or off white appearance, why it appears like that because in mild steel it appears in black color

12 December 2019 8,467 1 View

How to calculate the excitation frequency of a system (rolling stock+steel sleeper+rail pad)-when train moves with speed of 20 km/hr above the bridge?

I need to find the excitation frequency of the system (rolling stock+steel sleeper+elastomeric rail pad) which is in immediate contact just with the width of sleeper. The issue is about proving...

09 December 2019 4,777 2 View

How do i derive a relationship between the sampling time and the dead-time of a real-time system?

I am looking for a book or a paper which can help me find the relationship between these parameters.

07 September 2018 9,574 5 View

Ideas for Phd's Thesis on pricing (Marketing)?

Hi everyone, I'm studying Marketing and I would like to write my PhD thesis on the topic of pricing. Any specific ideas?

02 March 2021 9,706 5 View

Should we change media after1st 6hrs after plating HUVEC bought from INVITROGEN?it's not recomended by invitrogen.Will DMSO present in stock matter?

We have HUVEC bought from Invitrogen. Cat no -C-003-5c. while first plating the cells we have bought the protocol suggests not to centrifuge the cell with media to remove the DMSO. Should we...

02 March 2021 3,713 2 View

Where can I find life cycle inventory or assessment of non woven materials?

Dear network, I am looking for the LCA or LCI or at least the energy balances of the non woven fabrics process for my master project, in specific for natural fibers, yet I have found...

02 March 2021 9,662 1 View

Why initial concentration of Pb not the same as calculated one when testing using AAS?

I am currently doing research on the adsorption of heavy metal using magnetic reduce graphene oxide. I use AAS to determine the concentration of the heavy metal. I prepare the Pb solution with...

26 February 2021 9,580 4 View

Is there anyone who experienced with cytotoxic effect of Hoescht 33342 dye?

Is Hoechst toxic to cells? In general, it is known as non-toxic. I am working with dsRED MDA-MB-231 cell line. I applied it for my PDMS-based microfluidic platform, for this reason, I incubated...

26 February 2021 9,119 3 View

Is there any one who can provide a donation of HPV detection and genotyping kits in exchange collaboration forms?

Warm greetings! My name is Ayichew S. and I am doing my Ph.D. in Medical Microbiology focusing on Human papillomavirus). At this stage, I have almost completed a clinical sample (Cervical swabs)...

25 February 2021 3,612 3 View

Diltuions for a Western blot?

I need help using the equation C1V1=C2V2 figuring out how much antibody to add to use for a western blot. The stock was origianlly 3.45 ng/ul but diluted 1:10 so now its 0.345 ng/ul. I need to run...

22 February 2021 9,901 3 View

What are alternatives for B27+ Supplement in neuronal cell culture?

Hello everybody In our iPSC-derived neuronal culture we use Maturationmedium, supplemented with B27+. As Thermo Fisher run out of stock and can deliver earliest in May, I wanted to ask whether...

16 February 2021 3,348 1 View

How to find orthotropic material properties?

I am doing an impact analysis of bullet on a plate. But for that simulation, I require orthotropic properties of materials like PPS and PEEK which are Unidirectional type. How to find them?...

16 February 2021 8,775 2 View

How can we assess applied digital skills and soft skills through online examinations during COVID-19 semester?

The final qualification assessment for major programs is a strict regimen that involves different stages - oral and written exams, final project viva, internal and external review. How are ICT...

16 February 2021 1,762 8 View