 |
rob_h00
2022-05-11 08:36:13
|
|
New to this and have been trying to build a Download to key some data from the below url
https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
I have 2 questions:
1) How to format date
2) I get the following error and do not know how to correct
t seems like the 'Date' value is incorrect --> 01/00/1970 00:00:00 --> File : https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
Error parsing column 'dividendrate' --> Value: "1.10" --> File : https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
Error parsing column 'beta' --> Value: "0.17" --> File : https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
Error parsing column 'trailingpe' --> Value: "22.99" --> File : https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
Error parsing column 'pricetosalestrailing12months' --> Value: "0.82" --> File : https://query2.finance.yahoo.com/v10/finance/quoteSummary/WOW.AX?modules=summaryDetail
You must remove column : dividendrate - line n�0
You must remove column : beta - line n�0
You must remove column : trailingpe - line n�0
You must remove column : pricetosalestrailing12months - line n�0
|
(by The trader,
uploaded several months ago)
No notes
|
|
|
|
 |
QuantShare
2022-05-18 19:23:04
0
|
|
Sorry for the delay
1/ In the "CSV Settings" form, there is a "Date Type" and "Date separator" field along with "Time" fields.
2/ Maybe you need to specify double quotes " in the "Text Qualifiers" field to remove the double quotes for the values
Please contact support by email if you have any further questions.
|
|
|
|
|
rob_h00
2022-05-20 01:33:01
0
|
|
Thanks for the reply have no managed to import the data.
One more question is how to check if attribute in the json file exsist
|
|
|
|
|
QuantShare
2022-05-23 20:53:43
0
|
|
How do you access the json data in C#? Where?
|
|
|
|
|
rob_h00
2022-05-25 03:26:33
0
|
|
Hi There, This is the URL in which I access json file
string symbol = (string)Functions.GetValues("q");
Functions.AddURL("https://query2.finance.yahoo.com/v10/finance/quoteSummary/" + symbol + ".AX?modules=summaryDetail","Downloading...");
|
|
|
|
|
QuantShare
2022-05-26 12:16:52
0
|
|
The URL-script is just for generating URLs to be downloaded and parsed by QuantShare.
Accessing the data is done later in "CSV Settings" (programmatically using Pre-script and Post-script)
Please contact us by email to support at quantshare dot com for any further questions
|
|
|
|
|
0
