|
I played around some famous Web API to download stock data in O/H/L/C/V format.
but the data is only daily and I need to convert daily data into weekly data.
I searched on Internet and find something only in Python or R.
there is no C# approach available and I try to post my question here.
diligent hands rule....
|
|
|
|
|
Well, you've posted in the wrong place and you will not receive an answer here.
Try Q&A
|
|
|
|
|
|
I fail to understand the problem. just sum the value, no?
|
|
|
|
|
no. it is a little complicated than that...
diligent hands rule....
|
|
|
|
|
a quick internet search, just now, produced many solutions, mostly on Stack Overflow. Why ask here, and in this forum?
1. you need to group daily data into weekly data, picking a date that starts the week.
2. you need to store this data into a database so that you achieve historical data, thus your API call should only grab new data, not old, aiding in performance.
All of this can be achieved with database of choice and C#, unless you want to use something else.
|
|
|
|
|
Fortunately python is a readable language so unless what you're finding is a 1 liner that looks something like this:
weeklydata = convertFromDailyToWeekly(dailyData)
you should be able to port it to C# without too much trouble.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
thanks! this is why I try to post here to get something exciting.![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
diligent hands rule....
|
|
|
|
|
Hard to convert to weekly / monthly when you have only one day's worth.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
it is a time series and you download more than 5 year history of one symbol....
diligent hands rule....
|
|
|
|
|
If only there were some simple way to iterate over a data series…
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
it is the case. I try to find it on the Internet before I roll over my sleeves...
diligent hands rule....
|
|
|
|
|
I just now realized the slight itch on the bottom of the wrist of my mouse moving hand is probably from the teflon surface as it is slightly rough or perhaps I am allergic to the teflon . Now it's off to purchase a wrist band and to consider the recommended trackball - Cheerio
|
|
|
|
|
You need to track your balls.
Serious, buy a trackball and forget mice. Be happy.
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Or get a laptop and use a mousepad.
That's actually how I game. I am the best mousepad gamer in my area... on FPS...
|
|
|
|
|
I did not think of this earlier when you were looking for recommendations, but I bet one of our embedded gurus could convert a Dance Dance Revolution pad to a pointing device… add in a Clapper (must support 2 and 3 clap outputs for single/double click) for your mouse buttons.
You will be jamming at your standing desk!
|
|
|
|
|
Thank You for the Kind and Helpful advice . However I regret to say I am a lousy dancer and would feel embarrassed even in privacy . Perhaps some dance lessons are in order prior . Thanks again - Cheerio
PS In consideration of your thoughtful and kind suggestion I was cogitating how to employ a keyboard w/ all that commotion . It was just now revealed to me an obvious solution exists . As per link below . Collaboration is a wonderful thing it seems .
Very beautiful dance scene BIG 1988 with Tom Hanks - YouTube[^]
"When the green flag drops the bullshit stops"
|
|
|
|
|
So if you use the piano keyboard for typing…
…and down the rabbit hole.
|
|
|
|
|
|
pah... you find that only now?! 
|
|
|
|
|
No I knew that all along. That's what Auto0Generated "help" looks like 
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Hah, we had that for years in our API documentation 
|
|
|
|
|
Only one thing is missing...the word TYPICAL!
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
Xamarin isn't WinForms. 'nough said.
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
clowns
And this is a new set.
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
